Advanced SQL Engine | PDE Tools | Teradata Vantage - 17.10 - PDE Tools - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

Parallel Database Extensions (PDE) is a software interface layer that lies between the operating system and Advanced SQL Engine. PDE supports the parallelism across system nodes that contributes to Advanced SQL Engine 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 Advanced SQL Engine. They are not documented in Utilities because PDE tools have online documentation accessible from a system console using the "man" and "pdehelp" commands.

This section presents a list of some of the useful PDE tools you can 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) onAdvanced SQL Engine, 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 Advanced SQL Engine 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