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 required. Modify multiplex properties – Requires one of: DBA authority. MULTIPLEX ADMIN authority.
SAP Sybase IQ 16.0	View multiplex properties – None required. Modify any property on the Configuration – Requires all of: SERVER OPERATOR system privilege. BACKUP DATABASE system privilege. MANAGE MULTIPLEX system privilege. Modify any property on the Options property page – Requires SERVER OPERATOR system privilege. Modify any property on the Request Logging property page – Requires one of: MANAGE PROFILING system privileges. SERVER OPERATOR system privileges.

Database Version

Multiplex Privileges

SAP Sybase IQ 15.3 and 15.4

View multiplex properties – None required.

Modify multiplex properties – Requires one of:

DBA authority.
MULTIPLEX ADMIN authority.

SAP Sybase IQ 16.0

View multiplex properties – None required.

Modify any property on the Configuration – Requires all of:

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

Modify any property on the Options property page – Requires SERVER OPERATOR system privilege.

Modify any property on the Request Logging property page – Requires one of:

MANAGE PROFILING system privileges.
SERVER OPERATOR system privileges.

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

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Multiplex Management > 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.
The Server Properties view appears.

View or modify the server properties.

Configuration changes may take several minutes to complete.
When modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
If you do not have privileges to modify properties, Sybase 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 Sybase Control Center agent is registered: true or false. Agent authenticated – Indicates if the Sybase Control Center agent is authenticated: true or false. Agent status – Status of the Sybase Control Center agent: Running, Stopped, or Unknown. Agent host – Name of the host machine where the Sybase Control Center agent is running. Agent port – Port number on the host machine where the Sybase Control Center agent is running. Agent user – User name for authentication of the agent. Default is `uafadmin`. Agent process owner – The user name that owns the agent process. Agent home – The home directory of the Sybase Control Center agent. Agent version – The version of the Sybase Control Center agent. SCC agent plugin version – The agent plugin version of the Sybase Control Center agent. IQ directory – Installation directory of the IQ server with which the Sybase Control Center agent is associated. IQ version – Version of the IQ server with which the Sybase 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 – Check to enable request logging. All connections to this server – Check 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 – Check 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. For details, in the SAP Sybase IQ documentation, see sa_server_option system procedure in SAP Sybase IQ 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. Maximum number of log files – Specify the maximum number of log files. Overwrite the request log file if it already exists – Check to overwrite an existing log file.
Options page	Current time – The current time. Refresh – Click Refresh to 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 is not visible for 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 last successful heartbeat. Time not responding – Elapsed time since 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 auto-excluding a secondary node on the coordinator node. 0 indicates that the nodes will not be auto-excluded. 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 – Click Refresh to update the current display.
MIPC page (Read-only)	Node – Multiplex node name. Public Status – Current public status of each node. Status is set to “Not responding” if communication with that node fails. Private Status – Current private status of each node. Status is set to “Not configured” if there is no Private TCP/IP configuration for that server.

Click OK.