Before you configure for an asymmetric set up, you must first use the scswitch utility to disable the monitoring of the primary and secondary resources.
scswitch -n -M -j primary_resource scswitch -n -M -j secondary_resource
Use sp_companion to configure the primary companion for asymmetric configuration:
sp_companion "primary_server_name", configure, with_proxydb, login_name, password
Where:
primary_server_name is the name of the primary Adaptive Server as defined in the interfaces file entry and in sysservers.
with_proxydb indicates that proxy databases are created on the secondary companion for all databases other than system databases. Any subsequent databases that are added also create proxy databases.
login_name is the name of the user performing this cluster operation (user must have ha_role permission).
password is the password of the person performing this cluster operation.
This example configures an Adaptive Server named MONEY1 as a primary companion:
sp_companion "MONEY1", configure, with_proxydb, sa, Odd2Think
Server 'MONEY1' is alive and cluster configured. Step: Access verified from Server:'MONEY1' to Server:'PERSONEL1' Server 'PERSONEL1' is alive and cluster configured. Step: Access verified from Server:'PERSONEL1' to Server:'MONEY1' (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) ..... Step: Companion servers configuration check succeeded Step: Server handshake succeeded Step: Master device accessible from companion Step: Added the servers 'MONEY1' and 'PERSONEL1' for cluster config Step: Server configuration initialization succeeded Step: Synchronizing server logins from companion server Step: Synchronizing remoteserver from companion server Step: Synchronizing roles from companion server Step: Synchronizing server-wide privs from companion server Step: User information syncup succeeded Step: Server configured in normal companion mode
If user databases already exist while you are using sp_companion, you see messages similar to these:
Step: Created proxy database ‘pubs2’ Step: Proxy status for database has been set. Please Checkpoint the database 'pubs2' Step: Server configured in normal companion mode”
Use the scswitch utility to enable the monitoring of the primary resource:
scswitch -e -M -j primary_resource
To prevent the failover of the secondary companion server in asymmetric configuration, you must disable the monitoring of the secondary resource after failover.
See “Asymmetric Companion Configuration” for more information about asymmetric configuration.