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.
- Positions to the WCI. If this cylinder is not a WAL cylinder, an error occurs. Nothing is displayed unless there is a problem.
- Displays the header, trailer, and the first and last WDBDs.
- Displays the same information as the /S option.
- Displays all of the WDBDs, in addition to the information displayed by the /S option.
- Displays the WCI in hexadecimal.
- Displays the timestamp and other details from the WDB for each WDBD, in addition to the information displayed by the /L option.
- Verifies that the WCI is logically correct, but does not display it.
- 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.
- 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.
- Attempts automatic repair of the WCI. You must supply the /V option with the FIX option, and the Teradata Database must be down.
- 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.
- This option cannot be used unless an input value has already been defined for cylid. For more information, see Stored Input Values.