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


10 - 20 Teradata RDBMS Database Administration

Chapter 10: Handling Teradata Crashdumps

Unloading PDE Crashdumps on Windows 2000

follow the instructions under "Accessing NCR Knowledge Articles for Instructions" on page 10-26.

Step Action
1 Load the tape into the tape drive on any Teradata RDBMS node.
2 At a client workstation on the same node, enter the command: $ dultape
3 The DULTAPE utility prompts for the tape drive path: Dump Unload/Load To Tape - Please insert tape and input tape device name Enter tape drive path and device name.
4 The DULTAPE utility prompts for the logon sequence. User your administrative user name and password: .logon crashdumps Password: crashdumps Note: The default password to user crashdumps is "crashdumps." However, DBAs are encouraged to change the password. Consult your DBA for the password to user crashdumps.
5 Get a list of the PDE crashdump tables with the command: help database crashdumps; Note the semicolon at the end. The utility responds with: help database crashdumps; *** Sending ' HELP DATABASE crashdumps;' to DBC. *** Help information returned. 8 rows. Crash_96 03 01_1143 3 6_0 6 Crash_96 03 01_14424 9_0 8 Crash_96 03 01_14 522 6_0 9 Crash_96 03 01_14 5715_10 Crash_96 03 03_1610 07_12 Crash_96 03 04_10 0 72 5_14 Crash_96 03 0 7_142 52 5_01 Crash_96 0312_12 5443_02 Dump Unload/Load to Tape - Enter your command:

10 - 20

Teradata RDBMS Database Administration Chapter 10: Handling Teradata Crashdumps

Unloading PDE Crashdumps on Windows 2000

Step Action
6 Display the PDE crashdump table content by entering the command: see Crash_960301_114336_06; The DULTAPE utility returns the basic PDE crashdump information: see Crash_960301_114336_06; *** Looking at Crash_960301_114336_06. *** Query completed. One row found. 7 columns returned. the node number is 1024 the instigating node is 1024 the time the error occurred is Fri Mar 1 11:43:36 1996 the event is 12141, severity is 40 and category 10 Severity = UserError Category = User Dump Unload/Load to Tape - Enter your command:
7 Enter a Select command. You can select data from a single node, or multiple nodes, with commands similar to the following: $ SELECT proc 1024; $ SELECT proc 1024 1025 1026; You can obtain processor numbers came from the csppeek utility as vproc IDs. You can select data from a certain node and select only error messages from Software_Event_Log that are later or equal to a certain date: $ SELECT errordate '960301' proc 1024; If the crashdump name includes the four-digit year format, use: $ SELECT errordate 49960301' proc 1024; The default is to select all data from the CRASHDUMPS table and all messages from Software_Event_Log.
8 Unload the PDE crashdump to tape with the command: $ UNLOAD crashdumps.Crash_96 03 01_1143 3 6_0 6 file=file_name where file name is the destination file name. You can obtain the Node ID from the Cabinet-Node number via the csppeek utility.
9 Exit the DULTAPE utility. Enter the command: quit;
10 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.

10 - 20 Teradata RDBMS Database Administration

Chapter 10: Handling Teradata Crashdumps

Unloading PDE Crashdumps on Windows 2000

Using DUL on IBM VM or MVS Client

The DUL utility is the mainframe version of the DULTAPE utility. It runs similarly to the DULTAPE utility.

To run the DUL utility, at the prompt enter the DUL V2 command:

<Ready> dul v2 The response is:

Host application environment: H.2.0

Press the <ENTER> key after the tape drive has been attached to TL1 as 181 or

enter QUIT to exit DUL

TL1 is user id of the user.

The rest of the operation is the same as the DULTAPE utility described above.

10 - 20

Teradata RDBMS Database Administration Chapter 10: Handling Teradata Crashdumps

Unloading PDE Crashdumps on Windows 2000

Unloading PDE Crashdumps on Windows 2000

You can unload crashdumps saved as flat files to tape using Backup Wizard or from table rows in DBC.Crashdumps to disk or tape using DUL/DULTAPE. If you are unsure of what to do, contact the TSC for assistance.

Using Backup Wizard to Save to Tape

To copy crashdumps saved as ".dbm" flat files to a backup tape, use the following procedure:

Step

Action

Insert backup tape into the tape drive.

Select Start -> Programs -> Accessories -> System Tools -> Backup.

When the Backup Wizard panel appears, select the Backup tab. The Backup window appears:

1

2

3

10 - 20 Teradata RDBMS Database Administration

Chapter 10: Handling Teradata Crashdumps

Unloading PDE Crashdumps on Windows 2000

Step Action
4 In the Backup window, select the drive and folder where the dump files are located. The default path is D:\Program Files\NCR\TDAT\tdConfig\pdedumps.
Previous << 1 .. 135 136 137 138 139 140 < 141 > 142 143 144 145 146 147 .. 218 >> Next