Object documentationLOGINFORMATION Locate this document in the navigation structure

 

The SYSINFO.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

More Information

Concepts of the Database System, How Databases Log Data Changes