in black and white
Main menu
Share a book About us Home
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics

Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1 - NCR

NCR Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1 - NCR, 1998. - 315 p.
Download (direct link): inntroduktionteradata1998.pdf
Previous << 1 .. 54 55 56 57 58 59 < 60 > 61 62 63 64 65 66 .. 76 >> Next

0 or 1 row/node Sctl
1-3 rows/node Svpr
0-2 rows/node Shst

Introduction to the Teradata RDBMS for UNIX

System Administration Performance Monitoring

Performance Monitoring


Several facilities exist for monitoring and controlling system performance. This section briefly discusses many of these facilities.


The TDP User Transaction Monitor (TDPTMON) is a client routine that enables a system programmer to write code to track TDP elapsed time statistics.

System Management Facility

The System Management Facility (SMF) is available in the MVS environment only.

This facility collects data about Teradata performance, accounting, and usage.

Data is grouped into the following categories:

• Session information

• Security violations

PE stops

The Performance Monitor/Application Programming Interface The PM/API (PM/API) provides hooks into server performance monitoring

routines. You initiate data collection using the SET COLLECT DBW command.


Introduction to the Teradata RDBMS for UNIX
System Administration Performance Monitoring

Monitoring Performance

Gateway Control Utility

The Performance Monitor (PM) utility provides support for user-developed and NCR-developed applications to monitor Teradata activity within production environments.

Access to the RDBMS from the PM is provided by a session partition named the MONITOR partition. To use the monitoring and control facilities, you log on to the RDBMS and then gain access to a MONITOR partition.

PM commands permit you to do the following:

• Examine:

• Current system configuration

• Global summary of system status

• Activity and current status on a session-by-session basis

• Resource usage on a processor-by-processor basis

• Set the system-wide rate for updating:

• Session level statistics

• Resource usage statistics

• Obtain the name corresponding to a given session id, user/database id, or table id

• Abort session activity and (optionally) log the specified session or sessions off

The Gateway Control Utility is a package that supports management of Teradata servers connected to a local area network. The utility provides controls for ensuring that network-attached clients do not damage or in any way modify the operating parameters of other network-attached clients.

Services offered by the utility include:

• Displaying configuration information

• Displaying session status information

• Displaying session debugging information

• Enabling/disabling logons

• Enabling/disabling session event tracing

Introduction to the Teradata RDBMS for UNIX

System Administration

System Utility Software

System Utility Software

System utilities are used to perform maintenance functions on the Teradata RDBMS. They are invoked from the Database Window with the following exceptions:

Utility Name Runs under . . .
xmppconfig UNIX as an application
pdeconfig UNIX as an application
DIP control of BTEQ
XPT UNIX as an application.
xperfstate UNIX as an application.

The system utilities include:

Utility Name Function
AbortHost Aborts outstanding transactions.
Checktable Checks for table inconsistencies.
Config Specifies logical database configuration (AMPs and PEs).
XCTL Displays and modifies the fields of the Control Parameters Globally Distributed Objects (GDO) of the Parallel Database Extension (PDE) software. Accessed from an xterm window.
DBSControl Specifies global runtime flags for database software.
VprocManager Provides status for vprocs and permits manipulation of their attributes.
GtwClobal Manages LAN connections.
Ferret Displays and sets various disk space utilization attributes without destroying the data for which the File System is responsible. For new attributes, Ferret reconfigures the stored data dynamically to match them.
Filer Displays information used to correct problems within the File System.


Introduction to the Teradata RDBMS for UNIX
System Administration

System Utility Software

Utility Name Function
pdeconfig Allocates virtual processors to physical resources, including all of the following: • Configuring disk arrays • Assigning logical units (LUNS) to the disks • Allocating disks to AMPs • Allocating LANs and channels to PEs Always run xmppconfig before running pdeconfig.
QryConfig Displays the current database software logical configuration.
QrySessn Displays session status information.
RcvManager Displays recovery status.
Rebuild Reconstructs tables from fallback copies (only works when fallback and clustering are used).
Reconfig Redistributes disk data automatically whenever AMP vprocs are added or removed.
Showlocks Displays special utility locks on databases and tables.
SysInit Initializes the Teradata system tables and all user tables.
xmppconfig Sets up and updates configurations. Use this utility to specify the physical configuration before running pdeconfig.
Previous << 1 .. 54 55 56 57 58 59 < 60 > 61 62 63 64 65 66 .. 76 >> Next