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