Editing the Multiplex Server Configuration File

Change multiplex server configuration settings including administrative, memory, connection, and debugging settings.

1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
2. In the left pane, expand IQ Servers > Multiplex Management, and then select Multiplex Servers.
3. Select a multiplex server from the right pane and either:
   • Click the drop-down arrow to the right of the name and select Edit Configuration File, or,
   • From the Administration Console menu bar select Resource > Edit Configuration File.
   The Config file editor window appears.
4. Adjust the configuration values.
   • 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
   Admin	Disable triggers – Disable firing of triggers. Checkpoint timeout period – Set the maximum length of time, in minutes, that the database server runs without doing a checkpoint. Maximum recovery time – Set the maximum length of time, in minutes, that the database server takes to recover from system failure. Start database permission – Specify permission required to start the database: "dba", "all" or "none". Stop database permission Specify permission required to stop the database: "dba", "all" or "none". Load/unload permission – Set LOAD/UNLOAD permission to "dba", "all" or "none". Utility permission – Set utility commands (e.g., DROP DATABASE) permission to "utility_db", "dba", "all" or "none".
   Memory	Display cache sizing statistics – Displays cache size changes. Disable automatic cache resizing – Enforces a static cache size. Disables automatic cache resizing. Initial cache size – Sets the initial memory reserved for caching database pages and other server information. The size is the amount of memory. Select Kilobytes, Megabytes, Gigabytes. Select % to specify a percentage either of the physical system memory, or of the maximum non-AWE cache size, whichever is lower. Minimum cache size – Sets a minimum cache size as a lower limit to automatic cache resizing. The size is the amount of memory, in bytes. Select Kilobytes, Megabytes, Gigabytes. Select % to specify a percentage either of the physical system memory, or of the maximum non-AWE cache size, whichever is lower. Maximum cache size – Sets a maximum cache size, as a limit to automatic cache growth. The size is the amount of memory, in bytes. Select Kilobytes, Megabytes, Gigabytes. Select % to specify a percentage either of the physical system memory, or of the maximum non-AWE cache size, whichever is lower. Engine thread stack size – Sets server thread stack size. The size is the amount of memory, in bytes. Select Kilobytes or Megabytes. Number of engine threads – Sets the number of execution threads used for the catalog store and connectivity while running with multiple users. Recommended value is 1.5 times the maximum number of concurrent connections to the server; minimum of 25. Number of concurrent OS threads – Sets maximum number of physical processors to use (up to licensed maximum). External DLL thread stack size – Sets the stack size for threads running external functions, in bytes. The default is 32 KB. Large Memory – Maximum amount of memory, in megabytes, that SAP Sybase IQ can dynamically request from the operating system for temporary use. Maximum page size – Sets the maximum page size in KB.
   Connections	Shutdown after last database closes – Automatically shut down after the last database is closed. Encrypt communication messages – Enable packet encryption on the network server. Enable client-server character translation – Character set translation is turned on by default. There is a performance cost associated with character set translation. If you can set up an environment such that no character set translation is required, then you do not have to pay this cost, and your setup is simpler to maintain. Maximum connections – Specifies the maximum number of concurrent user connections. Communication packet size – Specifies a maximum packet size. If you want to send small amounts of data over the network, keep the default network packet size small. The default is 512 bytes. Idle time before disconnect – Set the amount of client idle time before the connection is terminated. If a client runs for the idle timeout period without submitting a request, the connection is severed. Liveness timeout – A liveness packet is sent across a client/server to confirm that a connection is intact. If the client runs for the liveness timeout period without detecting a liveness packet, the communication will be severed. This parameter works only with network server and TCP/IP communications protocols. The default is 120 seconds. Quitting time – Lets you specify a time when the database server is to shut down. Broadcast level – Specifies how the server reacts to broadcasts. (Ignore All) causes the server not to start up any UDP broadcast listeners. (dblocate) causes the server to not respond to broadcasts from dblocate, while leaving connection logic unaffected.
   Database	Set database read-only – Forces all databases that start on the database server to be read-only. No changes to the databases are allowed: the database server doesn't modify the database files or transaction log files. Truncate xact log after checkpoint – Causes the transaction log to be truncated after each checkpoint for all databases.
   Debug	Generate debug information – Display debugging information. Remember last statement on each connection – Instruct the database server to capture the most recently prepared SQL statement for each connection to a database on the server. Debug level – Enables request-level logging of operations. Debug output file name – Redirects HTTP Web service client procedure debug log to a file. Max output file size – Specify maximum size of file for server request logging.
   IQ	Number of CPUs IQ can use – Specifies the number of CPUs available to IQ, overriding the physical number of CPUs for resource planning purposes. The value defaults to the total number of CPUs, but the range of available values is 1 – 128. Number of threads – Sets the number of execution threads that will be used for the catalog store and connectivity while running with multiple users. This parameter applies to all operating systems and servers. Each connection uses a thread for each request, and when the request is completed, the thread is returned to the pool for use by other connections. As no connection can have more than one request in progress at one time, no connection uses more than one thread at a time. Thread stack size – Specifies the stack size, in KB, for server execution threads running either in the background or as part of a thread team assisting the main server connection thread. The default is 512KB on 64-bit platforms, and 200KB on 32-bit platforms. Wired memory pool size – Pool of wired memory on HP and Sun UNIX systems. This memory is locked down so it cannot be paged by the operating system. Specify the memory size, in MB. Use this switch only if you have enough memory to dedicate for this purpose. Otherwise, you may cause serious performance degradation. Main buffer cache size – Specifies the main IQ store cache size in MB. Always specify the value for the size, but no units of measurement; for example specify 32 instead of 32MB. Temporary buffer cache size – Specifies IQ temporary store cache size in MB. Always specify the value for the size, but no units of measurement; for example specify 32 instead of 32MB. Number of concurrent queries – The number of concurrent queries is not the same as the number of connections. This setting can help SAP Sybase IQ optimize paging of buffer data out to disk and avoid overcommitting memory. The default value of this switch is equal to 2 times the number of CPUs on your machine, plus 10. You may find that another value, such as 2 times the number of CPUs plus 4, provides better throughput, especially when large numbers of users are connected. Number of partitions for buffer cache – Specifies the number of partitions in the IQ main and temp buffer caches. Must be a power of 2. Allowed values are: 0 (default), 1, 2, 4, 8, 16, 32, 64. By default, IQ computes the number of partitions automatically as number_of_cpus/8, rounded to the nearest power of 2, up to a maximum of 64. You may be able to improve performance by adjusting the number of cache partitions. Force recovery on database – Open database in forced recovery mode.
   Transport Layer Security	Use Transport Layer Security – Secure communications between a client and the SAP Sybase IQ server or between an SAP Sybase IQ client and the database server. SAP Sybase IQ supports only the RSA encryption algorithm. Check this box to enable other components on this page. Identity file – Contains the server's public certificate, private key and, for certificates that are not self-signed, all the signing certificates, including the encryption certificate. The password for the certificate must be specified with the Identity_Password parameter. Private key password – Must match the password supplied during encryption certificate creation. There is no default password.
   Misc	Quiet mode – Runs Interactive SQL in quiet mode. Run as a daemon – Using this option lets you run the server so that it continues running after the current user session ends. Use buffered disk I/O – Uses buffered disk I/O [Windows, UNIX]. Syslog facility ID – Syslog facility ID. The default is user. Either none, user, daemon, local0,...,local7). Output message file name – Filename for copy of message window. File is truncated first. Output message file size – Appends .old to the log file name and starts a new file with the original name when log reaches the specified size. Touch temporary file timer – (UNIX servers) Causes the server to touch catalog store temporary files at intervals specified in minutes. Temporary Files Directory – Directory where temporary files are stored. Request Log Copies – Number of request log file copies to retain. Message Log Size – Maximum size of the message log, in megabytes. Message Log Archives – Number of old message logs maintained by the server. User specified – Enables advanced users to specify configuration options not shown in the Config file editor window. Enter multiple parameters using the space character as a separator.

5. 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.