17.05 - File System: AutoCylPack Columns - Teradata Database

Teradata Vantage™ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

These columns track the number of cylinders used during AutoCylPack, a background task that runs periodically to maintain the set levels of free space percent (FSP) on table cylinders.

For more information about AutoCylPack, see Teradata Vantage™ - Database Administration, B035-1093.

Column Name Mode Description Data Type
FileACPCylsMigr count Number of successful migrations performed by AutoCylPack. FLOAT
FileACPCylsPostponed count Number of cylinders AutoCylPack selected for performing a migration, but could not be performed at the current time. This can happen due to conflicts with foreground tasks modifying the cylinder at around the same time as AutoCylPack. AutoCylPack, therefore, postpones the work until the next time it scans the MI from the beginning. When AutoCylPack comes across the cylinder again, and it still qualifies, the cylinder is selected again for processing. FLOAT
FileACPCylsSkipped count Number of cylinders AutoCylPack skipped when scanning the MI since nothing needed to be done. FLOAT
FileACPCylsUnFSEOnly count Number of cylinders AutoCylPack selected for performing a migration, but could not be performed at the current time. This can happen because of a locking conflict or a cylinder being modified or marked down. Instead, AutoCylPack cleans-up the unfree sector entries (UnFSEs) on all cylinders, except for those that are down. FLOAT