ALTER LOGICAL SERVER Statement

Modifies configuration for the existing user-defined logical server in the database. 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

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

alter-ls-clause - (back to Syntax)
   {ADD MEMBERSHIP  '(' { ls-member, ... } ')' 
   | DROP MEMBERSHIP '(' { ls-member, ... } ')'
   | POLICY policy-name }

ls-member - (back to alter-ls-clause)
   FOR LOGICAL COORDINATOR | mpx-server-name

Parameters

(back to top)

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

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

Applies to

Multiplex only.

Examples

(back to top)

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

(back to top)

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.

Permissions

(back to top)

Requires the MANAGE MULTIPLEX system privilege.