15.00 - WREC - Teradata Database

Teradata Database Support Utilities

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

WREC

Purpose  

The WREC command returns a formatted display of WAL log records based on the WAL log sequence number (WLSN) in the record header. If no range is given, all of the records are displayed.

Syntax  

Note: The online help lists the display options (/P, /S, /M, /L, /X, /H, /V) as /dispopt. You can type the options at the beginning or end of the command.

 

Syntax Element

Description

/P

Positions to the WAL log record. Nothing is displayed unless there is a problem.

/S

Displays a count of the selected WAL log records.

/M

Displays the type, WLSN, and other generic WAL log record headers, in addition to the information displayed by the /S option.

/L

Displays the type-specific WAL log record headers for NONTJ and TJ records, in addition to the information displayed by the /M option.

/X

Displays the change data (before and after images) in hexadecimal, in addition to the information displayed by the /L option.

/H

Displays the header in hexadecimal, in addition to the information displayed by the /L option.

/V

Validates the WAL log records instead of displaying them. This option performs as much checking as possible without running SCANDISK, which requires starting the normal file system. For more information, see “SCANDISK” on page 188.

wlsnrange

Selects one or a range of WAL log records based on the WAL log sequence number (WLSN) in the record header, instead of selecting the records by ordinal position within the log.

If you do not specify a wlsnrange, the whole WAL log is displayed.

To define wlsnrange, use this syntax:

whereclause

Restricts the selection to a subset of the WAL log records within the range based on the field content of the records. For more information, see “Specifying a WHERE clause” on page 85.

Usage Notes  

The wlsnrange selects records based on the WAL log sequence number (WLSN) recorded inside the log records. To select records by ordinal record number (such as 1st, 10th, or 5th WAL log record from the end), use the WAL command, which accepts an ordinalrange argument. For more information, see “WAL” on page 223.

The whereclause for the WREC command is applied in conjunction with the wlsnrange. The whereclause is recorded as part of the context and remains active for subsequent DISPLAY, NEXT, and PREV commands.