Functions of DEDB Tuning Aid

DEDB Tuning Aid facilitates multiple iterations of the database tuning process, thereby allowing you to select physical database attributes that meet performance and space utilization requirements.

Any or all of the following database specifications can be changed and evaluated with this program:

• Randomizing module
• UOW parameter values
• ROOT parameter values
• Number of database areas
• CI sizes.

DEDB Tuning Aid uses data previously extracted by the DEDB Pointer Checker using TYPRUN=MODEL. Both programs use the FABADA5 report generation module. This significantly simplifies database tuning evaluation and comparison.

DEDB Tuning Aid provides a comprehensive tuning facility for managing databases and tuning performance. It can help you accomplish the following tasks:

• Select database parameters and attributes with greater precision
• Identify and select physical database attributes that meet performance and space utilization requirements (that is, optimal values for the ROOT and UOW parameters)
• Simplify evaluation and selection of suitable randomizing routines
• Reduce maintenance frequency and costs
• Eliminate database maintenance required when a database, after an unload/reload, does not meet performance and/or space utilization expectations
• Evaluate whether tuning helps or hinders online performance
• Select optimal normal buffer allocation (NBA) for database reloading.