Total Utility Control
Intelligent Db2 Utility Automation
Total Utility Control automates the generation and triggering of maintenance jobs. Real Time Statistics and thresholds are used to trigger utilities only when needed. Improve DBA productivity, optimize use of scare processing resource, and ensure the health of your Db2 objects.
Total Utility Control
Total Utility Control automates the generation and triggering of Db2 maintenance jobs. Real Time Statistics and thresholds are used to trigger utilities only when needed. Improve DBA productivity and optimize use of scare processing resource.
Database administrators use various DB2 utilities to run routine housekeeping tasks such as backups, reorgs and statistics collection. Though routine, these tasks are vital as they maintain the health of Db2 objects and ensure the efficiency and performance of the Db2 environment. With increased pressure to do more work in less time, DBAs are often unable to do the analysis required to optimize the timing and scope of utility execution. Running a REORG or RUNSTATs against objects that aren’t in need wastes resource. Fortunately, it is possible to automate the analysis required to determine when and where to run Db2 utilities, and to automate the prioritization and scheduling of utility runs.
Capture, Automate and Optimize Utility Execution Jobs
Save Resource by Executing Utilities Only When Needed
Non-DBAs Can Submit Requests for Utility Runs
Improve DBA productivity
Application Integration for Optimized Utility Execution
Solution
Total Utility Control for Intelligent Automation
Total Utility Control (TUC) provides a robust framework for the intelligent automation of Db2 z/OS utilities. TUC lets you define and automate a set of maintenance procedures, along with rules to ensure that the procedures conform to your maintenance policy. Maintenance tasks might include backing up your data, collecting statistics, REORGing your data or recovering data when needed. Each task might have different requirements and rules. Requirements and rules might differ across different applications or groups of Db2 objects. The TUC workflow allows you to set up environment options, group common objects into profiles, and set up utility job templates. Your utility statements are then generated automatically for all Db2 objects.
At execution time, policy rules and thresholds intelligently determine which utility jobs should be triggered and executed for a given object. TUC prioritizes job execution according to need and balances the utility workload by splitting profiles and running multiple jobs at the same time to process all profile objects faster.
TUC comes with a default set up of rules and procedures. These templates are easily changed and adjusted to meet your needs and accelerate implementation.
Benefits and Savings
- Captures, systematizes and executes utility management best practices.
- Provides a robust framework for the intelligent automation of Db2 utilities.
- Improves DBA productivity by automating Db2 utility execution. Frees DBAs to focus on more important tasks.
- Optimizes the use of available system resource and Db2 object health by determining which objects need to be processed and when.
Features and Capabilities
- Intelligent Statistics-Driven: utility automation for Backup, Recovery, Statistics Collection, Reorg, Archiving, and Unload and Reload of Db2 objects. Automates the generation of utility jobs and exploits schedulers to run the jobs for hands-free Db2 housekeeping.
- Execution Triggers: TUC examines Real Time Statistics and catalog statistics and based on user defined rules qualifies objects for utility execution. Utility jobs can be automatically triggered and handed over to a scheduler to process the selected objects.
- Space Management Capabilities: monitor Db2 dataset disk storage and performance, alert and notify of critical conditions, and automate corrective actions to avoid availability issues.
- Object Grouping: Profiles are used to group DB2 objects and allow these objects to be processed at the same time.
- Processing Requests: Authorized users (e.g. application team member) can indirectly request the execution of maintenance procedures from the DBA team, with responsibility and control of the operation remaining in the hands of the administrators.
- Application Integration: Allows users to trigger maintenance procedures at meaningful points in time that fit into an application’s job flow. Jobs can be handed over to the scheduler as needed.
- Management of periodical cycles: You may have different batch periodical cycles that you will need to run such as daily and monthly backup jobs. For each batch cycle you can define different symbols and a template to be used in your utility jobs.
TESTIMONIALS
What Total Utility Control Users Are Saying
When we compare the Total Utility Control with other products, it continues to come out ahead in terms of features, ease of use, cost and performance.
Read More…
Before implementing TUC, we simply took full backups for all tables. However, with TUC we learned that only 5 percent of our tables have changes. TUC helped us cut short our backup cycle from hours to as few as 20 minutes.
Read More…
The friendly and intuitive user interface provides the DBA the power to define maintenance processes and to track their progress easily and smoothly. We feel that this is a unique platform addressing all the aspects of maintenance…
Read More…
North America
15 Constitution Dr, Suite 100 Bedford, NH 03110
Hours
Mo-Fr: 8:30am - 5pm (ET)
Call Us
(603) 458-5300
Israel
Hahilazon 3
Ramat Gan 5252267
Israel
Hours
Su-Th: 8:30am - 5pm (GMT+3)
Call Us
North America
15 Constitution Dr, Suite 100 Bedford, NH 03110
Hours
Mo-Fr: 8:30am - 5pm (ET)
Call Us
(603) 458-5508
Israel
Hahilazon 3
Ramat Gan 5252267
Israel
Hours
Su-Th: 8:30am - 5pm (GMT+3)