Assigning Perm Space to the Crashdumps Database - Analytics Database - Teradata Vantage

Security Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-02-29
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantage™

Crashdumps appear as table images, which contain information that Teradata 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)

    For example, using the following values:
    • 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

    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_space
    STARTUP = ''
    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 Teradata Vantage™ - Database Administration, B035-1093
Details about perm space
2 The MODIFY USER statement Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144