The system table SYSINFO.RESTARTINFORMATION contains all information relevant to restarting.
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 |
Concepts of the Database System, Example: Restart