HP Integrity NonStop J-Series - Manual (Page 84)

Table 22 General Properties options (continued)
Description Option Group
Specifies the number of minutes that a client-server connection remains
idle before the MXCS server terminates the connection. Connection Idle
Timeout
You must assign a value between 1 and 2,147,483,647. The system
default is 600 seconds.
You must select this option to collect statistics about the connection and
the session. Data source statistics are stored in the Event Monitoring Service
(EMS) log. The event ID is 21035. Connection
Information Session Statistics
You must select this option to collect statistics about individual SQL
statements. Data source statistics are stored in the EMS log. The event ID
is 21035. Session Summary
Specifies the upper limit of the servers that can be operational for a service
on the data source. Maximum Number of Servers
The default is 1. The range is 0 to 32767.
0 specifies the system default that is determined by the system at run time.
If you use the default of 1000 ports for MXCS during installation, the range
is 1 through 997.
If you configure more than 1000 ports for MXCS, the value for Maximum
is the number of configured ports minus 3. In this case, the actual maximum
number of MXCS servers can sometimes be greater than the number of
ports configured.
Specifies the lower limit of the available idle MXCS servers that are
operational for a service on the data source. Idle
The values range from 0 to 32767. The default is 0.
This value cannot exceed the maximum server value.
CAUTION: The sum of all the Idle values for a given system must not
exceed the number of ports specified when the MXCS service was started
up. HP recommends that this sum not exceed 200.
Specifies the suggested number of MXCS servers that each service starts
up when the data source is first started up. Initial
The default is 0. The values range from 0 to 32767. This value cannot
exceed the maximum server value.
Specifies the priority assigned to a process started for this data source.
The values range from 1 to 199. Initial Process Priority
Specifies the priority of the MXOAS process when the servers are created. System Default
Specifies the processing nodes (CPUs) you want to use for this data source. CPU Order CPU Utilization
Enter a list of CPU numbers, separated by commas. For example:
1,2,4,5,15.
Specifies that the SQL/MX software determines the CPU utilization
automatically. System Default
Specifies the statistics about individual SQL statements. SQL Statement Statement Statistics
Specifies the statistics about SQLExecute . SQLExecute
Specifies the statistics about SQLPrepare . SQLPrepare
Specifies the statistics about SQLExecDirect . SQLExecDirect
Specifies the statistics about SQLFetch . SQLFetch
See “Adding and modifying the resource management policy” (page 85) . Add Resource
Management
84 Managing MXCS objects