What is DB2 Management Solution Pack for z/OS?

Features and functions of DB2® Management Solution Pack help satisfy the administration, performance, utilities, and autonomics tasks for your most critical DB2 for z/OS® environments and applications.

DB2 Management Solution Pack combines capabilities from a variety of products, some of which are offered in solution packs, as described here:
  • IBM® DB2 Administration Solution Pack for z/OS, V3.1 (5697-ASP)
  • IBM DB2 Performance Solution Pack for z/OS, V1.5 (5655-E74)
  • IBM DB2 Utilities Solution Pack for z/OS, V4.2 (5697-US4)
  • Autonomics Director for DB2 for z/OS, V1.6 (feature, FMID HAKP160)

DB2 Administration Solution Pack for z/OS

IBM DB2 Administration Solution Pack for z/OS, V3.1, delivers integrated object management, configuration management, and fast data cloning capabilities for DB2 for z/OS by combining the function from the following programs:

  • IBM DB2 Administration Tool for z/OS, V12.1 (5655-DT2)
  • IBM DB2 Object Comparison Tool for z/OS, V12.1 (5655-DC2)
  • IBM DB2 Table Editor for z/OS, V4.5 (5697-G65)
  • IBM DB2 Cloning Tool for z/OS, V3.2 (5655-N15)
  • IBM DB2 Configuration Manager for z/OS, V4.1.2 feature

In addition, new RESTful APIs have been instrumented in the DB2 Administration Tool and DB2 Object Comparison Tool to facilitate the implementation for an automated process for rapid deployment of applications and database schema changes using DB2 for z/OS.

DB2 Performance Solution Pack for z/OS

DB2 Performance Solution Pack for z/OS, V1.5, delivers integrated performance management for DB2 for z/OS by combining function from the following IBM products:

  • IBM Tivoli® OMEGAMON® XE for DB2 Performance Monitor for z/OS, V5.4 (5655-W37)
  • IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42)
  • IBM DB2 SQL Performance Analyzer for z/OS, V5.1 (5655-W51)
  • IBM DB2 Query Workload Tuner for z/OS, V5.2 (5655-AB4)

DB2 Utilities Solution Pack for z/OS

DB2 Utilities Solution Pack for z/OS, V4.2, combines advanced DB2 Tools that help you to execute and manage DB2 utilities more efficiently and to optimize performance and resource utilization. Enhancements in V4.2 of DB2 Utilities Solution Pack for z/OS include:

  • Additional features and functions to reduce downtime costs by providing effective backup and recovery automation
  • Improvements to sort processing for variable-length records, which improve performance characteristics (both elapsed time and CPU consumption) during utility processing
  • Authorization to run DB2 for z/OS utilities in all currently supported DB2 for z/OS environments

In addition to providing authorization to run DB2 for z/OS utilities in any currently supported version of DB2 for z/OS, DB2 Utilities Solution Pack for z/OS, V4.2, combines capabilities from the following products:

  • IBM DB2 Extended Utilities Suite for z/OS, V2.2 (5655-EU2)
  • IBM DB2 Automation Tool for z/OS, V4.3 (5655-E37)
  • IBM DB2 Recovery Expert for z/OS, V3.3 (5655-W78)
  • IBM Autonomics Director for DB2 for z/OS, V1.6 (feature, FMID HAKP160)

Autonomics Director for DB2 for z/OS

Autonomics Director for DB2 for z/OS, V1.6, provides the framework for a comprehensive DB2 autonomics environment. By using DB2 Autonomics Director and other DB2 tools that provide autonomics capabilities, you can automatically detect potential storage, organization, and performance problems, and proactively run maintenance utilities to ensure that your data remains tuned and accessible.

DB2 Autonomics Director supports both a passive or active approach to autonomics. For example:
  • In a passive autonomics environment, you can automatically gather DB2 real-time statistics and information about the results of running DB2 utilities. That data is used as input to identify potential problem situations and to recommend actions that you can take to correct problem situations. Based on your own analysis, you decide whether to follow the recommendations.
  • In an active autonomics environment, utilities are run for you automatically based on a number of factors including the priority of the job, how many tasks are already running, and how much time remains in the maintenance window.