Performs administrative tasks on Adaptive Servers configured with Sybase Failover in a high availability system. sp_ha_admin is installed with the installhavss script on UNIX platforms or the insthasv script on Windows NT.
sp_ha_admnin [cleansessions | help]
removes old entries from syssessions. Old syssessions entries are typically left behind because either Adaptive Server failed to clean up syssessions during a reboot, or because a client failed to connect to Adaptive Server.
displays the syntax for sp_ha_admin.
Removes old entries from syssessions left by a client connection that did not exit correctly:
sp_ha_admin cleansessions (return status = 0)
Displays the syntax for sp_ha_admin:
sp_ha_admin "help"
sp_ha_admin Usage: sp_ha_admin command [, option1 [, option2]] sp_ha_admin commands: sp_ha_admin 'cleansessions' sp_ha_admin 'help' (return status = 0)
sp_ha_admin performs administrative tasks on Adaptive Server that are configured for Sybase’s Failover in a high availability system. sp_ha_admin is not installed using the installmaster script; instead, use the installhavss script that installs and configures for Sybase’s Failover (insthasv on Windows NT).
sp_ha_admin returns a 0 if it successfully cleaned up syssessions, and returns a 1 if it encounters an error.
sp_ha_admin enters a message in the errorlog if it could not remove any entries from syssessions (for example, if it could not get a lock on syssessions).
To view all the current entries in syssessions, enter:
select * from syssessions
You must be a user with ha_role to execute sp_ha_admin. Permission checks do not differ based on the granular permissions settings.
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
