CREATE LOGICAL SERVER Statement

Creates a user-defined logical server.

Syntax

CREATE LOGICAL SERVER  logical-server-name [MEMBERSHIP  
	'(' { ls-member, ...} ')']

Parameters

  • ls-member: – FOR LOGICAL COORDINATOR | mpx-server-name

Examples

  • Example 1 – This example creates a user-defined logical server ls1 with three multiplex nodes as its members.
    CREATE LOGICAL SERVER ls1 MEMBERSHIP ( n1, n2, n3 )

Usage

Applies to multiplex only.

The catalog stores the logical server and its membership definitions. To define a logical membership to the coordinator, specify FOR LOGICAL COORDINATOR in the MEMBERSHIP clause.

When no members are specified during the creation of a logical server, the logical server is created empty.

Note: Implicit logical server membership definitions such as those for OPEN and SERVER logical servers are not stored at all.

The SYS.ISYSLOGICALSERVER system table stores information about logical servers.

The SYS.ISYSLOGICALMEMBER system table stores information about logical server membership definitions.

logical-server-name can be any user specified identifier except:

  • OPEN
  • SERVER
  • NONE
  • DEFAULT
  • COORDINATOR
  • ALL

Changing ALLOW_COORDINATOR_AS_MEMBER option of the root logical server policy from ON to OFF does not affect the membership information stored in the catalog. Instead, it only affects the effective configuration of the logical server.

You can define a logical server membership to the current coordinator either by specifying the multiplex server name or by using FOR LOGICAL COORDINATOR clause, even when ALLOW_COORDINATOR_AS_MEMBER is set to OFF. Membership definition is stored in the catalog, but is inactive while that multiplex server acts as the coordinator.

Permissions

Must have DBA or MULTIPLEX ADMIN authority.

Parent topic: SQL Statements