The LOGINFORMATION system table describes the log management status.
LOGINFORMATION
LOGVOLUMEENABLED |
CHAR(3) |
Log entries are written in the log area (YES | NO) |
AUTOMATICOVERWRITE |
CHAR(3) |
Overwrite mode is activated for the log area (YES | NO) |
LOGWRITERSUSPENDED |
CHAR(3) |
Log writing on disk is suspended, to enable physical disk backup (YES | NO) |
FLUSHMODE |
CHAR(20) |
Criterion that determines if a page may be written multiple times at the same offset (MINIMIZE SPACE | MAXIMIZE SPACE) |
DEVICESTATE |
CHAR(20) |
State of the log (OK | HISTORY LOST | CLEARED | CLEARING | PARTIALLY CLEARED | PARTIALLY CLEARING) |
LOGFULL |
CHAR(3) |
Log area is completely filled (YES | NO) |
PENDINGLOGSIZE |
FIXED(20) |
Size specification for the newly defined log area that is not yet active |
See also:
Concepts of the Database System, Logging Data Changes