Performance for Db2^® Databases

Datasheet: Performance for Db2 Databases

Optimize Db2 data to improve performance and increase savings

Disorganized data structures, poorly allocated storage space, unreliable capacity planning—these are the enemies of a healthy, high-performance Db2 database and drive up the cost of Db2. Keep Db2 fully optimized with BMC Performance for Db2 Databases, a software solution that provides an array of database maintenance tools.

Perform reorganizations more often with fewer resources and zero downtime
Keep your data optimized for peak application performance
Determine precisely when a reorganization of your tables or indexes is required
Gather and store usage statistics that will help you stay proactive and in control of database maintenance
Automate all of the time-consuming and error-prone processes of Db2 data management

Optimize and automate database maintenance

The key to ensuring strong, reliable database performance is to build a maintenance routine that runs like clockwork. The tools in the Performance for Db2 Databases solution will help you do precisely that, with options for monitoring and analyzing performance data, performing fully online no-sort reorganizations, allocating table and index space, and automating many other routine maintenance tasks.

Know your environment

Gather and analyze in-depth usage and performance statistics from across your Db2 environment.

Target your reorg work

Use the detailed usage statistics you collect to determine whether reorganization would be beneficial or not—that way, you can schedule the ones you need and defer the ones you don’t.

Give your Db2 resources a break

Dramatically reduce resource consumption through Next Generation Technology of no-sort online reorgs.

Automate Db2 data management

Automate the processes for Db2 data management to simplify maintenance tasks.

Make real-time decisions on processing

Use real-time statistics to determine what to process and what to skip during execution with no JCL generation ever.

Contact Sales

Products included in this solution

The Performance for Db2 Databases solution is made up of the following products, all of which are designed to reduce the resources and effort required for Db2 database maintenance.

NGT Reorg for Db2^®

Next Generation Technology Reorg for Db2 efficiently reorganizes Db2 data using a fraction of the resources required by all other Reorg processes. Through flexible built-in automation and patented advanced processing techniques, BMC NGT Reorg streamlines the Reorg process for tens of thousands of objects, eliminating the SORT, and providing full data availability to applications, while reducing overall CPU usage and Elapsed time no matter how much data is managed.

This product is available as a part of the following offerings: High Speed Utilities for DB2, Performance for DB2 Databases

NGT Utility Manager

BMC Next Generation Technology Utility Manager integrates Db2 Real-Time Statistics with all NGT utilities. BMC NGT Utility Manager provides an up-to-the-second analysis of object characteristics to facilitate database maintenance and ease the burden on DBAs. BMC NGT Utility Manager streamlines Db2 database maintenance and makes real-time intelligent decisions on database administration during utility execution with no JCL generation ever.

This product is available as a part of the following offerings: Performance for DB2 Databases

NGT Stats

Next Generation Technology Stats efficiently gathers Db2 statistics using a fraction of the resources required by all other Runstats products to give you an exceptionally clear view of your database structures. With powerful options for when and how statistics are gathered, Db2 environments gain productivity while reducing the overall cost of Runstats processing. BMC NGT Stats can tell you exactly how well your databases are performing.

This product is available as a part of the following offerings: High Speed Utilities for DB2, Performance for DB2 Databases

DASD Manager for Db2^®

Take the guesswork out of database maintenance with BMC DASD Manager for Db2. By analyzing the statistics collected by the BMCSTATS utility, DASD Manager helps you get proactive about capacity planning, and allows you to set thresholds to let you know when maintenance tasks need to be carried out. DASD Manager also allows you to automate changes to the allocation of table and index space, dramatically reducing the risk of errors.

This product is available as a part of the following offerings: Performance for DB2 Databases