17.05 - File System: Cylinder Split and Migrate 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 further identify file system cylinder split/migrate (CylMigr) overhead performed when cylinders can not accommodate new data.

Event counts are found in ResUsageSvpr Table Overview.

Only logical I/Os and the amount moved (KB) for data blocks are identified. Each cylinder migration event implies one logical read and three logical writes of the cylinder index. Only permanent tables (including append and transient journal tables) are migrated.

Column Name Mode Description Data Type
FileDbCylMigrKB count KB moved by FileDbCylMigrIOs. FLOAT
FileDbCylMigrIO count Number of data block logical I/Os due to cylinder migration. FLOAT