When the HA agent fault monitor starts, it runs a “thorough” probe as part of the monitor, that performs the following transactions:
Connects to the data server.
Creates a 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 SY.ase resource property “Connect_cycle_count”.
Create a special user and login for the monitor for each data server associated with the SY.ase 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
During Adaptive Server configuration, the System Administrator
should take into account that the user and login used for the probe
actually reduces by one the total number of connections available
for other purposes.
