Show TOC

hss_executeLocate this document in the navigation structure

Use

Use this command to send a DBM command directly to a standby database in the hot standby system.

Note

Do not use this DBM command for change operations, but only to retrieve information about the standby database.

All modifying DBM commands must be sent to the hot standby system and not to an individual standby database. The hot standby system forwards the DBM command to the master database. The master database executes the DBM command and synchronizes the standby databases if necessary.

Prerequisites
  • You have the server permissions required for the DBM command to be sent.

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

Structure

hss_execute [node=]<computer_name> [database=<database_name>] <command>

<command> :: = <dbm_command> [<parameters>]

Option

Description

<computer_name>

Computer name, IP address, or internal number <nnn> of the standby database ( nnn> 1)

<database_name>

Name of the standby database in which the DBM command is to be executed

<dbm_command>

DBM Command

<parameters>

Additional parameters and options for the DBM command to be carried out on the standby database

Result

OK

In the event of errors, see Reply Format.

Example

Displaying the Operational State of Standby Database

Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database ( DEMODB) on the virtual server and execute the command to display the operational state of the standby database on the database computer with the internal node number 2:

> dbmcli -u OLEG,MONDAY -d DEMODB -n HOTEL_VIRTUAL hss_execute db_state 2

OK

State

STANDBY

Database Structure Check on Standby Database

The database structure check can be started on the standby database. The master database is not affected by this check. To perform the database structure check use the DBM command hss_execute <standby_node> db_execute check data.