SEE - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

The SEE command provides a summary of the processors and error codes captured in a dump. The information is retrieved from the dump table.

Syntax

SEE [ database. ] table ;
database
Database in which the table resides.
table
Table that contains dump information.

Usage Notes

The SEE command returns information that helps you confirm system failure information forwarded to the Teradata Support Center. Information about tables with the _L, _C, and _M suffixes is not returned.

Example: Displaying the processors and error codes from a dump

To access a specific dump table, type the following:

see crashdumps.Crash_20000412_194517_02;

The following appears:

*** Looking at crashdumps.Crash_20000412_194517_02.
*** Query completed. One row found. 7 columns returned.

 the node number is 1024
 the instigating node is 1024
 the time the error occurred is Wed April 12 19:45:17 2000
 the event is 12140, severity is 40 and category 10
  Severity = UserError
  Category = User