You display the hot standby database parameters of the hot standby system.
You have the server authorization ParamRead,
You are connected to the database instance of the hot standby system on the virtual server.
hss_getnodes
OK
HostStandbyStorageDLLPath <file_name>
OfficialNodeName <virtual_server_name>
HotsStandbyDelayTime? <delay_time>
HotStandbySyncInterval <sync_interval>
HotStandbyNodeName001 <master_database_computer>
HotStandbyNodeName002 <standby_database_computer>_<001>
HotStandbyNodeName003 <standby_database_computer>_<002>
...
Value |
Description |
---|---|
<file_name> |
Name of the library that is used to access the memory management system |
<virtual_server_name> |
Name of the virtual server |
<delay_time> |
Delay (in s) until the changes made in the master instance are copied to the standby instance nnn. |
<sync_interval> |
Minimum time span (in s) between two commands of the master instance to synchronize the standby instances |
<master_database_computer> |
Computer of the master instance |
<standby_database_computer> |
Computer of the standby instance |
<nnn> |
Sequential number of the standby instance (nnn > 1) |
Call the Database Manager CLI, log on as operator OLEG with password MONDAY, connect to the database instance DEMODB on virtual server HOTEL_VIRTUAL, display all hot standby parameters of the hot standby system:
>dbmcli -u OLEG,MONDAY -d DEMODB –n HOTEL_VIRTUAL hss_getnodes
OK
HostStandbyStorageDLLPath libhsscopy
OfficialNodeName HOTEL_VIRTUAL
HotStandbyNodeName001 GENUA
HotStandbyNodeName002 PARMA
Result
The memory management of the hot standby system uses the libhsscopy library. The virtual server name of the system is HOTEL_VIRTUAL. The current master instance is on the computer GENUA. The hot standby system includes the computers GENUA and PARMA.
Database Administration, Hot Standby