15.00 - Alphabetical Listing of Utilities - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
Content Type
Publication ID
English (United States)
Last Update

Alphabetical Listing of Utilities




Abort Host

Aborts all outstanding transactions running on a failed host, until the system restarts the host.

AMP Load

Displays the load on all AMP vprocs in a system, including the number of AMP worker tasks (AWTs) available to each AMP vproc, and the number of messages waiting (message queue length) on each AMP vproc.

AWT Monitor

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


Checks for inconsistencies between internal data structures such as table headers, row identifiers, and secondary indexes.


Allows running of database utilities from scripts.

Configuration Utility

Defines AMPs, PEs, and hosts, and describes their interrelationships for Teradata Database.

Note: Configuration is documented in Support Utilities.

Control GDO Editor

Displays the fields of the PDE Control Parameters GDO, and allows modification of the settings.

Cufconfig Utility

Displays configuration settings for the user-defined function and external stored procedure subsystem, and allows these settings to be modified.

Database Initialization Program

Executes one or more of the standard DIP scripts packaged with Teradata Database. These scripts create a variety of database objects that can extend the functionality of Teradata Database with additional, optional features.

DBS Control

Displays the DBS Control Record fields, and allows these settings to be modified.

Dump Unload/Load

Saves system dump tables to tape, and restores system dump tables from tape.

Ferret Utility

Defines the scope of an action, such as a range of tables or selected vprocs, displays the parameters and scope of the action, and performs the action, either moving data to reconfigure data blocks and cylinders, or displaying disk space and cylinder free space percent in use of the defined scope.

Filer Utility

Finds and corrects problems within the file system.

Note: Filer is documented in Support Utilities.

Gateway Control

Modifies default values in the fields of the Gateway Control Globally Distributed Object (GDO).

Gateway Global

Monitors and controls the Teradata Database workstation-connected users and their sessions.

Lock Display

Displays a snapshot capture of all real-time database locks and their associated currently-running sessions.

Modify MPP List

Allows modification of the node list file (mpplist).

Priority Scheduler
(SLES 10 only)

Creates, modifies, and monitors Teradata Database process prioritization parameters.

All processes have an assigned priority based on their Teradata Database session. This priority is used by Priority Scheduler to allocate CPU and
I/O resources.

Note: On SLES 11 systems, Priority Scheduler is managed by Teradata Active System Management (ASM), and is configured using the Teradata Viewpoint workload management portlets. For more information on those portlets, see Teradata Viewpoint User Guide.

Query Configuration

Reports the current Teradata Database configuration, including the Node, AMP, and PE identification and status.

Query Session

Monitors the state of selected Teradata Database sessions on selected logical host IDs.

Reconfiguration Utility

Uses the component definitions created by the Configuration Utility to establish an operational Teradata Database.

Note: Reconfiguration is documented in Support Utilities.

Reconfiguration Estimator

Estimates the elapsed time for reconfiguration based upon the number and size of tables on the current system, and provides time estimates for the following phases:

  • Redistribution
  • Deletion
  • NUSI building
  • Note: Reconfiguration Estimator is documented in Support Utilities.

    Recovery Manager

    Displays information used to monitor progress of a Teradata Database recovery.

    Resource Check Tools
    (dbschk, nodecheck, syscheck)

    Identifies slow down and potential hangs of Teradata Database, and displays system statistics that help identify the cause of the problem.

    Show Locks

    Displays locks placed by Archive and Recovery and Table Rebuild operations on databases and tables.

    For details Archive and Recovery, see Teradata Archive/Recovery Utility Reference.

    System Initializer

    Initializes Teradata Database. Creates or updates the DBS Control Record and other Globally Distributed Objects (GDOs), initializes or updates configuration maps, and sets hash function values in the DBS Control Record.

    Note: System Initializer is documented in Support Utilities.

    Table Rebuild

    Rebuilds tables that Teradata Database cannot automatically recover, including the primary or fallback portions of tables, entire tables, all tables in a database, or all tables in an Access Module Processor (AMP). Table Rebuild can be run interactively or as a background task.

    Teradata Locale Definition Utility

    Converts a Specification for Data Formatting file (SDF) into an internal, binary format (a GDO) for use by Teradata Database. The SDF file is a text file that defines how Teradata Databaseformats numeric, date, time, and currency output.

    Teradata Network Statistics

    Performs GetStat/ResetStat operations and displays or clears Teradata Database Network Services statistics.

    Teradata Network Tuner

    Displays and allows modification of Teradata Network Services tunable parameters. The utility provides a user interface to view, get, or update the Teradata Network Services, which are specific to tunable parameters.


    Resets the PDE and database components of Teradata Database.

    Task List

    Displays information about PDE processes and their tasks.

    Update DBC

    Recalculates the PermSpace and SpoolSpace values in the DBASE table for the user DBC, and the MaxPermSpace and MaxSpoolSpace values of the DATABASESPACE table for all databases based on the values in the DBASE table.

    Update Space

    Recalculates the permanent, temporary, or spool space used by a single database or by all databases in a system.

    Verify _pdisks

    Verifies that the pdisks on Teradata Database are accessible and are mapped correctly.

    Vproc Manager

    Manages the virtual processors (vprocs). For example, obtains status of specified vprocs, initializes vprocs, forces a vproc to restart, and forces a Teradata Database restart.


    For more information on...


    starting the utilities

    the appendix titled “Starting the Utilities”

    utilities related to Teradata Database security

    Security Administration

    Archive and Recovery, FastExport, FastLoad, MultiLoad, and TPump

    the following client utility books:

  • Teradata Archive/Recovery Utility Reference
  • Teradata FastExport Reference
  • Teradata FastLoad Reference
  • Teradata MultiLoad Reference
  • Teradata Parallel Data Pump Reference