The system table SYSINFO.CONSISTENTVIEWS describes the currently active consistent views.
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 |
Concepts of the Database System, Example: Consistent View