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.

Quick Links:

Go to Parameters

Go to Examples

Go to Usage

Go to Permissions

Syntax

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

Parameters

(back to top)

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

(back to top)

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

Usage

(back to top)

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

(back to top)

Requires the MANAGE MULTIPLEX system privilege.