Entering content frame

Procedure documentation hss_getnodes Locate the document in the library structure

Use

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

See also:

Concepts of the Database System, Structure linkHot 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.

 

Leaving content frame