Database tuning environment

Policy-based database monitoring and tuning is achieved by using a set of IMS Tools products.

This topic summarizes the tools and components that are used in policy-based database monitoring and tuning.

To achieve policy-based database monitoring and tuning of IMS databases, you must install and configure IMS Tools Base. You must also install and configure one of the following IMS solution packs:

  • IMS Database Solution Pack
  • IMS Database Utility Solution
  • IMS Fast Path Solution Pack

IMS Tools Base

You must install IMS Tools Base and then configure the following components of IMS Tools Base:

IMS Tools Knowledge Base
IMS Tools Knowledge Base (IMS Tools KB) functions as the server for the report repository, sensor data repository, and policy repository. IMS Tools KB provides an ISPF user interface to set up the IMS Tools KB environment and to manage repositories and reports.
Policy Services
Policy Services detects database exceptions based on user-defined policies. Policy Services provides an ISPF user interface to define and manage policies, rules, and notification lists.
Autonomics Director
Autonomics Director schedules sensor data collection and policy evaluations. A policy evaluation can detect exceptions and provide recommended user actions. Autonomics Director provides an ISPF user interface to schedule sensor data collection and policy evaluations and to view the results of policy evaluations.
Start of change

IMS Administration Foundation and Management Console

IMS Administration Foundation features of IBM® Unified Management Server for z/OS® (also referred to as IMS Administration Foundation) and IBM Management Console for IMS and Db2® for z/OS (also referred to as Management Console) display key statistics and information about database resources in an intuitive graphical web interface.

End of change

IMS Database Solution Pack or IMS Database Utility Solution

To monitor IMS full-function databases, you must install IMS Database Solution Pack or IMS Database Utility Solution. Sensor data can be collected by using the utilities and services that are provided by these solution packs.

The following tools support sensor data collection:

  • The HD Pointer Checker utility of IMS HP Pointer Checker
  • IMS HP Image Copy
  • FF Stand-alone DB Sensor
  • The Smart Reorg utility of IMS Database Reorganization Expert

These tools also generate reports that assist you in database analysis and tuning.

For information about installing and configuring IMS Database Solution Pack or IMS Database Utility Solution, see the following information:
  • IMS Database Solution Pack: Overview and Customization
  • IMS Database Utility Solution: Overview and Customization

IMS Fast Path Solution Pack

To monitor IMS DEDB databases, you must install IMS Fast Path Solution Pack. Sensor data can be collected by using the utilities and services that are provided by this solution pack.

The following functions and tools support sensor data collection:

  • Fast Path Advanced Tool functions
  • Online Pointer Checker utility and Online Expert Reorganization utility of Fast Path Online Tools
  • Online Space Management utility
  • IMS HP Image Copy
  • FP Stand-alone DB Sensor

These tools also generate reports that assist you in database analysis and tuning.

For information about installing and configuring IMS Fast Path Solution Pack, see IMS Fast Path Solution Pack: Overview and Customization.