Background documentationhss_getnodes Locate this document in the navigation structure

 

Use this command to display the hot standby database parameters of the hot standby system.

Prerequisites

Structure

hss_getnodes

Result

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>

...

Values for the Reply Fields

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)

Example

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.

More Information

Database Administration, Hot Standby