TRANSFORMATIONSTATISTICS
The system table SYSLOADER.TRANSFORMATIONSTATISTICS describes the resource consumption of a step of a Loader transformation.
|
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 |