15.10 - File System: Cylinder MiniCylPack Overhead 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 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