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


12 - 10

Teradata RDBMS Database Administration Chapter 12: Troubleshooting

Tools for Troubleshooting Client Connections

Tool

Description

Reference

Resource Check Tools

Use these tools to detect hangs or slowdowns as follows:

Tool Description
dbschk Checks responsiveness of Teradata RDBMS (in a manner similar to ping for the network). You can run it as: An interactive command-line utility A background task (with or without writing to a default or specified log)
nodecheck Displays local, node-level resources only. Provides summary data to syscheck for analysis.
syscheck Detects and reports any resource that falls below its pre-defined dangerous level.

Teradata RDBMS Utilities

At UNIX command prompt: man dbschk man syscheck At DOS command prompt:

pdehelp dbschk pdehelp syscheck

SCANDISK

See Ferret in this table.

SHOWFSP

See Ferret in this table.

ShowLocks

Tool that identifies and displays all active host utility (HUT) locks placed on databases and tables by ARC operations.

To release HUT locks, start an ARC session and submit the RELEASE LOCK command. (To prevent this in future, use the RELEASE LOCK option of the DUMP command.)

Teradata

Archive/Recovery Utility Reference

NetVault Application Plugin Module User's Guide for Teradata Teradata RDBMS Utilities

SHOWSPACE

See Ferret in this table.

Software_Event_Log

System view in DBC that provides information about errors or system failures and their severity, diagnostic information, and so on.

"Viewing the SW_Event_Log" on page C-8

Teradata RDBMS Data Dictionary

stune (UNIX)

File you can use to help prevent UNIX panics (and thus system crashes) by modifying the LOTSFREE, DESFREE, and MINFREE parameters.

"Adjusting Available Free Memory (UNIX MP-RAS)" on page 12-11

streams log (in /var/adm/streams) (UNIX)

Reports the condition of system hardware and UNIX activity.

Appendix C: "Error Logs"

Supervisor facility

Enables up to four command-line utilities and to operate on Teradata RDBMS simultaneously. Accessible from the DB Window and, on Windows 2000, Teradata MultiTool.

Teradata RDBMS Utilities

12 - 10 Teradata RDBMS Database Administration

Chapter 12: Troubleshooting

Tools for Troubleshooting Client Connections

Tool Description Reference
syscheck See Resource Check Tools in this table.
Table Rebuild Utility that rebuilds tables the RDBMS cannot recover automatically. Table Rebuild can rebuild: The primary or fallback portion of a table The entire table (both primary and fallback portions) All tables in a database (including stored procedures) All tables that reside on an AMP vproc Note: If you request a rowrange lock, a table-level lock is substituted on tables that have a PPI. "Checktable" on page 12-2 Teradata RDBMS Utilities
TableSize System view in DBC that provides information about perm (not spool) disk space usage, by database and table, for each AMP. Teradata RDBMS Data Dictionary
tdnstat Command-line utility that gives you a current snapshot or a differences summary of statistics specific to Teradata Network Services. "Tools for Troubleshooting Client Connections" on page 12-8
Teradata MultiTool (Windows 2000; for UNIX, see DB Window) GUI program invoked from the Start menu on a Windows 2000 Server. Use this tool to view the states of AMPs and disks and execute commands via the Console Subsystem. Teradata RDBMS Utilities
Teradata Manager (runs on Windows 2000, manages an RDBMS for UNIX or Windows 2000) Administrative application that allows you to view the current Teradata RDBMS configuration and the state of its components. Troubleshooting capabilities include: Teradata Performance Monitor for checking down resources An error log analyzer for determining available space Teradata Manager User Guide Teradata Manager online help
Update DBC Recalculates PermSpace and SpoolSpace for user DBC in DBase table, then based on DBase values, MaxPermSpace and MaxSpoolSpace in DBC.DataBasesSpace for all databases. Teradata RDBMS Utilities
Update Space Recalculates temporary or all space values for one or all databases, or just spool space for a specified database.
Vproc Manager Utility that you use to recover if an AMP stays down after restart. Allows you to view the status of the AMPs and to perform such administrative functions as: Initializing an AMP Forcing a manual Teradata RDBMS restart Chapter 9: "Stopping and Restarting the System" Teradata RDBMS Utilities

12 - 10

Teradata RDBMS Database Administration Chapter 12: Troubleshooting

Tools for Troubleshooting Client Connections

Tool Description Reference
xctl (UNIX; for Tool that allows you to display or modify the global PDE Teradata RDBMS Utilities
Windows 2000, control parameters.
see ctl)
xperfstate (UNIX) PDE tool that monitors the state of system components in real time.

12 - 10 Teradata RDBMS Database Administration
Previous << 1 .. 142 143 144 145 146 147 < 148 > 149 150 151 152 153 154 .. 218 >> Next