16.10 - Alphabetical Listing of Utilities - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
June 2017
English (United States)
Last Update
Utility Purpose

Abort Host (aborthost)

Aborts all outstanding transactions running on a failed host, until the 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)

Allows running of database utilities from scripts.

Configuration Utility (config)

Defines contiguous maps, AMPs, PEs, and hosts, and describes their interrelationships for Teradata Database.
Configuration is documented in Support Utilities.

Control GDO Editor (ctl)

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

Cufconfig Utility (cufconfig)

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

Database Initialization Program (DIP)

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 (dbscontrol)

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

Dump Unload/Load (DUL)

Saves and restores system dump tables to and from files.

Ferret Utility (ferret)

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 (filer)

Finds and corrects problems within the file system.
Filer is documented in Support Utilities.

Gateway Control (gtwcontrol)

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

Gateway Global (gtwglobal)

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

Lock Display (lokdisp)

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

Query Configuration (qryconfig)

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

Query Session (qrysessn)

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

Reconfiguration Utility (reconfig)

Uses the component definitions created by the Configuration Utility to establish an operational Teradata Database.
Reconfiguration is documented in Support Utilities.

Reconfiguration Estimator (reconfig_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
Reconfiguration Estimator is documented in Support Utilities.

Recovery Manager (rcvmanager)

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

Show Locks (showlocks)

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 . For details on Table Rebuild, see Utilities.

System Initializer (sysinit)

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.
System Initializer is documented in Support Utilities.

Table Rebuild (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(tdlocaledef)

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 Database formats numeric, date, time, and currency output.

Tpareset (tpareset)

Resets the PDE and database components of Teradata Database.

Update DBC (updatedbc)

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 (updatespace)

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

Vproc Manager (vprocmanager)

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.