Administrative and Maintenance Utilities - Teradata Database

Utility

Purpose

Abort Host
(aborthost)

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

AMP Load
(ampload)

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
(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 in Teradata Database.

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 AMPs, PEs, and hosts, and describes their interrelationships for Teradata Database.

Note: 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 Record fields, and allows these settings to be modified.

Dump Unload/Load
(DUL, DULTAPE)

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

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.

Note: 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.

Modify MPP List
(modmpplist)

Allows modification of the node list file (mpplist).

Priority Scheduler
(schmon)
(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
(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.

Note: 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:

Note: Reconfiguration Estimator is documented in Support Utilities.

Recovery Manager
(rcvmanager)

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
(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: Volume 2 (L-Z).

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.

Note: 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 Databaseformats numeric, date, time, and currency output.

Teradata Network Statistics
(tdnstat)

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

Teradata Network Tuner
(tdntune)

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.

Tpareset
(tpareset)

Resets the PDE and database components of Teradata Database.

Task List
(tsklist)

Displays information about PDE processes and their tasks.

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.

Verify _pdisks
(verify_pdisks)

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

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.

IF you want to learn more about…

See…

Roles and profiles

Session management

Database Administration

Administrative and maintenance utilities

Utilities