DROP LOGICAL SERVER Statement

Syntax

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

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.

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.

This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.

Permissions

Requires the MANAGE MULTIPLEX system privilege.