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.