The system table CONSISTENTVIEWS describes the currently active consistent views.
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