HOTSTANDBYGROUP

Definition

The system table HOTSTANDBYGROUP contains information about the other hot standby instances in the hot standby system.

Structure

HOTSTANDBYGROUP

LOCALNODE

CHAR(64)

Name with 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 sent by the master instance in the log area up to which log entries can be applied by the standby instances

FIRSTNEEDELOGOFFSET

FIXED(10)

Oldest position in log area up to which the master instance can write without overwriting log pages required by 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

See also:

Concepts of the Database System, Architecture of a Hot Standby System