When the high availability agent fault monitor, ase_monitor, runs thorough probe, it:
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 cycle count reaches the value specified by the Adaptive Server resource property Connect_cycle_count.
Create or specify a special user and login for the monitor to perform a thorough probe operation. Use isql to connect to the data servers and issue:
sp_addlogin <user for monitoring ase>, <password> sp_adduser <user for monitoring ase>
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.
