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

Event counts are found in ResUsageSvpr Table..

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