Drops a user-defined logical server.
DROP LOGICAL SERVER logical-server-name [ WITH STOP SERVER ]
DROP LOGICAL SERVER ls1
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.
Requires the MANAGE MULTIPLEX system privilege.