16.10 - WFIND - 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 WFIND command displays the WAL log cylinders containing WAL log records in a specified range of WAL log sequence numbers or, if no range is specified, displays all WAL log cylinders.

Syntax

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


/S
Displays the first WCID and first WDBD within the range.
/M
Displays the first WCID, the first WDBD, all intervening WCIDs, and the last WCID and last WDBD within the range.
/L
Displays all WCIDs and WDBDs within the range.
wlsnrange
Specifies one or a range of WAL cylinders and WAL data blocks based on the WAL log sequence number (WLSN) in the record header. To define wlsnrange, use this syntax: