When the HA agent fault monitor, ase_monitor, runs the thorough_probe, it performs the following transactions:
Connects to the Adaptive Server.
Creates a table, inserts an entry into the table, updates the table, and deletes the table.
Disconnects from Adaptive Server after the thorough_probe runs the number of times as specified by the Connect_cycle_count. Next, thorough_probe establishes a new connection.
Create or specify a special user and login for the monitor to perform the thorough_probe operation. Use isql to connect to the dataserver and issue:
sp_addlogin <user for monitoring ase>, <password> sp_adduser <user for monitoring ase>
For example:
sp_addlogin ase_monitor_user,ase_monitor_user_password sp_adduser ase_monitor_user
During 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. That is, if the total number of connections is 25, the
effective number of connections available for other purposes will
be 24, as one is used by the fault monitor probe.
