TRANSFORMATIONMODEL 
Definition
The system table TRANSFORMATIONMODEL contains all entries on Loader transformations.
If a transformation was successful, the entries of the table TRANSFORMATIONMODEL are deleted. If a transformation could not be completed successfully, the data is retained in this system table and is used if the transformation is restarted.
You can save the contents of the system table TRANSFORMATIONMODEL, even if the transformation is successful, by exporting the values. To do this, specify a PACKAGE data stream in the appropriate Loader command.
See also:
Loader, Transformation, Restarting, Additional Log Functions (package_spec)
Structure
TRANSFORMATIONMODEL
PACKAGEGUID |
CHAR(24) BYTE |
Unique ID of the transformation package |
TASKID |
FIXED(6.0) |
ID of the transformation task |
SERVERNODE |
CHAR(32) |
Computer node on which the database instance to be transformed is installed |
SERVERDB |
CHAR(32) |
Name of the database instance that is to be transformed |
USERNAME |
CHAR(32) |
User name |
CODETYPE |
CHAR(32) |
Code type of the database instance (ASCII | UNICODE) |
CODEPAGEID |
CHAR(32) |
ID of the ASCII code page that is to be used |
STORAGEDEVICE |
CHAR(32) |
External data carrier that is to be used |
TRANSACTIONSIZE |
FIXED(6.0) |
Minimum number of rows that are to be transformed before the status of the transformation step is logged |
TRANSFORMATION |
CHAR(32) |
Transformation type (EXPORT | IMPORT | UPDATE) |
PART |
CHAR(32) |
Parts of the database catalog (ALL | USER | SCHEMA | TABLE) |
STEPID |
FIXED(6.0) |
ID of the transformation step |
OWNER |
CHAR(32) |
Table owner |
SCHEMANAME |
CHAR(32) |
Schema name |
TABLENAME |
CHAR(32) |
Table name |
TABLETYPE |
CHAR(8) |
Table type (TABLE | VIEW | SYNONYM) |
CATALOGSTREAMNAME |
CHAR(254) |
Name of the CATALOG data stream |
CATALOGSTREAMTYPE |
CHAR(32) |
Data carrier of the CATALOG data stream (FILE | PIPE | TAPE) |
CATALOGSTREAMEBID |
CHAR(32) |
External backup ID of the CATALOG data stream |
CATALOGSTREAMFORMAT |
CHAR(32) |
Format of the CATALOG data stream (DDL | XML) |
DATASTREAMNAME |
CHAR(254) |
Name of the DATA data stream |
DATASTREAMTYPE |
CHAR(32) |
Data carrier of the DATA data stream (FILE | PIPE | TAPE) |
DATASTREAMEBID |
CHAR(32) |
External backup ID of the DATA data stream |
DATASTREAMFORMAT |
CHAR(32) |
Format of the DATA data stream (CSV | DDL | FWV | PAGES | RECORDS) |
DATASTREAMHEADERBLOCK |
FIXED(6,0) |
Start position of the header of the DATA data stream (in 2 GB blocks) |
DATASTREAMHEADERPOS |
FIXED(10,0) |
Start position of the header of the DATA data stream (in bytes, less than 2 GB) |
DATASTREAMDATABLOCK |
FIXED(6,0) |
Start position of the data of the DATA data stream (in 2 GB blocks) |
DATASTREAMDATAPOS |
FIXED(10,0) |
Start position of the data of the DATA data stream (in bytes, less than 2 GB) |
DATASTREAMTRAILEBLOCK |
FIXED(6,0) |
Start position of the trailer of the DATA data stream (in 2 GB blocks) |
DATASTREAMTRAILERPOS |
FIXED(10,0) |
Start position of the trailer of the DATA data stream (in bytes, less than 2 GB) |
EXCLUDE |
BOOLEAN |
Transformation step was excluded (TRUE) or not (FALSE) |
RESTART |
BOOLEAN |
Transformation step was executed (TRUE) or not (FALSE) |
RESTORE |
BOOLEAN |
Transformation command was generated (TRUE) or not (FALSE) |
PAGECOUNT |
FIXED(10,0) |
Number of pages that were transformed during a transformation step |
ROWCOUNT |
FIXED(10,0) |
Number of rows that were transformed during a transformation step |
STARTTIME |
TIMESTAMP |
Start of the transformation step |
ENDTIME |
TIMESTAMP |
End of the transformation step |
REQUESTTIME |
FIXED(15,10) |
Total execution time of a kernel request within a transformation step |
RECEIVETIME |
FIXED(15,10) |
Total execution time of a kernel reply within a transformation step |
IOTIME |
FIXED(15,10) |
Total I/O time within a transformation step |
LOGTIME |
FIXED(15,10) |
Total time required for the management of actions within a transformation step |
SEQ_NO |
FIXED(6,0) |
Sequence number with which split GRANT statements can be assigned to each other |
CMD |
CHAR(254) |
Authorization statement |
See also:
Additional System Tables