15.10 - File System: Cylinder Defragmentation 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 background file system overhead associated with fragmented free space to achieve one large free space within that cylinder (CylDefrag).

  • Event counts are found in ResUsageSvpr.
  • Each cylinder defragment event implies one logical cylinder index read and one logical cylinder index write.
  • Only logical I/Os and the amount moved (KB) are identified. Cylinder defragments are done on cylinders containing permanent tables (including append and transient journal tables) only.
Column Name Mode Description Data Type
FileDbCylDefragKB count KB moved by the FileDbCylDefragIO. FLOAT
FileDbCylDefragIO count Number of permanent data block logical I/Os due to cylinder defragmentation. FLOAT