set cluster

The cluster must be down to execute all set cluster commands except set cluster login.

Syntax

set cluster {
	maxinst max_num_instances |
	traceflags trace_flag[, trace_flag[,...]] |
	{ primary | secondary } protocol udp |
	login login_name [password password ] }

Parameters

• maxinst max_instances – specifies the maximum number of instances that can run in the cluster.
• traceflags trace_flag[, trace_flag[,...] – specifies trace flags to be set when the cluster starts.
• login login_name [password password] – specifies a user name and password that the Unified Agent uses to log in to the cluster and perform shutdown and certain other tasks.
  Note: You can only use set cluster login to change the login or password that the Unified Agent uses to log in to the cluster. To change the login or password sybcluster uses to log in to the Unified Agent, use the Agent Management Console SQL Central plug-in.
• { primary | secondary } protocol udp – sets the protocol for the private network for the primary or secondary interface.

Examples

• Change the maximum number of instances – Changes the maximum number of instances to 4 for “mycluster”:

  set cluster maxinst 4

• Add a trace flag – Adds the trace flag 15506:

  set cluster traceflags 15506

• Change the password – Changes the password for the “sa” user name:

  set cluster login sa password abcde

Usage

To check that the cluster is down, enter show cluster status.

Permissions

The login for login login_name [password password] must have sa_role. By default, the Unified Agent uses the “sa” login with no password. To change this password, use set cluster login.