CONSISTENTVIEWID

FIXED(15)

Identification of the consistent view

TRANSACTIONID

FIXED(15)

Identification of the transaction that generated the consistent view

CREATEDATE

TIMESTAMP

Time at which the consistent view was generated

UNUSEDTIME

FIXED(10)

Elapsed time since the consistent view was last used (s)

CANCELED

CHAR(3)

Consistent view was implicitly closed due to insufficient memory (YES | NO)

COMMANDID

CHAR(8)

Identification of the corresponding SQL statement

PARTITIONID

FIXED(5)

Identification of the partition