Determines the current status of the LDAP server configuration object.
sa_get_ldapserver_status()
You must have EXECUTE privilege on the system procedure.
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. |
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.