RESTARTINFORMATION
The system table SYSINFO.RESTARTINFORMATION
contains
all information relevant to restarting.
|
FIXED(5) |
Number of indexes only available after recreation |
|
FIXED(10) |
Converter version valid for the restart |
|
FIXED(10) |
Number of the last savepoint |
|
CHAR(20) |
Reason for the last savepoint |
|
TIMESTAMP |
Time of last savepoint |
|
FIXED(10) |
Number of open transactions |
|
FIXED(10) |
File root for the open transactions |
|
FIXED(10) |
History directory file root |
|
FIXED(10) |
Root of the file directory |
|
FIXED(10) |
Root of the file directory for LOB files |
|
FIXED(10) |
Restart starting point (part 1) |
|
FIXED(10) |
Restart starting point (part 2) |
|
FIXED(10) |
Restart starting point (part 3) |
|
CHAR(20) |
Restart starting point (part 4) |
|
TIMESTAMP |
Time/starting point for the restart |
|
FIXED(10) |
Last valid position in the log area that can be described |
|
FIXED(10) |
Last known write position in the log area (part 1) |
|
FIXED(10) |
Last known write position in the log area (part 2) |
|
CHAR(100) |
Database identification |
|
CHAR(40) |
Version at the time of the last savepoint |
|
CHAR(40) |
Version at the time of the database installation |
Concepts of the Database System, Example: Restart