DB2 for z/OS Toolkits for SAP ERP Applications

This toolkit includes DB2 Automation Tool for z/OS, which advances the goal of enterprise autonomic computing and offers enhancements to ERP environments by providing capabilities such as automating the execution of COPY, REORG and MODIFY to provide better management of system resources.

• Use of your definitions of exception criteria for the execution of utilities against an object or group of objects. Once this definition is done, it is used each time DB2 Automation Tool checks to determine if a utility needs to be executed.
• Addition or deletion of objects from processing, once profiles are set up, thus saving time in manual procedures, avoiding job creation language (JCL) errors, and adding to your arsenal of autonomic resources.
• LOAD balancing, supported in a variety of ways to give you more control over system resources.
• An exit that you can use to make smarter decisions when a utility needs to be executed.

This toolkit includes Tivoli OMEGAMON XE for DB2 Performance Expert and DB2 Query Monitor, designed to help keep DB2 running at peak levels even under heavy demand.
OMEGAMON XE for DB2 Performance Expert builds on IBM’s expertise in autonomic computing by providing recommendations for system tuning, helping you to optimize performance.

• A complete data-sharing view. Using only the monitoring tool included with SAP, a data-sharing view is only available for Thread Activity and Cached Statements.
• Richer object location simulation through DB2 Buffer Pool Analyzer, since simulation is not restricted to SAP statistics.
• Optimizes system resources by providing query parallelism support and flexibility on how performance data is stored to reduce workload on the SAP ERP system

DB2 Query Monitor provides autonomic capabilities such as proactive event notification and knowledge-based analysis of your SQL queries. In a SAP environment, DB2 Query Monitor captures alerts and shows performance data from multiple subsystems, helping DBAs to make better decisions and customize and tune SQL workloads to improve performance.

• Reports on all SQL statements, not just the first occurrence and identifies objects accessed for each SQL statement executed.
• Statement-level alerts for SQL statements that exceed specified performance thresholds and captures comprehensive statistics for SQL statements which trigger alerts.
• Enablement for viewing alerts and performance data from multiple subsystems on multiple LPARs.

This toolkit includes DB2 Administration Tool and DB2 Object Comparison Tool, which work together to form a function-rich object management solution, providing quality assurance in an SAP ERP environment by comparing objects in SAP ERP database objects before they are transported from test to production.

DB2 Administration Tool reduces the complexity of managing and executing SAP-initiated database changes, which enables DBAs to make faster and more accurate decisions and provides important features for the administration of SAP systems. This tool provides easy, fast navigation of a DB2 catalog, allowing you to issue DB2 commands, execute utilities and examine schema structures.

DB2 Object Comparison Tool promotes quality assurance and database object integrity when objects are transported from test to production environments. This tool also helps to identify potential risks or long-running changes.

• Reduction of the time required to verify that changes are propagated to each SAP instance. While there are seldom ad hoc changes, when SAP does change or sends instructions to change the structures, these changes (including testing) will sometimes take a long time to accomplish.
• Alerts for your DBA of any user defined objects, usually indexes, which will be affected by applying the change.

Hardware requirements
The Toolkits will operate on any hardware configuration that supports the required versions of DB2 and the applicable SAP ERP solution software.

Software requirements:
These Toolkits are available for SAP ERP solution environments only and are offered exclusively to customers who have a System z machine dedicated to the SAP ERP environment.

SAP customers who do not have a System z machine dedicated to SAP can benefit from the same capabilities the Toolkits offer by utilizing the individual DB2 tools that comprise the toolkits.
The toolkits require DB2 Version 8 or later.

• DB2 V8 (5625-DB2)
• DB2 9 (5635-DB2)
• DB2 10 (5605-DB2)

And either

• z/OS V1.6 (5694-A01), or later
• z/OS.e V1.6 (5655-G52), or later

When ordering DB2 Toolkits for z/OS the SAP Editions, please refer to the following program numbers:
DB2 Automation Toolkit for z/OS the SAP Edition: 5655-W74
DB2 Performance Toolkit for z/OS the SAP Edition: 5697-M32
DB2 Administration Toolkit for z/OS the SAP Edition: 5697-L30