16.10 - Assigning Perm Space to the Crashdumps Database - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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

Crashdumps accumulate as long as there is available space. You must delete old crashdump files manually.

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

For step... Information on... Is available in...
1 and 2 The use and maintenance of the crashdumps database Database Administration
Details about perm space
2 The MODIFY DATABASE statement SQL Data Definition Language Syntax and Examples