File System: Cylinder MiniCylPack Overhead Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢
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