Use this command to display the properties and the databases of a hot standby system.
You have the server permission ParamRead, ParamCheckWrite or ParamFull.
You are connected to the database on the virtual server.
hss_getnodes
OK
HotStandbyStorageDLLPath <file_name>
Shared Resources <hs_mode>
VirtualServerName <virtual_server_name>
CurrentComputerName <current_computer_name>
HotStandbyNode<nnn <database_computer_name> [<delay_time>] <database_name> <role>
HotStandbyNode<nnn+1 <database_computer_name> [<delay_time>] <database_name> <role>
Value |
Description |
---|---|
<file_name> |
Name of the library used to access the memory management system If the field is empty, no such library is used by the database. |
<hs_mode> |
High availibility mode used by the hot standby system: Possible values are: None | Log None: The log entries are simultaneously written to the log area of the master database and to the log area of the standby database. Log: The master and the standby databases share the same log area. |
<virtual_server_name> |
Name of the virtual server |
<current_computer_name> |
Name of the computer currently connected to the client |
<database_computer_name> |
Name or IP address of the database computer |
<delay_time> |
Only relevant for the high availibility mode based on a shared log area: Delay (in s) applied to copy changes made in the master database to the standby database. |
<database_name> |
Name of the database |
<role> |
Role of the database within the hot standby system Possible values are: Unknown | Master | Standby Unknown: The role could not be determined. Master: Master database Standby: Standby database |
<nnn> |
Internal number <nnn> of the standby database |
Database Administration, Hot Standby System
Database Studio, Setting Up Hot Standby Systems: Overview