Object documentationRESTARTINFORMATION Locate this document in the navigation structure

 

The system table SYSINFO.RESTARTINFORMATION contains all information relevant to restarting.

Structure

RESTARTINFORMATION

BADINDEXCOUNT

FIXED(5)

Number of indexes only available after recreation

RESTARTCONVERTERVERSION

FIXED(10)

Converter version valid for the restart

LASTSAVEPOINTID

FIXED(10)

Number of the last savepoint

LASTSAVEPOINTREASON

CHAR(20)

Reason for the last savepoint

LASTSAVEPOINTDATE

TIMESTAMP

Time of last savepoint

OPENTRANSACTIONCOUNT

FIXED(10)

Number of open transactions

OPENTRANSACTIONFILEROOT

FIXED(10)

File root for the open transactions

HISTORYDIRECTORYROOT

FIXED(10)

History directory file root

FILEDIRECTORYROOT

FIXED(10)

Root of the file directory

LOBDIRECTORYROOT

FIXED(10)

Root of the file directory for LOB files

RESTARTIOSEQUENCE

FIXED(10)

Restart starting point (part 1)

RESTARTOFFSETOFPAGEONVOLUME

FIXED(10)

Restart starting point (part 2)

RESTARTOFFSETOFENTRYINPAGE

FIXED(10)

Restart starting point (part 3)

RESTARTENTRYTYPE

CHAR(20)

Restart starting point (part 4)

RESTARTENTRYDATE

TIMESTAMP

Time/starting point for the restart

CYCLERELATEDENDOFFSET

FIXED(10)

Last valid position in the log area that can be described

LASTKNOWNSEQUENCE

FIXED(10)

Last known write position in the log area (part 1)

LASTKNOWNOFFSET

FIXED(10)

Last known write position in the log area (part 2)

DATABASEIDENTIFIER

CHAR(100)

Database identification

LASTSAVEPOINTRELEASEVERSION

CHAR(40)

Version at the time of the last savepoint

INSTALLSERVERDBVERSION

CHAR(40)

Version at the time of the database installation

More Information

Concepts of the Database System, Example: Restart