15.00 - WCI - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

WCI

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.

WARNING:

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  

Note: 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.

 

Syntax Element

Description

/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

WARNING:

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.

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.

This option cannot be used unless an input value has already been defined for cylid. For more information, see “Stored Input Values” on page 82.