Space Allocation and Usage in Teradata

Hi,

Today we will discuss about Space management in Teradata.

Permanent Space Terminology

MaxPerm

• The maximum number of bytes available for table, index and permanent journal storage in a database or user.

CurrentPerm

• The total number of bytes in use to store the tables, subtables, and permanent journals contained in the database or user.

PeakPerm

• The largest number of bytes actually used to store data in this user since the value was last reset.

Spool Space Terminology

MaxSpool

• A value used to limit the number of bytes the system will consume to create spool files for a user.

CurrentSpool

• The number of bytes currently in use for running transactions.

PeakSpool

• The maximum number of bytes used by a transaction run for this user since the value was last reset.

 

         Spool space marked (last use) is recovered by a worker task that is initiated every five minutes.

Temporary Space Terminology

MaxTemp

• A value used to limit the number of bytes the system will use to store data for global temporary tables for a user.

CurrentTemp

• The number of bytes in use for global temporary tables.

PeakTemp

• The maximum number of bytes used by global temporary tables for a user since the value was last reset.

Temporary space is released when the user terminates the session or when the user frees the temporary space.