File System Columns | ResUsageIvpr Table | Teradata Vantage - 17.05 - File System: Cylinder Defragmentation 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 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