17.10 - AutoCylPackFSP - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The percentage of storage space within a cylinder that AutoCylPack (automatic background cylinder packing) operations leave free of data, to allow for future table growth. This value for Free Space Percent (FSP) is used only for tables that do not have FSP otherwise specified.

Field Group

File System

Valid Range

10 through 75

Default

10

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

Free Space Percent (FSP) is the amount of space on a cylinder that is unoccupied and available for storage, expressed as a proportion of the total space on the cylinder. For tables that are expected to grow, free space on cylinders allows for table growth without requiring the additional cost of allocating free cylinders.

Vantage can maintain different levels of free space on cylinders used to store different tables. Static tables can be designated with little or no FSP, while tables that change and grow can be designated to have FSP levels that allow for table growth.

AutoCylPack runs periodically as a background task to maintain the set levels of FSP on table cylinders. If there is less than the desired FSP available on the cylinder, AutoCylPack moves some data to other cylinders to free up some space. If there is more than the desired FSP available on the cylinder, AutoCylPack moves data to the cylinder, potentially freeing up other cylinders.

A desired target level for FSP can be specified for tables in several ways. The FSP that AutoCylPack maintains for cylinders of each table depends on how the FSP was specified:

  • If the FSP was specified in a CREATE or ALTER TABLE statement, AutoCylPack maintains that FSP for the cylinders of the table.
    If the FSP was specified in a CREATE or ALTER TABLE statement, and AutoCylPack is enabled, specifying a FREESPACEPERCENT value with a PACKDISK command is not recommended. In such cases, the FSP resulting from the PACKDISK operation would be temporary, and the table would be returned to the original table-level FSP setting by the background AutoCylPack task.
  • If FSP was not specified with CREATE or ALTER TABLE, but PACKDISK was run on the table, AutoCylPack maintains the table cylinders at the FSP level that PACKDISK used.
  • If an FSP was not specified in a CREATE or ALTER TABLE statement for the table, and PACKDISK was never run on the table, AutoCylPack uses the FSP specified by the AutoCylPackFSP field in DBS Control.

Related Information

For more information on… See…
AutoCylPackThresh AutoCylPackThresh.
CREATE TABLE and ALTER TABLE Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
PACKDISK PACKDISK.
Free Space Percent FreeSpacePercent, SHOWFSP, Teradata Vantage™ - Database Administration, B035-1093.