DB2 tuning wizards usage

DB2 tuning wizards are designed to help you cope with today’s complex systems and time pressures, turning data overload into usable knowledge about your DB2 systems. Wizards take advantage of the power of windows mode without requiring that you be an expert in all its usage techniques.

Each wizard is a set of views that lead you through all of the related information about a specific area of DB2 performance, providing critical DB2 tuning help and recommendations at just the point where they are needed. It presents the critical data in context with quick access to further details if needed.

Dynamic decision panels provide a consistent approach. Questions show the diagnostic paths, identifying what each path shows and why they could be important. Key indicators on the decision panels show whether a path is worth following, based on relevant current and long-term measurements.

Key indicators on the decision panels are the sign posts to help you decide which paths to follow to identify and solve problems. The measurements have defined thresholds that highlight problems as appropriate. View customization allows each user to modify these thresholds as needed. Often, you can immediately determine whether a path is worth following, avoiding false trails and time-consuming analysis.

The following figure shows an example of a decision panel. It is the start point of the Lock Analysis Wizard.

You can use a tuning wizard anytime without a long learning (or relearning) curve. Help is available on each of the decision points, in addition to the standard field Help. These Help panels include navigation tips as well as DB2 tuning information.

The list of wizards is expected to expand over time. The tuning wizards are accessed from the DB2 Tuning Wizard Menu, EZDWIZ, see the following figure: