16.10 - WREC - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

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

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.


/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.
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.

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.

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.