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)

ID of the consistent view

TRANSACTIONID

FIXED(15)

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

More Information

Concepts of the Database System, Example: Consistent View