Deleting an LDAP Server Configuration Object

Delete an LDAP server configuration object that is not in a READY or ACTIVE state.

Prerequisites

Requires the MANAGE ANY LDAP SERVER system privilege.

Task

The DROP statement fails when it is issued against an LDAP server configuration object that is in a READY or ACTIVE state. The DROP statement also fails if a login policy exists with a reference to the LDAP server configuration object being dropped. To ensure any references to the LDAP server configuration object are removed from all login policies before being dropped, include the WITH DROP ALL REFERENCES clause. To override the server state check and put the database object into maintenance mode regardless of its current state, include the WITH SUSPEND clause when dropping an LDAP server configuration object.

Dropping an LDAP server configuration object removes the named object from the ISYSLDAPSERVER system table

To drop an LDAP server configuration object, execute this command, including the applicable clauses:

DROP LDAP SERVER LDAP_Server_name
WITH SUSPEND
WITH DROP ALL REFERENCES

Example:

This example drops the LDAP server configuration object named ldapserver1 regardless of its current state and removes any references to ldapserver1 in all login policies:

DROP LDAP SERVER ldapserver1 
WITH DROP ALL REFERENCES 
WITH SUSPEND

This DROP LDAP SERVER command fails if the LDAP server configuration object named ldapserver2 is referenced in any login policies because the WITH DROP ALL REFERENCES clause is not included:

DROP LDAP SERVER ldapserver1 
WITH SUSPEND