Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 127 128 129 130 131 132 < 133 > 134 135 136 137 138 139 .. 218 >> Next


All the tasks within the same vproc

10 - 2

Teradata RDBMS Database Administration Chapter 10: Handling Teradata Crashdumps

Dump Types

Snapshot Dumps are saved in the same format and handled in the same manner as PDE crashdumps.

You can set Snapshot Dumps on or off by setting the Snapshot Crash field in SCREEN DEBUG (in xctl for UNIX or ctl for Windows 2000).

Fault Isolation Diagnostics

Fault isolation features capture information specific to the fault without requiring a reset.

These failure diagnostics facilitate early analysis of problems before the associated crashdump is available for examination. Content and abort handling depends on whether the fault being isolated occurred in the parser or on an AMP, as follows:

IF the transaction abort was caused by . THEN the .
Parser Fault Isolation 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) Fault Isolation TPA recovers from the spool error without a TPA reset. Typically, such an abort is accompanied by an optional Snapshot Dump to help the Teradata Support Center (TSC) 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. Note: If you need to tune AMP Fault Isolation, contact the TSC. The TSC can help modify the settings to: Reduce the cases for which the aborts are enabled. Disable the feature entirely in order to force a TPA reset and a crashdump on the next occurrence of the failure.

10 - 2 Teradata RDBMS Database Administration

Chapter 10: Handling Teradata Crashdumps

PDE Crashdumps versus System Dumps

PDE Crashdumps versus System Dumps

A system dump is different from a PDE Crashdump in content and size, and thus in what is stored. Typically, a PDE crashdump is smaller than the size of memory. Dump size varies according to the cause of the dump and your Teradata configuration.

Following are the general differences between the two types of dumps:

Dump Type Description
System System dumps contain a full memory image for the node.
dumps The total size of the dump area should be equal to the node
memory size.
Each System dump fills up the entire dump area.
PDE crashdumps PDE crashdumps contain only selected parts of memory, so the system can capture multiple PDE crashdumps in a single dump slice. If an unsaved PDE crashdump is present and an event causes the system to take another PDE crashdump, the system appends the new PDE crashdump to the end of the existing one. The system can capture as many PDE crashdumps as will fit in the first dump slice.

10 - 4

Teradata RDBMS Database Administration Chapter 10: Handling Teradata Crashdumps

PDE Crashdumps Processes

PDE Crashdumps Processes

The processes for handling PDE crashdumps are as follows:

Process

Description

Capture a dump

IF your server OS is . THEN the process is .
UNIX MP-RAS writing the contents of memory to internal disk. This occurs on all nodes of the system at approximately the same time.
Windows 2000 writing the selected memory contents to the PDE crashdump directory. This occurs on all nodes of the system at approximately the same time.

Save a dump using the Copy Save Program (CSP)

IF your server OS is . THEN the process for default dumps is .
UNIX MP-RAS transforming raw PDE crashdumps into table rows in the DBC.Crashdumps database. The system automatically saves crashdumps by default. (For more information, see "Handling PDE Crashdumps on UNIX MP-RAS" on page 10-20.)
Windows 2000 transforming raw PDE crashdumps into formatted flat files in ".dbm" format (unless you override the default and directed them to DBC.Crashdumps). For information on where the flat files are located and how to save them, see "Handling PDE Crashdumps on Windows 2000" on page 10-22 m.

Copy a dump to external media

IF your server OS is . THEN the process is .
UNIX MP-RAS copying a dump from the table in DBC.Crashdumps to tape, or to a UNIX file for copying to some other media.
Windows 2000 copying a dump to disk or tape.You can use DUL to write to disk or DULTAPE to write to tape. For more information, see "Using DUL/DULTAPE to Save to Disk or Tape" on page 10-32.

Send a dump to the TSC

NCR recommends that you send the tape or other media containing the dump to the TSC for analysis. For instructions, see "Sending Dumps to the Teradata Support Center" on page 11-14.

1

2

3

4

Teradata RDBMS Database Administration

10 - 5 Chapter 10: Handling Teradata Crashdumps

Finding PDE Crashdump Data

Finding PDE Crashdump Data

To copy PDE crashdump files or tables to tape, you must know how to find the files and tables. This section explains how to gather the information you need.
Previous << 1 .. 127 128 129 130 131 132 < 133 > 134 135 136 137 138 139 .. 218 >> Next