CONSISTENTVIEWS
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 |
|
PARTITIONID |
FIXED(5) |
Identification of the partition |
Concepts of the Database System, Example: Consistent View