16.10 - PDE Tools - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

Parallel Database Extensions (PDE) is a software interface layer that lies between the operating system and Teradata Database. PDE supports the parallelism across system nodes that contributes to Teradata Database speed and linear scalability. Many diagnostic and troubleshooting utilities work at the PDE level.

PDE tools are a collection of PDE-level utilities that come with Teradata Database. They are not documented in Utilities because PDE tools have online documentation accessible from a system console using the "man" and "pdehelp" commands.

This appendix presents a list of some of the useful PDE tools you may wish to use. These tools and more are located in the /usr/pde/bin directory.

Not all of the PDE tools are suitable for customer use without appropriate guidance from the Teradata Support Center. Consult with Teradata Support before running PDE tools that are not listed here.

PDE Tool Name

Description

ampload

Displays the AMP vproc usage of AMP Worker Tasks (AWTs) on Teradata Database, representing the load on each AMP vproc

awtmon

Collects and displays a user-friendly summary of the AMP Worker Task (AWT) in-use count snapshots for the local node or all nodes

cnsterm

PDE Console Subsystem Terminal

cnstool

PDE Console Subsystem Tool

controlgdo

Displays Control GDO contents

csp

Crashdump Save Program

cspclean

Clean up Crashdump Save Program's run time environment

cspinfo

Crashdump Save Program Information display utility

csppeek

Display useful information from a PDE dump

cspstop

Graceful shut down of the Crashdump Save Program

cspwake

Awaken the Crashdump Save Program

dmpbust

Decode PDE dump files

evtool

Displays the event message text for any event message provided by EMF

gdomview

Displays entries from the GDO changes log, to show configuration setting changes that were made to dbscontrol and ctl globally distributed objects within a given time range. Changes to these GDOs are made using the DBS Control (dbscontrol) and Control GDO Editor (ctl) utilities, respectively.

logview

System Log and Dump Utility

mboxchk

A front-end script for puma -m command monitors Teradata Database mailbox messages to detect DBS hangs

modmpplist

Modifies the node list (mpplist) file on local or all system nodes

nodecheck

Gathers and analyzes PDE vital information from local node

pcl

Parallel Command Language user interface

pdeconf

PDE configuration settings

pdeglobal

Displays the PDE global information

pdehelp

Displays Teradata tools online help

pdeinfo

Saves system-wide PDE related data

pdedrv

PDE device driver load/unload administration command

pdepath

Displays paths of Teradata running environment

pdestat

PDE System call Statistics Display Utility

pdestate

Displays the current PDE state and substate

pdestop

Brings PDE down immediately on the local node

syscheck

Runs nodecheck on all system nodes to gather and analyze PDE vital information

tdatcmd

Sets up a Teradata command shell or window

tdinfo

Displays the Teradata system configuration

tdinstall

Install a Teradata component software package

tdmaint

Tool for marking the node for maintenance and change it back

tdnstat

Teradata Network (TDN) Statistics Display Utility displays or clears network statistics

tdntune

Teradata Network (TDN) dynamic tunables read/write utility

tdpkgrm

Removes old Teradata software versions

toscrashcount

TPA Crash Count Utility

tosgetpma

Displays the contents of the tosgetpma structure

tpacontrolnode

Display PDE control node id, cabinet, and module

tpanode

Display the PDE node and the node type.

tpasetcfg

Cancels PDE's NETCONFIG start-up timeout

tpasumtrace

Summarizes TPA start-up and restart traces for all nodes

tpatrace

Displays PDE start-up and restart traces for various subsystems

tpatracedump

Extracts and displays TPA traces from a kernel panic dump

tsklist

Displays information about PDE processes and their tasks

prginv

PDE program invocation utility

prgreset

PDE Partition Reset Utility

prgtrace

Produces detailed traces of actions taken by PDE programs

psh

Parallel SHell (P-SHell)

puma

Prints PDE information and kernel memory addresses

v2pgdo

Displays the contents of the V2P GDO

vconfig

Translates configuration definition to VCONFIG GDO

verify_pdisks

verifies configuration definition of vconfig.gdo and matches the configuration on disk

vprocgdo

Displays the contents of the VprocConfig GDO