LOGINFORMATION

Definition

The LOGINFORMATION system table describes the log management status.

Structure

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