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 .. 140 141 142 143 144 145 < 146 > 147 148 149 150 151 152 .. 218 >> Next


Hcvic/cr ^ou can configure Windows ZOOO to Juiii|. uily kc iicl ard aDtve p-oces; Tiermrv UDon ; StDper--Cr In this Capej a paging file ^iic uf IOGO MD i= sufficient - Mule

information or creatine memari Hi Irp^j cpp To canfiqure the W ndgws 2000 recovery method.

n3t_Lc:icn3 Dn choncirgthc psg n] "ile Sizej see Io change :he si:e of the v rtual memory Daaha file.

start I J ?3 -JjBack^ - [U I Te-adataN.

' Ssardi

3

a

b

c

11 - 10

Teradata RDBMS Database Administration Chapter 11: Handling System Dumps

Handling Windows 2000 System Dumps

Step

"3

cont

Action

IF you .

THEN .

do have the NCR State Saver

use it if you need to reconfigure your dump settings. To access the interactive help, select:

Start -> Programs -> NCR State Saver -> NCR State Saver Help

The dump setting help display appears in the State Saver Help window:

11 - 10 Teradata RDBMS Database Administration

Chapter 11: Handling System Dumps

Sending Dumps to the Teradata Support Center

Sending Dumps to the Teradata Support Center

You can get additional instructions on how to send dumps to the TSC by using NCR@YourService to access Knowledge Articles. (For instructions on how to access Knowledge Articles, see "Accessing NCR Knowledge Articles for Instructions" on page 10-26.)

Note: If your dump is a Windows 2000 operating system dump, use the File Transfer Program (FTP) to send the dump online to the TSC.

When you have an NCR@YourService account, access the following articles to upload dump files:

For instructions on how to send TSC your. See the Knowledge Article . Titled.
UNIX system dumps S1100095972 How to Upload UNIX Panic Dumps To The TCSE
UNIX MP-RAS pde crashdump SA10007F12A How to Upload Teradata Crashdumps To The TCSE
Windows kernel dumps S11000A6C3A How to upload W2K/NT Kernel Dumps Note: This procedure covers how to upload W2K kernel dumps.
Windows pde crashdumps S11000A66CE How to upload a W2K/TNT Crashdump

To mail dumps written to tape, use the following procedure.

Note: The version, incident number, and volume number are necessary in order for the TSC tester to know which installation the dump is reporting and how to load the tape properly.

Step

Action

TSC service will be faster if you label every cartridge with:

The incident number

The Teradata RDBMS version number (for example, 04.01.00.00 or 4.1.0.0).

If you are sending multiple tapes or cartridges, identify the place of each volume in the set by writing a volume number on each cartridge (it can be handwritten), such as 1 of 4, 2 of 4, and so forth.

11 - 14

Teradata RDBMS Database Administration

1 Chapter 11: Handling System Dumps

Sending Dumps to the Teradata Support Center

Step Action
2 Write the incident number on the outside of the package. It also helps if you
include your name or some other person to contact as part of the return
address.
Note: Please always include the incident number and identify if the dump is
a PDE crashdump or UNIX dump.
3 Address the package to:
Dump Administrator
Teradata Customer Support Engineering
17095 Via del Campo
San Diego, CA 92127
Please include the following:
Label the outside of tape or cartridge with the VolSer and Call
Log/Sentinel Incident number. If the tape is non-labeled, you must make
up an external VolSer number for identification purposes.
Call Log/Sentinel Incident number must be visible on OUTSIDE of
package.

11 - 14 Teradata RDBMS Database Administration

Chapter 11: Handling System Dumps

Sending Dumps to the Teradata Support Center

11 - 14

Teradata RDBMS Database Administration Chapter 12:

Troubleshooting

This chapter helps you find the causes of and resolve performance problems. It includes information on:

Tools you can use to find and analyze problems

Troubleshooting a hung or slow job

Finding inconsistent rows and revalidating headers for tables with RI constraints and PPIs

Using Teradata features to prevent job hangs and slowdowns

Expanding your Teradata RDBMS configuration

Teradata RDBMS Database Administration

11 - 1 Chapter 12: Troubleshooting

Tools for Troubleshooting Client Connections

Tools for Troubleshooting Teradata RDBMS

This section lists the tools you can use to prevent, analyze, and correct behavior and existing or potential problems on your Teradata RDBMS.

Tools that are available only on one type of operating system are identified as either UNIX or Windows 2000. If a tool is available on both platforms, no operating system is noted.

Note: If a query against a system view returns the error "View not found", run the DIP utility and execute DIPVIEW (system tables and views). For more information, see "Database Initialization Program (DIP)" on page E-2.

Tool Description Reference
AWS console Administrative workstation for an MPP installation. Displays the status of each physical component, including nodes, DB Window consoles, and the BYNET. Administrative Work Station manuals AWS on Windows 2000 User Guide "DB Window" on page 12-2
Previous << 1 .. 140 141 142 143 144 145 < 146 > 147 148 149 150 151 152 .. 218 >> Next