Object documentationHOTSTANDBYGROUP Locate this document in the navigation structure

 

The system table SYSINFO.HOTSTANDBYGROUP describes which information the hot standby instance from which the information about this system table is being requested has about other standby instances.

Structure

HOTSTANDBYGROUP

LOCALNODE

CHAR(64)

Name by which the instance can be addressed

ADDNODEDATE

TIMESTAMP

Time at which the instance was added to the hot standby configuration

REMOVENODEDATE

TIMESTAMP

Time at which the instance was removed from the hot standby configuration

STATE

CHAR(20)

Status of the instance (UNKNOWN, PREPARE STANDBY, WAIT FOR SYNCHRONIZE, DEACTIVATED, REGISTER STANDBY, REMOVED, ADDED)

PREPARESTANDBYDATE

TIMESTAMP

Time at which the instance received the last PREPARE STANDBY statement

REGISTERSTANDBYDATE

TIMESTAMP

Time at which the instance received the last RECEIVE STANDBY statement

SYNCHRONIZEDATE

TIMESTAMP

Time at which the instance sent the last SYNCHRONIZE statement

SUCCESSFULSYNCHRONIZEDATE

TIMESTAMP

Time at which last successful SYNCHRONIZE statement was executed

LASTVALIDLOGOFFSETSENT

FIXED(10)

Last position in the log area sent by the master instance up to which the standby instances can redo the log entries

FIRSTNEEDEDLOGOFFSET

FIXED(10)

Oldest position in the log area up to which the master instance can write without overwriting the log pages required by the standby instances

SYNCHRONIZESENDCOUNT

FIXED(10)

Number of sent SYNCHRONIZE statements

SYNCHRONIZERETRYCOUNT

FIXED(10)

Number of SYNCHRONIZE statements that have failed since last successful SYNCHRONIZE statement

More Information

Database Administration, Architecture of a Hot Standby System