Delete Crashdumps | Teradata Vantage - Deleting Teradata Crashdumps - 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™

Deleting unwanted Teradata crashdumps from your disk and archiving crashdumps you want to keep may help free up space. It may help prevent crashdumps from using up the space on your system and causing problems.

First determine how many crashdumps you want and how long you want to keep the crashdump. Depending on the size of your system and the size of the crashdumps themselves, you can consider keeping some of the crashdumps as historical records and delete them later when they are no longer necessary.

If you are having space problems due to crashdumps, consider limiting the “Max Dumps” parameter in ctl to a smaller number of crashdumps which will help prevent the crashdump area from filling up. If you are unsure about what to do, contact Teradata Services.

If you decide to delete all the crashdump tables in the Crashdumps database, submit:

DELETE DATABASE CRASHDUMPS;

You may also specify a single crashdump to be deleted using:

DROP TABLE CRASHDUMPS.tablename;

The following procedure describes how to use the CSP utility to delete crashdumps from the raw dump directory.

For more information on CSP commands, type csp -h at a Teradata Command Prompt or see the resource file located at /usr/pde/lib/defaults/Libcsp.
  1. List the available raw PDE crashdumps.

    Use the following command from the Teradata Command Prompt:

    csp -mode list -source dump

    The -source parameter reads the raw crashdumps from the PDE dump directory. The dump directory is also the default source, so it is equivalent to the command csp -mode list (without the -source dump).

    csp -mode list -source -table

    Use the following command from the Teradata Command Prompt:

    csp -mode list -source dump

    The -source parameter reads the raw crashdumps from the PDE dump device. The dump device is also the default source, so it is equivalent to the command csp -mode list (without the -source dump).

    csp -mode list -source -table

    For more options and syntax, type csp -help from the Teradata Command Prompt.

    For CSP, the -nodes <nodelist> option allows you to choose specific nodes from which to list crashdumps. Use the 
-nodes option to target specific nodes for save, list, or clear operations.

  2. Delete (clear) unwanted raw PDE crashdumps.

    Use a command similar to the following:

    csp -mode clear 2008/12/06-14:19:34-02

    The raw PDE crashdumps cleared are those selected with an asterisk in the “Sel” field.

    If you do not type a name, you will delete all crashdumps. However, you will be prompted to answer ‘y’, ‘n’, or ‘q’ for each crashdump to be cleared.
    The csp default setting for -source is dump (the PDE dump directory). The “csp -mode clear” command is run from one node but deletes the raw crashdumps on all accessible Teradata nodes.