17.10 - SELECT - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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

Syntax

SELECT {
  ALL |
  ERROR |
  RESET |
  PROC nod-num [...]
}
[ ERRORDATE { 'yymmdd' | 'yyyymmdd' | "yymmdd" | "yyyymmdd" } ] ;

Syntax Elements

ALL
Load or unload operation select dump data from all processors. This is the default.
ERROR
RESET
Load or unload operation.
Only processors with an error code are selected.
PROC  nod-num
Unload operation.
nod-num specifies 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.
yymmdd
yyyymmdd
Error date to be selected from the DBC.SW_EVENT_LOG table.
yy or yyyy is the year, mm is the month, and dd is the day. For example, August 6, 2019 is 20200806 or 190806.
Dul retrieves all error records with a date equal or later than yymmdd or yyyymmdd.

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.