The system table SYSINFO.HOTSTANDBYCOMPONENT describes some of the details of the hot standby instance in which the information in this system table is queried.
LOCALNODE |
CHAR(64) |
Name with which the hot standby instance can be addressed |
MASTERLOCALNODE |
CHAR(64) |
Name with which the corresponding master instance can be addressed |
STANDBYROLE |
CHAR(8) |
Role within the hot standby configuration (MASTER | STANDBY | UNKNOWN) |
TAKEOVERDATE |
TIMESTAMP |
Time at which a TAKEOVER statement was received |
DELAYTIME |
FIXED(10) |
Delay in seconds after which changes in the master instance are applied to the standby instance |
STANDBYSTATEDATE |
TIMESTAMP |
Time at which the instance reached the STANDBY operational state |
SYNCHRONIZERECEIVECOUNT |
FIXED(10) |
Number of SYNCHRONIZE statements received by the instance |
FIRSTNEEDEDLOGOFFSET |
FIXED(10) |
Oldest position in log area from which log entries have to be redone |
LASTVALIDLOGOFFSETRECEIVED |
FIXED(10) |
Position in log area up to which the instance can read log entries; this position was transferred with the last SYNCHRONIZE statement |
INITSTANDBYDATE |
TIMESTAMP |
Time at which the instance received the last INIT STANDBY statement |
RESTARTSTANDBYDATE |
TIMESTAMP |
Time at which the instance sent the last RESTART STANDBY statement |
LASTSYNCHRONIZEDATE |
TIMESTAMP |
Time at which the instance received the last SYNCHRONIZE statement |
PREPARESTANDBYDATE |
TIMESTAMP |
Time at which the instance sent the last PREPARE STANDBY statement |
REGISTERSTANDBYDATE |
TIMESTAMP |
Time at which the instance sent the last REGISTER STANDBY statement |
Database Administration, Architecture of a Hot Standby System