17.05 - File System: Cylinder MiniCylPack Overhead 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 identify file system overhead associated with MiniCylPack operations that get performed to make available a free cylinder when one is needed but not available.
  • Event counts are found in ResUsageSvpr.
  • Only logical I/Os and the amount moved (KB) are identified, except the amount moved for cylinder indexes because they can be calculated by multiplying the current cylinder index fixed size and the I/Os.
  • MiniCylPack operations are done on cylinders containing permanent tables (including append and transient journal tables) only.
Column Name Mode Description Data Type
FilePCiMCylPackIO count Number of permanent cylinder index logical I/Os due to performing MiniCylPack operations. FLOAT
FilePDbMCylPackKB count KB moved by FilePDbCylPackIOs. FLOAT
FilePDbMCylPackIO count Number of permanent data block logical I/Os due to performing MiniCylPack operations. FLOAT