hss_getnodes 

Use

You display the hot standby database parameters of the hot standby system.

See also:

Concepts of the Database System, Hot Standby

Prerequisites

You have the server authorizations ParamRead, ParamCheckWrite, or ParamFull.

●     You are connected to the database instance of the hot standby system on the virtual server.

Syntax

hss_getnodes

Reply

OK

HS_STORAGE_DLL       <file_name>

OFFICIAL_NODE        <virtual_server_name>

HS_DELAY_TIME_<nnn>  <delay_time>

HS_SYNC_INTERVAL     <sync_interval>

HS_NODE_<nnn>     <master_database_computer>_<nnn>

HS_NODE_<nnn>     <standby_database_computer>_<nnn>

HS_NODE_<nnn>     <standby_database_computer>_<nnn>

...

Values for the Reply Fields

Field	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)

Example

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

HS_STORAGE_DLL libhsscopy

OFFICIAL_NODE  HOTEL_VIRTUAL

HS_NODE_001    GENUA

HS_NODE_002    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.