Background documentationhss_getnodes Locate this document in the navigation structure

 

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

Prerequisites

  • You have the server authorization ParamRead,

    ParamCheckWrite or ParamFull.

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

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

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 instance is on the computer GENUA. The hot standby system includes the computers GENUA and PARMA.

More Information

Database Administration, Hot Standby