Command Reference Guide

Object DS Commands
SQL/MX Connectivity Service Administrative Command Reference—526350-005
5-9
ALTER DS
IdleServer count
is the lower limit on the available idle servers that are operational for this service
on this DS. Valid values are 0 through MaxServer count, with 0 as the default.
This count represents idle servers that are waiting for user connections. At DS
startup, once the InitServer count is satisfied, additional servers are started
until the IdleServer count is reached. Initially, idle servers are started in blocks
of five, with a check for incoming connection requests occurring between each
block. After peak user loads, idle servers are terminated to the IdleServer
count value (see IdleTimeout on this page).
InitServer count
is the suggested number of servers that each service starts when the DS first
starts. Legal values are from 0 to the smaller of either 1000 or the value specified
by MaxServer count, with the default value as 0. If the initial server count
exceeds 1000, an error is displayed. When the value for InitServer count is
greater than 0, the servers are started in blocks of five with a check for incoming
connection requests occurring between each block. To permit servicing incoming
users, the DS goes to the STARTED state as soon as the first server starts. These
servers count as idle servers if they are not allocated to new users immediately.
IdleTimeout timeout-val
is a keyword or integer number of minutes a server waist in the available state for a
connection before it stops itself when the count of servers exceeds the DS server
count for the DS. Valid values are SYSTEM_DEFAULT, which is defined by MXCS
(ten minutes, currently); NO_TIMEOUT; and the integer one to a large number.
ConnTimeout timeout-val
is a keyword or the integer number of minutes a client-server connection remains
idle before the server terminates the connection and becomes available. Valid
values are SYSTEM_DEFAULT, which is defined by MXCS (ten minutes,
currently); NO_TIMEOUT; and the integer one to a large number.
StartAutomatic [OFF]
is a flag to request the automatic starting of this DS when its associated server
process starts. Use this flag without the OFF option to turn it ON. The default value
is OFF when the attribute is not used. The DS is created in the stopped state and
must be explicitly started on one or more services.
Note. The value of 1000 is applicable from H06.26/J06.15 RVU and SQL/MX version R3.2.1.