Ad-Hoc Creation of DBC.Crashdumps with DIPCRASH - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Ad-Hoc Creation of DBC.Crashdumps with DIPCRASH

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:


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.

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

To review DBC space, follow the procedure detailed under “Allocating More Space to DBC.Crashdumps Database” on page 560.

For instructions on running DIP, see “Database Initialization Program (DIP)” in Utilities.