Using General Properties

You must assign a unique name for the new data source. The name can be a maximum of 128 characters (any characters) without leading or trailing spaces. Leading or trailing spaces are automatically removed before the name is sent to the server. The name in lowercase, containing embedded spaces or quotes is delimited by MXDM.

Specifies that MXCS automatically starts up the initial MXCS servers for the data source when the MXCS service is started.

You must manually start up the MXCS servers for the data source when the MXCS service is in the Started state. This value is the default.

Specifies the number of minutes that an MXCS server remains idle before it stops. This timeout occurs only under the following conditions:

• The idle server is not connected to a client.

• The number of servers exceeds the number of idle servers configured for the data source.

The system default is 600 seconds. You can assign a value between 1 and 2,147,483,647.

Specifies the number of minutes that a client-server connection remains idle before the MXCS server terminates the connection.

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.

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.

Specifies the upper limit of the servers that can be operational for a service on the data source.

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.

The values range from 0 to 32767. The default is 0.

This value cannot exceed the maximum server value.

Specifies the suggested number of MXCS servers that each service starts up when the data source is first started up.

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.

Specifies the priority of the MXOAS process when the servers are created.

Specifies the processing nodes (CPUs) you want to use for this data source.

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.

Specifies the statistics about individual SQL statements.

See Adding and modifying the resource management policy.

See Adding and modifying the resource management policy.

Removes the selected resource management policy.