MAIN

BMC Performance for DB2 SQL 12.1 and 11.2

This space contains information about the following releases of the following products or solutions:

Product or solutionVersion
SQL Performance for DB2

11.2.00

BMC Performance for DB2 SQL

12.1.00

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


Product guides

 

Product guides (PDFs) for each release that this space supports

Notices

 

Product notices (PDFs) before April 24, 2017

For more recent notices, see Latest notices.

Support information

 

Supported versions and how to contact Support.


Additional resources

 

BMC forums or sites with related information



Was this page helpful? Yes No Submitting... Thank you

Comments