When the high availability agent fault monitor, ase_monitor, runs the thorough_probe in Sun Cluster and higher, it thoroughly checks the performance of the Adaptive Server. thorough_probe:
Connects to the Adaptive Server.
Creates a temporary 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 thorough_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.
