Object documentationCONSISTENTVIEWS Locate this document in the navigation structure

 

The system table SYSINFO.CONSISTENTVIEWS describes the currently active consistent views.

Structure

CONSISTENTVIEWS

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

More Information

Concepts of the Database System, Example: Consistent View