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

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.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.