Configuring companion servers for Failover  Running sp_companion with do_advisory

Chapter 10: Configuring Linux Adaptive Server for Failover on Veritas 2.1

Adding user and login for HA monitor on VCS versions 2.1

Create a special user and login for the monitor for each data server associated with the HAase resource. Use isql to connect to the data servers and issue:

sp_addlogin probe_ase, password

sp_adduser probe_ase

For example:

sp_addlogin joe, joe_password

sp_adduser joe

NoteDuring Adaptive Server configuration, the System Administrator should take into account that the user and login used for probe actually reduces by one the total number of connections available for other purposes. Because the applications connecting to Adaptive Server may use all available user connections, the probe_user may not be able to log in to Adaptive Server, which could cause Adaptive Server to fail over. You should set the number of user connections high enough to prevent this from happening.

For more information about storing the monitor login information, see “Creating an Adaptive Server login file”.





Copyright © 2004. Sybase Inc. All rights reserved. Running sp_companion with do_advisory

View this book as PDF