Skip to main content

Software > Information Management > IBM DB2 and IMS Tools >

IBM DB2 Toolkits the SAP Editions


Information Management software
Technical Detail

IBM DB2 Performance Toolkit for z/OS the SAP Edition

IBM DB2 Performance Toolkit for z/OS the SAP Edition (5697-M32) is comprised of Tivoli OMEGAMON XE for DB2 Performance Expert and DB2 Query Monitor.


Tivoli OMEGAMON XE for DB2 Performance Expert for z/OS
  • Provides recommendations for system tuning to gain optimum throughput
  • Optimizes your time by providing timely and relevant statistics to help you make better decisions and recommend actions to tune performance
  • Provides Rules-of-Thumb recommendations for tuning performance
  • Gives you a snapshot history on statistics, accounting and long term history in Performance WareHouse
  • 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 for z/OS
  • Provides autonomic capabilities such as proactive event notification and knowledge-based analysis of your SQL queries
  • Helps maintain a more efficient DB2 environment and, in an SAP ERP environment, captures alerts and shows performance data from multiple sub-systems
  • Enables you to customize and tune your SQL workload to improve performance
  • Identifies resource-intensive SLQ that needs to be tuned
  • Provides reports on all SQL statements not just the first occurrence
  • Identifies objects accessed for each SQL statement executed
  • Provides statement-level alerts for SQL statements that exceed specificed performance thresholds
  • Captures comprehensive statistics for SQL statements which trigger alerts

Related Toolkits
IBM DB2 Automation Toolkit for z/OS the SAP Edition (5697-J31)
IBM DB2 Administration Toolkit for z/OS the SAP Edition (5697-J30)

System Requirements

Hardware requirements:
DB2 Performance Toolkit for z/OS the SAP Edition, V2.1 (5697-M32) will operate on any hardware configuration that supports the required versions of DB2 and the applicable SAP ERP solution software.

Software requirements:
IBM DB2 Performance Toolkit for z/OS the SAP Edition is available only for SAP ERP solution environments.

This Toolkit is 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 Toolkit offers by utilizing the individual DB2 tools that comprise the toolkit. Please refer to the terms and conditions section of the announcement letter for further information.

  • DB2 Performance Toolkit for z/OS the SAP Edition, V2.1 (5697-M32) is designed to operate with the following DB2 versions:
    • DB2 V7 (5675-DB2)
    • DB2 V8 (5625-DB2)
    • DB2 V9 (5635-DB2)*
      *Refer to the DB2 V9 Software Announcement 206-098 (RFA43148) dated May 2, 2006 for more information or talk to your IBM representative.
  • Also required is one of these:
    • z/OS V1.6 (5694-A01), or later
    • z/OS.e V1.6 (5655-G52), or later

Offsite link Get AdobeĀ® ReaderĀ®

Highlights

DB2 Toolkits the SAP Editions announced June 7

Presentation on DB2 Tools in ERP environment delivered at DB2 and IMS Tech Con (PDF 642KB)

White Paper--Value Proposition for SAP ERP Apps...


Technical details

Fact Sheet (131KB)


Publications

Redbook: SAP applications exploit features of DB2 UDB

Library