BMC Performance for DB2 SQL 11.2
This space contains information about the following releases of the following products or solutions:
Product or solution | Version |
|---|---|
SQL Performance for DB2 | 11.2.00 |
BMC Performance for DB2 SQL | 11.2.00 |
SQL Explorer for DB2 | 11.2.00 |
The SQL Performance for DB2 solution enables DBAs, application developers, and system programmers to identify and correct performance problems in DB2 applications that run in IBM CICS, IMS, and OS/390 environments. This solution is the answer to the ongoing quest for optimal application efficiency. SQL Performance provides a unique set of tools that allow an application to be fine-tuned through its conception and growth, to its retirement.
The BMC Performance for DB2 SQL solution enables DBAs, application developers, and system programmers to identify and correct performance problems in DB2 applications that run in IBM CICS, IMS, and OS/390 environments. This solution is the answer to the ongoing quest for optimal application efficiency. SQL Performance provides a unique set of tools that allow an application to be fine-tuned through its conception and growth, to its retirement.
The SQL Explorer for DB2 product lets you prevent or resolve common SQL-related performance problems. You can use SQL Explorer to do the following:
- Explain SQL statements
- Compare SQL statements
- Analyze mismatched data types
- Analyze the impacts of schema changes
- Compare timestamp matches before production
- Migrate access path statistics to another subsystem
- Generate automatic DECLARE TABLE statements