Keep your DB2 environment optimized with Next Generation Technology (NGT)
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 11, a software solution that provides an array of database maintenance tools to help you:
- Perform reorganizations faster, with fewer resources and zero downtime.
- Determine precisely when a reorganization of your tables or indexes is required.
- Ensure that reorganizations are only performed where they will actually make a difference.
- 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.
Related topics: Mainframe Solutions, Mainframe MLC Cost Management, Data Management for DB2® on z/OS®
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.
Cut costs, and headaches
- Reduce costs by eliminating unnecessary reorganizations with no JCL generation ever.
- Scale your reorganization tasks based on the resources you have available.
- Eliminate outages with online reorganization and faster no sort processing.
- Pair this solution with Performance for DB2 SQL to maximize performance capacity and efficiency.
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 Stats
BMC 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
-
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 Reorg for DB2®
BMC 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
-
Snapshot Upgrade Feature
Working in concert with a variety of other BMC utilities, the Snapshot Upgrade Feature provides for near-continuous availability during many database processes. By exploiting the hardware capabilities of intelligent storage devices, the Snapshot Upgrade Feature allows you to create data-consistent copies instantaneously, with little to no outages. These point-in-time snapshot copies can be used to enhance recovery, unload, and reorg tasks.
This product is available as a part of the following offerings: Object Administration for DB2®, High Speed Utilities for DB2®, Recovery for DB2®, Performance for DB2® Databases