sa_get_ldapserver_status System Procedure

Determines the current status of the LDAP server configuration object.

Syntax

sa_get_ldapserver_status()

Arguments

None

Result Set

Column Name Data Type Description
ldsrv_id UNSIGNED BIGINT A unique identifier for the LDAP server configuration object that is the primary key and is used by the login policy to refer to the LDAP server.
ldsrv_name CHAR(128) The name assigned to the LDAP server configuration object.
ldsrv_state CHAR(9) Read-only state of the LDAP server:

1 – RESET

2 – READY

3 – ACTIVE

4 – FAILED

5 – SUSPENDED

A numeric value is stored in system table; a corresponding text value appears in the system view.
ldsrv_last_state_change TIMESTAMP Indicates the time the last state change occurred. The value is stored in Coordinated Universal Time (UTC), regardless of the local time zone of the LDAP server.

Remarks

To see SYSLDAPSERVER column values before a checkpoint occurs and the contents of memory are written to the catalog on disk.  The updates to the catalog columns ldsrv_state and ldsrv_last_state_change occur asynchronously during checkpoint to the LDAP server object as the result of an event that changes the LDAP server object state, such as a failed connection due to a failed LDAP directory server.  The LDAP server object state reflects the state of the LDAP directory server. 

Privileges

None.