Dropping a server definition

When you no longer need to access a data source server, you can drop the server definition. Dropping a server definition deletes the definition from the global catalog. The data source object that the server definition references is not affected.

Before you begin

Ensure that you have SYSADM or DBADM authority.

About this task

When you no longer need to access a data source server, drop the server definition from the federated database. When you drop a server definition, other objects that you registered with the federated server are impacted:
  • All user-defined function mappings, user-defined data type mappings, and user mappings that depend on the dropped server definition are dropped.
  • All nicknames that depend on the dropped server definition are dropped. Dropping the nicknames dependent on the server definition, affects the objects that depend on those nicknames:
    • Any index specifications that depend on the dropped nicknames are dropped.
    • Any views that depend on the dropped nicknames are marked inoperative.
    • Any materialized query tables that depend on the dropped nicknames are dropped.
  • All packages and cached dynamic SQL statements dependent on the dropped nicknames are marked invalid, and remain invalid until the dependent objects are re-created.
The federated server cannot process a DROP SERVER statement within a particular unit of work (UOW) under either of the following conditions:
  • The statement references a single data source, and the UOW already includes one of the following statements:
    • A SELECT statement that references a nickname for a table or view within the data source
    • An open cursor on a nickname for a table or view within the data source
    • An INSERT, DELETE, or UPDATE statement that is issued against a nickname for a table or view within the data source
  • The statement references a category of data sources (for example, all data sources of a specific type and version), and the UOW includes one of the following statements:
    • A SELECT statement that references a nickname for a table or view within one of the data sources
    • An open cursor on a nickname for a table or view within one of the data sources
    • An INSERT, DELETE, or UPDATE statement that is issued against a nickname for a table or view within one of the data sources

Procedure

Use one of the following methods:

  • Command line:

    Issue the DROP statement:

    DROP SERVER server_name

    where server_name identifies the server definition to be dropped.

    Example: An Informix® server uses the server name INFMX01. The following DROP statement drops the server definition: 
    DROP SERVER INFMX01
  • Web console:
    1. Click Administer > Remote Tables.
    2. Click Manage Servers.
    3. Click a server name.
    4. Click Drop.