CONSISTENTVIEWS

Definition

The system table CONSISTENTVIEWS describes the currently active consistent views.

Structure

CONSISTENTVIEWS

CONSISTENTVIEW

CHAR(6) BYTE

ID of the consistent view

CREATORTRANSCOUNT

CHAR(20)

ID of the transaction that generated the consistent view

OPENTRANS

CHAR(6) BYTE

ID of another transaction that was active at the time the consistent view was generated

OPENDATE

TIMESTAMP

Time at which the consistent view was generated

LASTUSED

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 )

See also:

Concepts of the Database System, Example: Consistent View