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


Chapter 12: Troubleshooting

Tools for Troubleshooting Client Connections

Tools for Troubleshooting Client Connections

Channel Connection Tools

The tools you can use to monitor session and TDP activity and performance on channel-connected (mainframe) clients include:

Tool Description Reference
HSI timestamp Host System Interface (HSI) timestamps tell you when TDP receives a request, when the request parcel is sent to or queued for Teradata RDBMS, and when the response parcel is received from Teradata RDBMS. Teradata Director Program Reference
TDPUTCE TDP User Transaction Collection Exit (TDPUTCE) collects statistics about all of the requests and responses controlled by the TDP, including user, session/request parcels, timestamps, request type, and request/response parcels. Your site is responsible for processing and analyzing the data collected by TDPUTCE. Teradata Director Program Reference
MVS SMF System Management Facility (SMF) is a mechanism that provides accounting and performance information on MVS, such as: Statistical information about the processing activity of a PE recorded at shutdown. Log-off session information, including the use of client and Teradata resources for a session. Logon violations and security violations records. Statistical information about the processing activity of the TDP, recorded at shutdown.

Network Connection Tools

The following tools let you monitor and control sessions originating from network-attached clients.

Tool Description Reference
tdnstat Command-line utility that gives you a snapshot, or a snapshot differences summary, of statistics specific to Teradata Network Services. You also can clear the current network statistics. Teradata RDBMS Utilities

12 - 10 Teradata RDBMS Database Administration Chapter 12: Troubleshooting

Tools for Troubleshooting Client Connections

Description

Reference

Command-line utility with commands that let you monitor network and session information.

IF you want to ... THEN use this command ...
get network configuration information DISPLAY NETWORK
see all sessions connected via the gateway DISPLAY GTW
see status information for a selected gateway session DISPLAY SESSION
force off one or more network sessions KILL

"The Network Gateway" on page A-34

"Diagnosing SSO Logon Errors (Windows 2000 only)" on page 12-14

Teradata RDBMS Utilities

12 - 10 Teradata RDBMS Database Administration

Chapter 12: Troubleshooting

Tools for Troubleshooting Client Connections

Tools for Troubleshooting Hardware

This section lists helpful tools for diagnosing and resolving hardware problems.

Finding Hardware Component Faults

The following tools are helpful for pinpointing hardware conditions:

IF you want to check ... THEN use .
the status of each component, including nodes, DBW consoles, and the BYNET AWS console
for a down component, such as AMP, PE, or BYNET Teradata Performance Monitor
for component errors Software_Event_Log
for hardware events (UNIX MP-RAS) / var/adm / streams log

Finding a Saturated Resource

Use the Resource Check Tools to check for saturated resources.

IF . THEN .
dbschk is not already running as a background task run dbschk interactively to check current Teradata RDBMS response time.
the dbschk log, or current display, shows a slow response or timeout run syscheck to obtain a report showing any attribute that falls below the specified danger level.
no attribute is reported as being at the WARN level check disk and AMP CPU usage

Resolving Lack of Disk Space

This section provides suggestions for analyzing and solving lack of disk space.

12 - 10

Teradata RDBMS Database Administration Chapter 12: Troubleshooting

Tools for Troubleshooting Client Connections

IF you ran ... And the results show that . THEN resolve it by .
DBC.DiskSpace Teradata Manager to invoke the error log analyzer Teradata Manager to invoke the error log analyzer the system is low on available permanent space Run PACKDISK. Set spool limits on users. Run DEFRAGMENT. Clean out system logs. Consider adding disks.
a very large spool is being requested Use Query Session or Performance Monitor to find the job requiring the space, then cancel the job with one of: - Performance Monitor (Windows 2000 and Teradata Manager) - TDP LOGOFF command - Gateway KILL command Confer with the applications programmer to correct the structure of the SQL query.
SHOWSPACE (Ferret) SHOWFSP (Ferret) to find good candidates for packing Software_Event_Log to check the time and frequency of cylpacks. the system has adequate disk space, but is out of free cylinders. Run PACKDISK on the tables reported by ShowFSP; specify an increased free space amount. If necessary, use DBS Control utility to change FreeSpacePercent globally (but you will have to do a tpa restart). If necessary, use ALTER TABLE to change the free space percent for one or more growth tables.
Previous << 1 .. 143 144 145 146 147 148 < 149 > 150 151 152 153 154 155 .. 218 >> Next