Viewing or Modifying Multiplex Server Properties

View or change general, configuration, and agent information, and options and values of properties for the selected multiplex server.

Prerequisites

Database Version	Multiplex Privileges
SAP Sybase IQ 15.3 and 15.4	View multiplex properties – none. Modify multiplex properties – you must have one of: DBA authority MULTIPLEX ADMIN authority
SAP Sybase IQ 16.0	View multiplex properties – none. Modify any property on the Configuration page – you must have all of: SERVER OPERATOR system privilege BACKUP DATABASE system privilege MANAGE MULTIPLEX system privilege Modify any property on the Options property page – you must have the SERVER OPERATOR system privilege. Modify any property on the Request Logging property page – you must have one of: MANAGE PROFILING system privilege SERVER OPERATOR system privilege Modify any property on the High Availability property page – you must have the MANAGE MULTIPLEX system privilege, and the coordinator must be running. The SCC agent for the multiplex server for which the Properties page is open must also be running.

Database Version

Multiplex Privileges

SAP Sybase IQ 15.3 and 15.4

View multiplex properties – none.

Modify multiplex properties – you must have one of:

DBA authority
MULTIPLEX ADMIN authority

SAP Sybase IQ 16.0

View multiplex properties – none.

Modify any property on the Configuration page – you must have all of:

SERVER OPERATOR system privilege
BACKUP DATABASE system privilege
MANAGE MULTIPLEX system privilege

Modify any property on the Options property page – you must have the SERVER OPERATOR system privilege.

Modify any property on the Request Logging property page – you must have one of:

MANAGE PROFILING system privilege
SERVER OPERATOR system privilege

Modify any property on the High Availability property page – you must have the MANAGE MULTIPLEX system privilege, and the coordinator must be running. The SCC agent for the multiplex server for which the Properties page is open must also be running.

The SAP Sybase IQ resource is authenticated and running.
The multiplex server’s SCC agent is registered, authenticated, and running.
You must be licensed for the Multiplex Grid option (IQ_MPXNODE), if you are running secondary servers.

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Multiplex Management, and then select Multiplex Servers.
Select the multiplex server in the right pane and either:
- Click the drop-down arrow to the right of the name and select Properties, or,
- From the Administration Console menu bar, select Resource > Properties.

View or modify the server properties.

Configuration changes may take several minutes to complete.
When you are modifying properties, you need not click Apply before changing screens; however, doing so saves any changes.
If you do not have privileges to modify properties, SAP Control Center displays the properties view in read-only mode.

Area	Description
General (Read-only)	Server name – Name of the server. Host – Host name where the server is running. Port – Port where the server is running. Database – Database name. Server version – Server version number. Platform – Platform the server is running on. Platform version – Version of the operating system where the server is running. Type – Server type: Reader, Writer, or Coordinator. Change – Change the node type. Note: This option is unavailable on the coordinator node. Status – Server status: Include or Excluded. Designated Failover Node – True or False. If true, then this server is the designated failover node.
Configuration	Server name – Name of the server. Public Host/Ports – Public host names and port numbers. Private Host/Ports – Information about private hosts and ports to be used. Database file path – Location of the .db file.
Agent (Read-only)	Agent registered – Indicates if the SAP Control Center agent is registered: true or false. Agent authenticated – Indicates if the SAP Control Center agent is authenticated: true or false. Agent status – Status of the SAP Control Center agent: Running, Stopped, or Unknown. Agent host – Name of the host machine the SAP Control Center agent is running. Agent port – Port number on the host machine the SAP Control Center agent is running. Agent user – User name for authentication of the agent. Default is `uafadmin`. Agent process owner – The user who owns the agent process. Agent home – The home directory of the SAP Control Center agent. Agent version – The version of the SAP Control Center agent. SCC agent plugin version – The agent plugin version of the SAP Control Center agent. IQ directory – Installation directory of the IQ server with which the SAP Control Center agent is associated. IQ version – Version of the IQ server with which the SAP Control Center agent is associated.
Server Properties page (Read-only)	Properties – The name, value, and description of all server properties.
Request Logging	Enable request logging – Select to enable request logging. All connections to this server – Select to log requests from all connections to the server. All connections to the following database – Specify the name of a database to log requests to all connections. The following connections – Specify the connections to log. Select type of requests to log – Select the type of requests to log: All Include host variables Triggers Connections blocked from proceeding SQL Procedures Plan Note: Some types of requests have dependencies on other types. For example, if you specify Include host variables, the information listed for SQL is also logged. See sa_server_option system procedure in IQ-product-name Reference: Building Blocks, Tables, and Procedures. Log file name – Specify the pathname of the log file. Maximum log file size – Specify the maximum size of the log file in KB. Maximum number of log files – Specify the maximum number of log files. Overwrite the request log file if it already exists – Select to overwrite an existing log file.
Options page	Current time – The current time. Refresh – Update the current time. Quitting time – Enter a time for the database server to shut down. Use the same format as the current time: YYYY-MM-DD HH:NN:SS.SS Disable new connections – Prevent other users from connecting to the database. This may be useful for some maintenance operations. Remember last statement – Instruct the database server to capture the most recently prepared SQL statement for each connection to a database on the server.
INC page (Read-only)	Note: This page does not appear for the coordinator node. Link – Describes the INC connection shown, in the format <secondary node> => <coordinator node>. INC state – Current state of internode communication. Secondary server name – Name of secondary server. Heartbeat frequency – Interval until the heartbeat thread wakes and cleans up the connection pool on the secondary node. Last successful heartbeat – Date and time of the last successful heartbeat. Time not responding – Elapsed time since the last successful heartbeat. Time until timeout – Time remaining until timeout occurs due to no response. Liveness timeout – Time, in seconds, before a heartbeat on a secondary server declares the coordinator offline if the heartbeat fails to reconnect to the coordinator after the first disconnect. This option also determines how long the coordinator keeps a global transaction in a suspended state. Auto exclude timeout – Timeout for autoexcluding a secondary node on the coordinator node. 0 indicates that the nodes are not autoexcluded. This option does not apply to the designated failover node. Maximum connection pool size – Maximum number of connections allowed in the connection pool on a secondary node. Values can be 1 to 1000. Default is 10. Current connection pool size – Current number of connections in the connection pool. Number of idle connections – Current number of idle connections. Number of connections in use – Number of connections currently in use. Refresh – Update the current display.
MIPC page (Read-only)	Name – Multiplex node name. Public Status – Current public status of each node. Status is “Not responding” if communication with that node fails. Private Status – Current private status of each node. Status is “Not configured” if there is no private TCP/IP configuration for that server.
High Availability	Enable multiplex high availability – Enable high availability for the server. You must select the option for every server in the multiplex, to implement high availability. Unselect to disable high availability. Agent TDS Port – Port number of the Tabular Data Stream port used for SCC server and agent communication. You must enable the TDS port to allow high availability. See Configuring Ports and scc Command. User Name – User name for registering the SCC Agent for the multiplex server. Password – Password for authenticating the SCC Agent for the multiplex server.

Do one of:
- Click OK to update any changes to the database and exit the properties view.
- Click Apply to update any changes to the database, but remain in the properties view.
- Click Cancel to cancel any changes not updated to the database and exit the properties view.