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.
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 offering: 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 offering: Performance for Db2® Databases
-
Workbench for Db2®
BMC Workbench for Db2 provides a secure web-based graphical interface that allows developers and DBAs access to information about their Db2 environment on the fly. Workbench for Db2 supplies catalog information in an easy to use dashboard, and allows commands to be issued to any Db2 subsystem. Users can extract DDL describing object structures and potentially re-execute the DDL in other Db2 environments.
This product is available as a part of the following offerings: Object Administration for Db2®, Performance for Db2® SQL, Performance for Db2® Databases
Overcome the difficulties in managing NPIs
Maximize performance with next generation utilities
Today's data explosion makes database management critical. Hear what Forrester recommends in our featured webinar, then download the complete report:
Forrester Webinar: Transforming Data Management for Digital Business
Forrester Report: Transforming Data Management for Digital Business
