CDB/Real-Time Utility Manager
CDB/Real-Time Utility Manager is a DB2 facility designed to integrate DB2 Real-Time Statistics with all DB2 Utilities. CDB/Real-Time Utility Manager (CDB/RT-MAN) provides an up-to-the-second analysis of objects characteristics to facilitate database maintenance and ease the burden on DBAs. CDB/RT-MAN uses CDB Software technology and automation capabilities to streamline DB2 database maintenance and make real-time intelligent decisions on database administration.
CDB/RT-MAN works with all existing DB2 utilities so that existing procedures do not have to be changed, only improved. CDB/Real-Time Utility Manager monitors your database and provides maintenance for only objects that are in need, eliminating unecessary utility runs and reducing CPU costs and strains on batch windows.
By utilizing DB2 Real-Time Statistics, the need for DB2 Runstats for utility purposes is eliminated further reducing CPU costs and time constraints.
Two Execution Methods JCL Generation
CDB/Real-Time Utility Manager can generate utility JCL for all existing DB2 utilities, based on user defined thresholds for each DB2 object. Real-Time analysis is run in existing utility jobs so no additional processes need to be set up or run. CDB/RT-MAN automatically eliminates objects that are not in need of maintenance.
Through simple changes to existing JCL, CDB’s robust wildcarding capability can be utilized to handle newly created or dropped objects and to group objects into applications for easier database maintenance.
CDB/Real-Time Utilty Manager can be integrated into job schedulers for dynamic execution of any necessary DB2 utilities.
Real-Time Execution
In addition to all of the benefits of executing CDB/RT-MAN in JCL generation mode, CDB/RT-MAN can automatically execute utilities as they are determined to need maintenance.
A hybrid method can be employed to automatically execute higher priority objects while scheduling lower priority objects for later execution.
Flexible Criteria
CDB/Real-Time Utility Manager uses DB2 Real-Time Statistics for analysis and real-time decision making on DB2 objects. CDB/RT-MAN gives the user the complete flexibility to set criteria for an entire environment, different criteria by application, object by object, or any combination.
While most objects may follow established DB2 criteria, CDB/RT-MAN provides the flexibility to use different criteria for an individual object or group of objects. Different criteria can be dynamically used for analysis based on day of week, subsystem, userid, or many other possibilities.
Index Processing
Generally speaking Indexes are not reorged often enough while tablespaces are reorganized too often. CDB/Real-Time Utility Manager will automatically invoke tablespace reorgs only when necessary while checking the indexes for separate execution. CDB/RT-MAN can check the indexes of an object for reorganization when it is determined that the tablespace does not need to be reorganized. CDB/RT-MAN eliminates the need for a separate REORG INDEX job or extra index supervision.
Exception Criteria
Before any of the Real-Time Statistics are checked, CDB/Real-Time Utility Manager will check if objects have specified exceptions to force or prevent utility execution. Exceptions can be set in all cases for an object or group of objects or even for a specified day of week, date, date range, etc. This can be used to automatically prevent objects from being maintained during your applicaton implementations, or alternatively, force them after some such implementation.
In many environments, certain objects should not be updated by Runstats. CDB/RT-MAN accepts these restrictions and prevents execution against these objects.
WHERE CLAUSE Criteria
While DB2 Real-Time Statistics provides very useful object information, utility processing may be dependent on system information. For the ultimate flexibility, CDB offers additional WHERE clause criteria where many custom criteria can be specified. Custom criteria including job name, subsystem id, utility id, and dozens of others can be used to fine tune when utilities are run.
Utility Information
CDB/RT-MAN can generate utility history tables and trending information to provide additional information to the DBAs to help maintain an optimal DB2 environment.
Support for All Utilities
CDB/Real-Time Utility Manager supports all existing DB2 utility suites from all vendors. When used in conjunction with the CDB/Auto-Utilities you take advantage of CDB’s legendary performance and ease of use, plus tight integration with the CDB/Auto-Utilities’ Automation and scheduling facilities.
CDB/RT-MAN seamlessly integrates with the CDB/Auto-Utilities to provide fully automated DB2 maintenance at the fastest possible speeds on the largest possible objects.
Click to download pdf of this product
© Copyright CDB Software, Inc. All rights reserved. CDB/, CDB product names and the CDB logo are trademarks or registered trademarks of CDB Software, Inc. DB2 and z/OS are registered trademarks of International Business Machines Corporation. The IBM logo and the Business Partner emblem are trademarks of International Business Machines Corporation in the United States, other countries, or both.
- PRESS
- BECOMING A PARTNER
- SUCCESS STORIES
- UNIQUE TECHNOLOGIES
- WHY CDB?
- VALUE-BASED PRICING
CDB Software:The Industry's Leading Authority on z/Series DB2 Data Management
CDB Software is a leading authority on z/Series DB2 environments
and how they can be optimized to meet the changing demands of business. From the
critical every-day processes of database performance and protection to the
implementation of new requirements for security and compliance, CDB Software is
the visionary leader for enterprise DB2 environments that want both flexibility
and control.
For more information or to schedule a briefing with a CDB
expert, contact
CDB Press and Analyst Relations
.
Press Releases |
White Papers &Articles
|
Press Contacts
|
About CDB
Partner with the DB2 z/Series Expert: CDB Software
CDB Software is an industry authority on z/Series DB2 environments and how businesses can continue to leverage their deep DB2 enterprise investments for the future. Together, with CDB Software, you can help your customers continue to make the most of their complete database enterprise.
The CDB Software Partner Program
CDB Software focuses on providing the industry’s leading data management solutions for DB2 on z/OS. This enables us to offer our customers the fastest, most efficient processing techniques that will leverage their deep DB2 enterprise investments both today and into the future.
Become a Partner |
Meet Our Partners
Customer Success Stories
CDB Software focuses on providing the industry’s leading data management solutions for DB2 on z/OS. We are 100 percent focused on the needs of enterprise DB2 environments. This focus enables us to perfect advanced processing techniques that take DB2 performance and availability to new levels sot that customers can discover more from their DB2 enterprise and support their changing business needs.
Our solutions are flexible to meet any businesses needs. CDB Software delivers easy-to-use intelligent automation so that customers themselves can remain flexible as they scale to respond to changing business demands.
Read the Successes >>>
Unique Technology
CDB is 100% focused on the needs of enterprise DB2 z/OS environments. As a recognized expert in DB2 on the mainframe, CDB has spent decades perfecting advanced processing techniques that take DB2 performance and availability to new levels so that you can discover more from your DB2 enterprise and support your changing business needs.
The CDB solutions deliver easy-to-use intelligent automation so that you can remain flexible as you scale to respond to changing business demands. Each CDB product has automation built in so there is no longer a need for "wrappers" such as JCL generators or database analyzers to attempt to improve products. All CDB products can make dynamic decisions on the fly as they process DB2 objects. There is never any setup and never any cleanup for CDB products.
Learn more about the CBD Software Intelligent Data Management Suite >>>
Optimize the Investment in Your Current DB2 z/Series Infrastructure and Resources.
Today’s need for business agility is complicated by growing volumes of data. Balancing these two conflicting requirements has become a significant I.T. challenge.
The CDB Software Advantage.
The solution? You need products that can help your I.T. team more easily administer your DB2 enterprise while reliably allowing you to meet and exceed the service levels of your critical business applications. You need Intelligent Data Management solutions from CDB Software.
For the Executive | For the I.T Department
CDB Value Based Pricing
Value-driven pricing is familiar to many Information Technology users today. It simply means that the fees you pay for a software product have a direct relationship to the value you derive from its use.
As a supplier of DB2 utilities and other data management products, our customers find that the value our products offer relates directly to the amount of data we help them manage. CDB’s Value pricing is therefore based on the amount of data managed by CDB’s products.
Request Information >>>