Commands for Forcing a Teradata Crashdump - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
upb1600054424724.ditamap
dita:ditavalPath
upb1600054424724.ditaval
dita:id
B035-1093
lifecycle
previous
Product Category
Teradata Vantage™

You can restart without causing a reboot using one of the following methods (also see Forced Teradata Crashdumps):

  • In DBW, open the Supervisor window icon and enter the following command:
    restart tpa dump=yes comment

    where comment is text explaining why there is going to be a restart.

    The system performs a Teradata crashdump and a cold or coldwait restart. (For details, see “RESTART” under “Vproc Manager (vprocmanager)” in Teradata Vantage™ - Database Utilities, B035-1102)

  • You can access the Teradata Command Prompt window and enter the tpareset command:
    tpareset -d comment

    The tpareset command has basically the same effect as the restart command in DBW.

    The -d option forces a Teradata crashdump.

    The system performs a cold restart and a Teradata crashdump.

Whichever command you choose to execute, the system prompts you for a confirmation.