Assigning Perm Space to the Crashdumps Database - Advanced SQL Engine - Teradata Database

Crashdumps appear as table images, which contain information that Teradata Customer Support uses to investigate crashes.

To assign perm space to the crashdumps:

1. Calculate optimal perm space for the crashdumps database using the formula:

   Crashdumps Perm Space = (Number of TPA Nodes) * (Memory in GB per node) * (6)

   This equation is based on the following assumptions:

   • 32 GB of memory per node
   • A crashdump uses approximately 50% of node memory capacity
   • Allocate enough space for at least 3 crashdumps
   • If you specify FALLBACK protection for tables, the required space doubles

   Based on these assumptions, the calculation for a four-nodes system is:

   Crashdumps Perm Space = (4) * (32 GB) * (6), or 768 GB.

2. Modify the default perm space value for the crashdumps user from the 1 GB default to the calculated value:

   MODIFY USER Crashdumps AS
   PERM=perm_spaceSTARTUP = ''
   FALLBACK
   NO BEFORE JOURNAL
   NO AFTER JOURNAL
   COLLATION = HOST
   DEFAULT CHARACTER SET = LATIN
   DATEFORM = INTEGERDATE
   TIME ZONE = NULL ;

   where perm_space is the amount of space you calculated. All other syntax elements shown are default settings.

   Periodically monitor crashdumps space utilization and adjust space allocations as necessary.

Related Information