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

5 Bring up the Teradata Command Prompt window: Start -> Programs -> Teradata RDBMS -> Teradata Command Prompt
6 Type the following command sequence: ctl screen debug

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

Unloading PDE Crashdumps on Windows 2000

Step Action
7 When the screen appears, check the value of flag <4> Save Dumps. If the value is ON, turn it OFF by entering the following command sequence: 4 = off write quit Note: Verify that the values of (6) Maximum Dump and (7) Maximum Dump Size are not set to zero. If they are set to zero, you will not get a crashdump.
8 If CSP is actively saving a dump and you want to stop it, issue a tpareset command. Otherwise, go to step 9.
9 If you issued a tpareset command, wait for Teradata to come back up to at least the RUN/READY state. CSP must log on to the Teradata RDBMS to do the save. If Teradata RDBMS isn't accepting logons, CSP will not be able to save the dump.
10 Enter the following CSP command exactly as shown: csp -mode save -target table -force
11 CSP identifies the dump it's about to save and asks if you want to save it.
IF you want to . . . THEN respond by typing . . .
save this dump Yes
save this dump and all other dumps csp finds (yes to all) Yes!
throw away this dump but tell csp to keep looking for more No
throw away this dump and tell csp to stop looking (no to all) No!


10 - 20 Teradata RDBMS Database Administration

Chapter 10: Handling Teradata Crashdumps

Unloading PDE Crashdumps on Windows 2000

Unloading PDE Crashdumps on UNIX MP-RAS

When you have saved the crashdumps to DBC.Crashdumps, you have the option of unloading the crashdumps to disk or tape. If you are unsure of what to do, contact the TSC for assistance.

If you have already saved the crashdumps and have completed the backup to tape, or you want to FTP your dump to NCR, follow the procedure in "Sending Dumps to the Teradata Support Center" on page 11-14.

Note: Be sure to put the Sentinel Incident Number on the tape cartridge label(s) as well as on the shipping box.

Accessing NCR Knowledge Articles for Instructions

To access knowledge articles, you must have an NCR@YourService account. If you do not have an NCR@YourService account, contact your NCR Support Representative.

To access knowledge articles to find instructions on topics such as how to upload a crashdump using File Transfer Protocol (FTP), do the following:

Step

Action

Go to www.my.ncr.com.

Type your User id and Password and click Login. The NCR@YourService page appears.

Under NCR@YourService, click My Support Link. The My Support Link page appears.

Under Resources, click on Knowledge Repositories. The Search by Knowledge Base page appears.

In the Search field, type a keyword (such as crashdumps) or the article number and click Search.

For example, type the following into the search field: crashdumps AND SA10007F12A and click Search.

A list of documents containing the keyword crashdumps or article number SA10007F12A appears.

Click on the appropriate knowledge article for instructions.

1

2

3

4

5

6

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

Unloading PDE Crashdumps on Windows 2000

Using the DUL/DULTAPE Utility

After the raw dumps have been saved into table rows in DBC.Crashdumps, you can use the Dump Unload/Load (DUL) to save the PDE crashdumps to disk or Dump Unload/Load Tape (DULTAPE) utility to save to tape for analysis by TSC. DUL and DULTAPE are separate packages that you must order and install individually.

For more information on DUL and DULTAPE, see Teradata RDBMS Utilities Volume 1.

Use this utility . On a . To load/unload a PDE dump to/from a .
DUL node file on the node.
mainframe file or a tape.
DULTAPE node tape.

Note: DULTAPE uses the Fastload utility to copy a crashdump onto a tape. You can run multiple dultape sessions as long as the total number of sessions does not exceed the limit specified in the MaxLoadTasks field of the DBSCONTROLGDO. (MaxLoadTasks sets the limit on the total number of Fastload, Multiload, and FastExport tasks that can run simultaneously.)

You can unload dump information to several sequential files, which are:

Rows of data dumped from the AMPs

Internal load module correspondence information

Applicable rows from Software_Event_Log

By default, dump files are named:

Crash_yyyymmdd_hhmmss_nn where:

Variable Definition
yyyymmdd Year, month, and day of the dump
hhmmss Time (hour, minute, and second) of the dump
nn Sequential number associated with the dump

You can change the name using BTEQ, but remember that the timestamps are important.

Using DULTAPE on a Node Client

To save a PDE crashdump from Crashdumps, follow the steps below. For more information on DULTAPE, see Teradata RDBMS Utilities or the Knowledge Article SA100082D82. For instructions on how to access Knowledge Articles,
Previous << 1 .. 134 135 136 137 138 139 < 140 > 141 142 143 144 145 146 .. 218 >> Next