15.10 - File System: AutoCylPack Columns - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty

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 Database Administration.

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