onmode -d: Set High Availability server characteristics

Syntax:

Read syntax diagramSkip visual syntax diagramonmode -dmake primaryha_alias1forceRS Secondary server commandsSD Secondary server commands
RS Secondary server commands
Read syntax diagramSkip visual syntax diagramadd RSSrss_ha_alias2RSSprimary_ha_alias1passwordchange RSSrss_ha_aliaspassword2delete RSSrss_ha_alias2
SD Secondary server commands
Read syntax diagramSkip visual syntax diagramset SDS primaryha_alias3forceclear SDS primaryprimary_ha_alias2
Notes:
  • 1 Run on secondary server only.
  • 2 Run on primary server only.
  • 3 Run on primary server or secondary server.
Element Purpose Key Considerations
-d Used to create, modify, or delete secondary servers in high-availability configurations  
add RSS Adds an RS secondary server This command should be run on the primary database server.
rss_ha_alias Identifies the RS secondary database server's high-availability alias. The value can be an HA_ALIAS value or an ER group name.
password Specifies the secondary server password The password is used only during the first connection attempt. After the primary and secondary server have connected, the password cannot be changed.
RSS Sets an RS secondary server type This command should be run on the secondary database server.
pri_ha_alias Identifies the name of the primary server  
change RSS Change an RS secondary server This command should be run on the primary database server.
delete RSS Removes an RS secondary server definition This command should be run on the primary database server.
set SDS primary Defines the server as a shared disk primary server  
ha_alias The high-availability alias of the database server When used with set SDS or make primary, this is the name of the server whose role is changing.
force Used to force a change If the force option is specified, the operation is performed without requiring that the secondary server be connected to the current primary server. If the force option is not specified, the operation must be coordinated with the current primary server. The force option should be used only when the DBA is certain that the current primary server is not active; otherwise, the shared disk subsystem can become corrupted.
clear SDS primary Disables the shared disk environment. The server name specified no longer acts as an SD primary server  
make primary Creates a primary server The make primary command can be issued on any type of secondary server, including HDR secondary, RS secondary, and SD secondary servers. If make primary is run on:
  • HDR Secondary: The current primary server is shut down and the secondary is made the primary.
  • RS secondary: The server is changed to a standard server.
  • SD secondary: The server is made the new primary server.

You can also set data replication characteristics can with SQL administration API command equivalents. For more information see SQL Administration API Overview and the IBM® Informix Administrator's Guide.

For other onmode -d information, see onmode -d: Set data-replication types and onmode -d command: Replicate an index with data-replication.