File System Columns | ResUsageIvpr Table | Teradata Vantage - File System: Cylinder Defragmentation Overhead Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢
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