Use this command to send a DBM command directly to a standby database in the hot standby system.
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.
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.
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 |
OK
In the event of errors, see Reply Format.
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.
Commands for Managing Hot Standby Systems
Database Administration, Hot Standby System, Checking Database Structures