16.10 - SELECT - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

The SELECT command sets criteria determining the dump data selected for a load or unload operation.

Syntax



ERROR
Load or unload operation.
Only processors with an error code are selected.
RESET
same as ERROR.
PROC  NOD-NUM
Unload operation.
NOD-NUMspecifies the number of the virtual processor to be selected. Dump data will be loaded or unloaded only from this node. Valid values for NOD-NUM are 30720 and greater.
ALL
Load or unload operation select dump data from all processors. This is the default.
ERRORDATE ‘yymmdd’or ‘yyyymmdd’
Error date to be selected from the DBC.SW_EVENT_LOG table.
The ‘yymmdd’ or ‘yyyymmdd’ represents the year, month, and day, respectively. Dul retrieves all error records with a date equal or later than the yymmdd or yyyymmdd specification.
TD 15.10 - CMS conversion, Made title "newpage". Made table(s) proportional. Fixed image(s). Fixed parml. Updated xref(s) to be grey. Formatted codeblock(s).

You can enclose the date in either apostrophes or double quotation marks.

Usage Notes

You must always type the SELECT command before you type an UNLOAD command. If you do not specify a SELECT command, the entire dump is selected.

Negative processor numbers are used for special record types. When RESET is specified, dul retrieves dump data with negative processor numbers.

Example: Selecting dump data for load or unload

To select dump data, type the following:

select proc 16384;

The following appears:

*** Processor selection set to list of processors.