The cost that results from downtime due to an unscheduled reorganization of an IMS database is very expensive. Since IMS powers many important applications requiring fast, highly available access to data, any outages cost companies dearly. For this reason, IMS DBAs have always spent significant amounts of time monitoring, analyzing, and circumventing space and performance issues that could cause an outage. In addition, planned database outages that use significant computing resources are scheduled on a periodic basis to permit reorganizations to be performed—whether they are needed or not—to prevent the possibility of an unscheduled outage. The time, knowledge, and experience necessary to perform these maintenance functions on a regular basis are extensive, and many of these DBAs will be retiring in the not too distant future. A new product that increases DBA productivity, improves the utilization of system resources, and expands data availability offers a solution to these issues.

MAXM Database Advisor for IMS from BMC Software proactively and automatically manages full-function (including HALDB) and Fast Path database environments within and across IMS and z/OS Sysplexes. Through the use of a set of processes, MAXM Database Advisor for IMS automatically configures itself, gathers data when the state of a database has changed or an event has occurred, analyzes the gathered data, and provides recommendations that will help keep IMS databases constantly performing at their best. The automation provided to collect and analyze the vast amounts of performance data will save DBAs significant amounts of time and permit them to spend more effort on database design, strategic planning, and other important efforts. What also will tremendously help DBAs is the product’s ability to predict problems before they occur.

The capability that makes MAXM Database Advisor for IMS unique is its ability to predict threshold-exceeding space and database performance problems. Data collected by MAXM Database Advisor for IMS is automatically analyzed each time any new information is collected about the databases being monitored. MAXM Database Advisor for IMS uses the data to proactively predict when thresholds will be reached, and reports the information for display in an Exception List. Thresholds that have already been met or exceeded also are reported. By being able to predict problems, DBAs can proactively schedule planned actions that minimize outages and reduce or eliminate the need to perform reorganizations not needed.

Taking action on the items reported as exceptions is simplified through a list of solutions. Once the Exception List has been generated, MAXM Database Advisor for IMS presents all the solutions available and recommends the best solution for each exception. Each recommended solution is based on the utilities installed and the DBA’s pre-defined goals given to MAXM Database Advisor for IMS based on the relative importance of performance, availability, and space usage. The ability to generate, display JCL, and submit the job to correct each exception also is incorporated to ease implementation of each chosen solution.

MAXM Database Advisor for IMS provides a new solution to managing the maintenance cycle of IMS databases that increases DBA productivity, saves system resources, and keeps IMS performance at its best. Z