DROP LOGICAL SERVER Statement

Drops a user-defined logical server. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.

Syntax

DROP LOGICAL SERVER logical-server-name  
 [ WITH STOP SERVER ]

Parameters

WITH STOP SERVER – automatically shuts down all servers in the logical server when the TEMP_DATA_IN_SHARED_TEMP option is changed directly or indirectly.

Applies to

Multiplex only.

Examples

Example 1 – drops a user-defined logical server ls1:
```
DROP LOGICAL SERVER ls1
```

Usage

SAP Sybase IQ performs the following catalog changes internally when dropping a logical server:

Drops all membership definitions of the logical server.
Drops its logical server assignment from each login policy that has an explicit assignment to the subject logical server. If it is the only logical server assigned to the login policy, SAP Sybase IQ sets the logical server assignment for the login policy to NONE.
Removes the logical server entry from ISYSIQ.LOGICALSERVER.

Permissions

Requires the MANAGE MULTIPLEX system privilege.