PACKAGEGUID

CHAR(24) BYTE

Unique identification of the transformation package

TASKID

FIXED(6,0)

Identification of the transformation task

SERVERNODE

CHAR(32)

Computer node on which the database to be transformed is installed

SERVERDB

CHAR(32)

Name of the database that is to be transformed

USERNAME

CHAR(32)

User name

CODETYPE

CHAR(32)

Code type of the database (ASCII | UNICODE)

CODEPAGEID

CHAR(32)

Identification 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)

Identification 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)

DATASTREAMTRAILERBLOCK

FIXED(6,0)

Start position of the trailerof 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