| Utility | Purpose |
|---|---|
| Abort Host (aborthost) | Stops outstanding transactions running on failed host until system restarts the host. |
| CheckTable (checktable) | Checks for inconsistencies between internal data structures such as table headers, row identifiers, and secondary indexes. |
| CNS Run (cnsrun) | Enables running of database utilities from scripts. |
| Control GDO Editor (ctl) | Displays and lets you change PDE configuration settings. |
| Cufconfig Utility (cufconfig) | Displays and lets you change configuration settings for user-defined function and external stored procedure subsystem. |
| Database Initialization Program (DIP) | Runs one or more of the standard DIP scripts packaged with Database Engine 20. These scripts create database objects that extend functionality of Database Engine 20. |
| DBS Control (dbscontrol) | Displays and lets you change DBS Control fields. |
| Dump Unload/Load (DUL) | Saves and restores system dump tables to and from files. |
| Ferret Utility (ferret) | Defines scope of an action (range of tables or selected vprocs), displays parameters and scope of action, and performs action, either moving data to reconfigure data blocks and cylinders or displaying disk space and cylinder free space percent in use in defined scope. |
| Gateway Control (gtwcontrol) | Changes default values in fields of Gateway Control Globally Distributed Object (GDO). |
| Gateway Global (gtwglobal) | Monitors and controls Database Engine 20 workstation-connected users and their sessions. |
| Lock Display (lokdisp) | Displays snapshot of real-time database locks and their associated running sessions. |
| Query Configuration (qryconfig) | Displays Database Engine 20 configuration, including the Node, AMP, and PE identification and status. |
| Query Session (qrysessn) | Monitors state of selected Database Engine 20 sessions on selected logical host IDs. |
| Recovery Manager (rcvmanager) | Displays information for monitoring progress of a Database Engine 20 recovery. |
| Show Locks (showlocks) | Displays locks placed by Table Rebuild operations on databases and tables. For details on Table Rebuild, see Database Utilities, B035-1102 . |
| Table Rebuild (rebuild) | Rebuilds tables that Database Engine 20 cannot automatically recover, including primary or fallback portions of tables, entire tables, all tables in database, or all tables in Access Module Processor (AMP). You can run Table Rebuild interactively or in background. |
| Teradata Locale Definition Utility(tdlocaledef) | Converts Specification for Data Formatting file (SDF) into internal, binary format (GDO) for Database Engine 20. SDF file is text file that defines how Database Engine 20 formats numeric, date, time, and currency output. |
| Tpareset (tpareset) | Resets PDE and database components of Database Engine 20. |
| Update DBC (updatedbc) | Recalculates PermSpace and SpoolSpace values in DBASE table for user DBC and MaxPermSpace and MaxSpoolSpace values of DATABASESPACE table for all databases based on values in DBASE table. |
| Update Space (updatespace) | Recalculates permanent, temporary, or spool space used by single database or all databases in system. |
| Vproc Manager (vprocmanager) | Manages virtual processors (vprocs). For example, returns status of specified vprocs, initializes vprocs, forces a vproc to restart, and forces a Database Engine 20 restart. |