Object documentationTRANSFORMATIONSTATISTICS Locate this document in the navigation structure

 

The system table SYSLOADER.TRANSFORMATIONSTATISTICS describes the resource consumption of a step of a Loader transformation.

Structure

TRANSFORMATIONMODEL

PACKAGEGUID

CHAR(24) BYTE

Unique identification of the transformation package

STEPID

FIXED(6,0)

Identification of the transformation step

OWNER

CHAR(32)

Table owner

SCHEMANAME

CHAR(32)

Schema name

TABLENAME

CHAR(32)

Table name

BYTECOUNT

FIXED(11,0)

Size of the DATA data stream in bytes

ROWCOUNT

FIXED(10,0)

Number of table rows in the DATA data stream

TRANSACTIONSIZE

FIXED(6,0)

Minimum number of rows that are to be transformed before the status of the transformation step is logged

SYSTEMTIME

FLOAT(38)

Transformation performance

KERNELTIME

FIXED(20,10)

Kernel performance

LOADERTIME

FLOAT(38)

Loader performance

DATATIME

FLOAT(38)

Pager performance

LOGTIME

FIXED(15,10)

Total time required for the management of actions within a transformation step

IOTIME

FIXED(15,10)

Total I/O time within a transformation step