17.10 - DisableAutoCylPack - 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)

Disables AutoCylPack automatic background cylinder packing.

Field Group

File System

Valid Settings

Setting Description
TRUE Disables AutoCylPack
FALSE Enables AutoCylPack

Default

FALSE

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…
AutoCylPackFSP AutoCylPackFSP.
Free Space Percent FreeSpacePercent, SHOWFSP, Teradata Vantage™ - Database Administration, B035-1093.
CREATE TABLE and ALTER TABLE Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
PACKDISK PACKDISK.
MiniCylPack MiniCylPackLowCylProd, Teradata Vantage™ - Database Administration, B035-1093.