|
Business Challenge
As DB2 applications become more complex and DB2 data experiences rapid growth, DB2 applications frequently fail to meet performance goals. Pinpointing the cause of degraded application performance can be both time-consuming and difficult.
Business Need
- Identify DB2 objects accessed by a specific SQL statement
- Identify SQL that executes different queries from a single plan, program or section number
- Identify large resource-consuming or performance-constrained SQL statements
- View Host Variable values for static and dynamic SQL statements
- Enable identification of dynamic SQL statements that are affecting performance
Our Solution
BMC APPTUNE for DB2 alleviates problems caused by inefficient or run-away SQL statements. It provides the most accurate information on SQL statement performance and DB2 object performance characteristics while minimizing resources consumed in gathering information. This data can then be used to maximize SQL statement and DB2 object efficiency, thus improving application and overall system performance.
Key Features & Benefits
- Provides a user-friendly design of the complete product that is easy to learn
- Identifies the most heavily used DB2 objects quickly and easily
- Identifies resource-consuming SQL statements without running a DB2 SQL trace
- Collects DB2 consumption and performance data at the level of unique SQL text
|
|
|
Brochure
|
-
BMC Educational Services
(pdf)
-
DB2®9 for z/OS Reference Guide
(pdf)
-
BMC Mainframe Solutions
(pdf)
-
BMC Database Management for DB2
(pdf)
-
DB2 UDB Family Reference Guide Book Version 8
(pdf)
-
BMC Software & IBM: Engaged In Your Success
(pdf)
|
|
Datasheet
|
-
BMC SQL Performance Family for DB2 z/OS
(pdf)
-
APPTUNE for DB2
(pdf)
|
|
Success Story
|
-
Banco Sabadell Implements MVS with BMC Software Solutions
(pdf)
-
Ensuring Premium Data Quality and Precision at One of Switzerlands Leading Health Insurance Providers
(pdf)
|
|
White Paper
|
-
Swing into Business Service Management - Seven Strategies
(pdf)
-
DB2 UDB for z/OS: SQL Performance Tuning
(pdf)
-
DB2 Version 9 - A Perspective
(pdf)
(htm)
|
|
|
|
|
| |
|
|
|
