Administrative and Operational Enhancements › Automatic Tuning

Automatic Tuning

A new auto-tuning capability lets CA IDMS set the startup values for certain DC/UCF system configuration parameters based on historical information. The values are automatically adjusted over time in response to changes in workload. Auto-tuning relieves the DBA from having to monitor and adjust the parameter values manually.

The following system definition parameters are eligible for automatic tuning:

• RLE count
• RCE count
• DPE count
• SYSLOCKS

New clauses on the system generation SYSTEM statement enable or disable automatic tuning for each of these parameters.

Notes:

• To use auto-tuning, change tracking must be active for the DC/UCF system, since statistical information needed for tuning is captured in the SYSTRK files.
• New DCMT commands display and reset values used in tuning.

While the use of auto-tuning can be beneficial in many situations, it is not recommended under the following conditions:

• If a system is normally active for only short durations (less than 24 hours).
• If a parameter must be set to accommodate a rarely-executed workload.