Allocating PERM, TEMP, and Spool Space - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Use the CREATE USER statement to allocate all the PERM space required by the applications that support your enterprise to user SysAdmin. To determine these space requirements, use the equations provided in Calculating Total PERM Space Requirements.

The quantity of space specified is allocated from the current PERM space of user DBC. DBC becomes the owner of the SysAdmin user and of all users and databases subsequently created. Be sure to leave enough space in DBC to accommodate the growth of system tables and logs and the WAL log.

The following subsections have guidelines for estimating temporary spool and WAL log space requirements.

The containing database or user of a global temporary table must also have a minimum of 512 bytes of PERM space free for the GTT table header.