ALTER LOGICAL SERVER Statement

Syntax

ALTER LOGICAL SERVER  logical-server-name   
	{ alter-ls-clause } [ WITH STOP SERVER ]

Parameters

alter-ls-clause –

{ADD MEMBERSHIP  '(' { ls-member, ... } ')' 
| DROP MEMBERSHIP '(' { ls-member, ... } ')'
| POLICY policy-name }

ls-member –

FOR LOGICAL COORDINATOR 
| mpx-server-name

Applies to

Multiplex only.

Examples

Example 1 – alters a user-defined logical server by adding multiplex nodes n1 and n2 to logical server ls1:
```
ALTER LOGICAL SERVER ls1 ADD MEMBERSHIP (n1, n2)
```
Example 2 – adds logical membership of COORDINATOR and drop a named membership of the current coordinator node n1 from logical server ls1:
```
ALTER LOGICAL SERVER ls1 ADD MEMBERSHIP (FOR LOGICAL COORDINATOR)
ALTER LOGICAL SERVER ls1 DROP MEMBERSHIP (n1)
```
Example 3 – changes the logical server policy for logical server ls2 to policy lsp1.
```
ALTER LOGICAL SERVER ls2 POLICY lsp1
```

Usage

logical-server-name refers to an existing user-defined logical server name.

The SYS.ISYSIQLSMEMBER system table stores definitions for the logical server memberships.

A member node that is added to or dropped from a logical server starts or stops accepting logical server connections only after the TLV log corresponding to ALTER LOGICAL SERVER is played on that node. Existing connections of a logical server continue to run on a node when that node is dropped from the logical server, however, distributed processing is stopped for these connections.

An error is returned if:

Any ls-member specified with the ADD MEMBERSHIP clause is already a member of the logical server.
Any ls-member specified with the DROP MEMBERSHIP clause is not an existing member of the logical server.
A logical server membership change causes a node to belong to multiple logical servers assigned to a single login policy. Logical server membership in a login policy cannot overlap.

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.