sp_ha_admin

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.

Syntax

sp_ha_admnin [cleansessions | help]

Parameters

Examples

Usage

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

Permissions

You must be a user with ha_role to execute sp_ha_admin. Permission checks do not differ based on the granular permissions settings.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

InformationValues
Event

38

Audit option

exec_procedure

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