Performs administrative tasks on SAP ASE servers configured with Failover in a high availability system. sp_ha_admin is installed with the installhavss script on UNIX platforms or the insthasv script on Windows.


sp_ha_admnin [cleansessions | help]




There are additional considerations when using sp_ha_admin:
  • sp_ha_admin performs administrative tasks on the SAP ASE server that are configured for 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 Failover (insthasv on Windows).

  • 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:



Audit option


Command or access audited

Execution of a procedure

Information in extrainfo
  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect