Purpose
The WCI (WAL Cylinder Index) command accesses the WCI of a given cylinder of the WAL log and displays the WCI in accordance with the display options.
The FIX option of the WCI command should be used by trained Teradata personnel only, and the user must be absolutely sure that the option should be used. Inappropriate use of the FIX option may result in data loss.
Syntax
The online help lists the display options (/P, /S, /M, /L, /H, /X, /V) as /dispopt. You can type the options at the beginning or end of the command.
- /P
- Positions to the WCI. If this cylinder is not a WAL cylinder, an error occurs. Nothing is displayed unless there is a problem.
- /S
- Displays the header, trailer, and the first and last WDBDs.
- /M
- Displays the same information as the /S option.
- /L
- Displays all of the WDBDs, in addition to the information displayed by the /S option.
- /H
- Displays the WCI in hexadecimal.
- /X
- Displays the timestamp and other details from the WDB for each WDBD, in addition to the information displayed by the /L option.
- /V
- Verifies that the WCI is logically correct, but does not display it.
- FORCE
- Attempts to format and display the segment as a WCI, even if the segment is not a WCI. If the FORCE option is not used, the command fails on a mismatched block.
- FIX
- This option should be used by trained Teradata personnel only, and the user must be absolutely sure that the option should be used. Inappropriate use of this option may result in data loss.
- cylid
- The 64-bit identifier of a cylinder, entered as a 16-character hexadecimal number.
- =
- Specifies that Filer should use the most recently saved value of cylid.