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 |