
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 |
|
LASTSAVEPOINT ID |
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 |
|
LO B DIRECTORYROOT |
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) |
|
LASTKNO W NOFFSET |
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