Fault Isolation Diagnostics | Teradata Vantage - 17.00 - 17.05 - Fault Isolation Diagnostics - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

Fault isolation features capture information specific to the fault without requiring a reset. These failure diagnostics facilitate early analysis of problems before the associated dump is available for examination.

Content and abort handling depends on whether the fault being isolated occurred in the parser, an AMP, or Dispatcher, as described in the following table.

Type of Fault Isolation Description
Dispatcher The Dispatcher prequalifies a fault for fault isolation.

If the fault qualifies for fault isolation, the Dispatcher captures diagnostic data and then aborts the transaction. If the transaction abort completes successfully, then the system avoids a DBS reset.

The diagnostic data consists of a snapshot dump, user session related data, stack backtrace, and the SQL request if it is available. (The last three items listed are captured in the system error log.)

Note, however, that a DBS reset occurs if the fault fails to qualify for fault isolation, or if the system cannot complete the abort of the transaction successfully.

Parser The parser issues a transaction abort and the Snapshot Dump facility captures the cause of the problem.

The data capture includes the dispatcher worker task containing the query text.

AMP (Spool Table) Teradata attempts to recover from the spool error without a reset.

Typically, such an abort is accompanied by an optional Snapshot Dump to help Teradata Services analyze the reason for the AMP failure.

Aborts generated by the AMP Fault Isolation feature:

  • Return a detailed text description of the AMP failure to the associated client session.
  • Log diagnostic details of the failure to the system error log. AMP Fault Isolation also performs this error-logging when the system reset cannot be avoided.
If you need to tune AMP Fault Isolation, contact Teradata Services. They can help modify the settings to:
  • Reduce the cases for which the aborts are enabled.
  • Disable the feature entirely to force a Teradata reset and a dump on the next occurrence of the failure.