Object documentationHOTSTANDBYCOMPONENT Locate this document in the navigation structure

 

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.

Structure

HOTSTANDBYCOMPONENT

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

More Information

Database Administration, Architecture of a Hot Standby System