Dropping directory access servers (SQL)

Administrators can use Interactive SQL to delete directory access servers.

Prerequisites

You must have the SERVER OPERATOR system privilege.

All proxy tables defined for the directory access server must be dropped before dropping the directory access server. The following query can be used to determine which proxy tables are defined for the directory access server server-name.

SELECT st.table_name, sp.remote_location, sp.existing_obj
    FROM sysproxytab sp
    JOIN sysserver ss ON ss.srvid = sp.srvid
    JOIN systab st ON sp.table_object_id = st.object_id
    WHERE ss.srvname = 'server-name';

Context and remarks

You cannot alter an existing directory access server: you must drop the existing directory access server using a DROP SERVER statement, and then create a new one.

Drop a directory access server

Connect to the host database.
Execute a DROP TABLE statement for each proxy table associated with the directory access server.
DROP TABLE my_program_files;
Execute a DROP SERVER statement for the directory access server.
DROP SERVER my_dir_server;

Results

The directory access server is deleted.

Dropping directory access servers (SQL)

Drop a directory access server

See also