The Crashdumps database holds Advanced SQL Engine memory dumps resulting from unplanned database restarts. Teradata Customer Support can remotely access the Crashdumps database to investigate dumps.
- From an administrative client, such as BTEQ, log on as DBC.
-
If not known, calculate the available permanent database space by running the following SQL request:
SELECT SUM(MaxPerm) FROM DBC.DiskSpaceV;
-
Calculate the optimal perm space for the Crashdumps database, which holds three typical dumps per node, using this formula:
Crashdumps Perm Space = Maxperm * 0.02
-
Run, for example, the following:
MODIFY DATABASE Crashdumps as perm = 400E9;
To make sure there is enough space for crashdump tables, regularly monitor space usage and remove older crashdumps.