Use this command to display the hot standby database parameters of the hot standby system.
You have the server permission ParamRead,
You are connected to the database 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 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 database are copied to the standby database nnn. |
<sync_interval> |
Minimum time span (in s) between two commands copied by the master database to synchronize the standby databases |
<master_database_computer> |
Computer of the master database |
<standby_database_computer> |
Computer of the standby database |
<nnn> |
Sequential number of the standby database (nnn > 1) |
Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database 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 database is on the computer GENUA. The hot standby system includes the computers GENUA and PARMA.
Database Administration, Hot Standby