17.00 - 17.05 - Ad-Hoc Creation of DBC.Crashdumps with DIPCRASH - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

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

Sometimes you may want to run the DIPCRASH script from the DIP utility because the script may not have been properly run and set up during system installation.

To verify that Crashdumps exists, submit the following statement:

HELP DATABASE CRASHDUMPS;

If the database table exists but contains no data, the following message appears:

Empty HELP information returned.

If the database table does not exist, an error message appears warning you that the table does not exist. If you want to create the database table, run the DIP utility and execute the DIPCRASH script.

You can start the DIP utility from the Supervisor window of DBW.

Make sure DBC has enough space to create Crashdumps and still retain enough for a maximum-sized transient journal plus overhead.

The amount of PERM space allocated to Crashdumps is deducted from the currently available space of user DBC.

For instructions on running DIP, see “Database Initialization Program (DIP)” in Teradata Vantage™ - Database Utilities , B035-1102 .