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 .. 136 137 138 139 140 141 < 142 > 143 144 145 146 147 148 .. 218 >> Next

5 Select the crashdump files you want to copy to tape.
6 Select the backup destination media or file name.
7 Fill out any other backup information, then click the Start Backup button on the lower right-hand panel.
8 When the backup is complete, remove the tape, label it (enter the Sentinel Incident Number and Teradata version, plus, if necessary, a volume serial number in the form 1 of n, 2 of n, and so forth), and follow the online procedures given in "Sending Dumps to the Teradata Support Center" on page 11-14.

Using DUL/DULTAPE to Save to Disk or Tape

The Dump Unload/Load utility (DUL) is a tool for moving PDE dumps from DBC.Crashdumps to disk. DULTAPE moves crashdumps from the DBC.Crashdumps to tape.

Consult the TSC before sending in crashdumps saved with DUL or DULTAPE.

IF you are using .

THEN .

DUL to save to disk

use the following procedure:

Step Action
1 To start DUL, select Start -> Programs -> Teradata DUL -> DUL.
2 DUL prompts you for your logon. Logon as user crashdumps and enter the password.
3 Enter the following command: help database crashdumps;
4 Select a crashdump table name.
5 Enter the following command: unload table file = disk file;

10 - 20

Teradata RDBMS Database Administration Chapter 10: Handling Teradata Crashdumps

Unloading PDE Crashdumps on Windows 2000

IF you are using . THEN .
DULTAPE to use this procedure:
save to tape
Step Action
1 Select Start -> Programs -> Teradata DULTAPE -> DULTAPE.
2 Insert a tape into the drive.
3 In the utility window, enter tape device name in the format \\.\tape0 See Teradata RDBMS Utilities for information on using more than one tape drive. I
4 Enter .logon tdpid/user and enter your password.
5 Enter the following command: help database crashdumps; I
6 Select a crashdump table name.
7 Enter the following command: unload table file = tape_file; Note: tape Jile name is case sensitive.


I

10 - 20 Teradata RDBMS Database Administration Chapter 10: Handling Teradata Crashdumps

Deleting PDE Crashdumps

Deleting PDE Crashdumps

You might want to delete PDE crashdumps from your disk to make room for new PDE crashdumps. You can use one of the following to delete PDE crashdumps:

Coroner utility

CSP utility

Windows Explorer (Windows 2000 only)

Using the Coroner Utility

To use the Coroner to delete a PDE crashdump, follow these steps:

Step Action
1 Start the Coroner utility by logging onto any Teradata RDBMS node and entering the command: # /usr/ntos/bin/gdb
2 In Coroner, enter the delete command: (gdb) delete dump dumpname where dumpname is the name of the PDE crashdump table.
3 To delete additional PDE crashdumps, repeat the delete command.
4 Quit the Coroner utility with the command: (gdb) quit

Using the CSP Utility

Use CSP to delete PDE crashdump tables from the UNIX prompt, and to delete formatted PDE crashdumps in a Windows 2000 Teradata Command Prompt window. The procedure is as follows:

Stage

Process

Description

List PDE crashdumps

IF your server OS is ... THEN .
UNIX Use the following command: # /usr/ntos/bin/dbgcsp -D crash yyyymmdd hhmmss nn
Windows 2000 Use the following command: csp -mode list - source -dbm

10 - 34

Teradata RDBMS Database Administration

1 Chapter 10: Handling Teradata Crashdumps

Deleting PDE Crashdumps

Stage

Description

IF your server OS is . THEN the process is .
UNIX Use a command similar to the following: # /usr/ntos/bin/dbgcsp -D Crash_9412 06_0 910 03_42 Warning: if you do not type a name, you will delete all crashdumps
Windows 2000 Use a command similar to the following: csp -mode clear Crash 19991206_091003_42 Warning: if you do not type a name, you will delete all crashdumps

2

Using Windows Explorer

On Windows 2000, use Windows Explorer to delete both raw and formatted PDE crashdump files. To delete the dumps, highlight the files and press the Delete button.

Teradata RDBMS Database Administration

10 - 35 Chapter 10: Handling Teradata Crashdumps

Deleting PDE Crashdumps

10 - 36

Teradata RDBMS Database Administration Chapter 11:

Handling System Dumps

This chapter describes how to manage and administer UNIX MP-RAS and Windows 2000 system dumps. Topics of discussion include:

Possible types of system dumps

How to view and save system dump information

Shipping dump tapes to the TSC

Teradata RDBMS Database Administration

11 - 1 Chapter 11: Handling System Dumps

System Dump Types and Locations

System Dump Types and Locations

A system dump is an image of what was in memory when the operating system crashed. The following table describes the system dumps that can occur on UNIX and on Windows 2000 systems. (For an explanation of the differences between system dumps and PDE crashdumps, see "PDE Crashdumps versus System Dumps" on page 10-4.)

Dump Type Description Area/Location
UNIX system dump The UNIX System dump is a full-memory dump, including Teradata PDE and UNIX kernel information, but only for the node or nodes that panicked. It is typically used for examining UNIX kernel problems. Since this is a complete memory dump, the size of the dump is equal to the size of memory on your system. The UNIX system dump area is one or more disk slices, reserved for the purpose at UNIX MP-RAS installation time. For nodes with more than 512 MB of memory, the UNIX system dump area is normally split into two or more slices, each on a separate system disk.
Previous << 1 .. 136 137 138 139 140 141 < 142 > 143 144 145 146 147 148 .. 218 >> Next