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.

 

Challenge

The Db2 Housekeeping Challenge

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.

et|icon_check_alt|

Capture, Automate and Optimize Utility Execution Jobs

et|icon_check_alt|

Save Resource by Executing Utilities Only When Needed

et|icon_check_alt|

Non-DBAs Can Submit Requests for Utility Runs

et|icon_check_alt|

Improve DBA productivity

et|icon_check_alt|

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…

Yaron Zehavi

Head of Database and Software Engineering, Discount Bank

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…

Shay Miller

Senior DBA, First International Bank

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…

Ofer Kritchman

Director of System Software, Isracard

et|icon_pin|

North America

15 Constitution Dr, Suite 100 Bedford, NH 03110

et|icon_clock|

Hours

Mo-Fr: 8:30am - 5pm (ET)

et|icon_phone|

Call Us

(603) 458-5508 

et|icon_pin|

Israel

Hahilazon 3
Ramat Gan 5252267
Israel

et|icon_clock|

Hours

Su-Th: 8:30am - 5pm (GMT+3)

et|icon_phone|

Call Us

+972-3-5763100
et|icon_pin|

North America

15 Constitution Dr, Suite 100 Bedford, NH 03110

et|icon_clock|

Hours

Mo-Fr: 8:30am - 5pm (ET)

et|icon_phone|

Call Us

(603) 458-5508 

et|icon_pin|

Israel

Hahilazon 3
Ramat Gan 5252267
Israel

et|icon_clock|

Hours

Su-Th: 8:30am - 5pm (GMT+3)

et|icon_phone|

Call Us

+972-3-5763100
b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-bar-chart||Bar Chart

CICS Performance

ICPU

b3lineicon|b3icon-books||Books

Virtual Tape

VTFM-NewGen

b3lineicon|b3icon-board-char||Board Char

z/OS Productivity

DP Technician

PDS Monitor

b3lineicon|b3icon-line-chart||Line Chart

Oracle Accelerator

QuickSelect Oracle

b3lineicon|b3icon-checklist||Checklist

Reference Data

DPT

b3lineicon|b3icon-paper-plane||Paper Plane

Linux on Z Productivity

Wave for IBM Z

b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-bar-chart||Bar Chart

CICS Performance

ICPU

b3lineicon|b3icon-books||Books

Virtual Tape

VTFM-NewGen

b3lineicon|b3icon-line-chart||Line Chart

Oracle Accelerator

QuickSelect Oracle

b3lineicon|b3icon-checklist||Checklist

Reference Data

DPT

b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-bar-chart||Bar Chart

CICS Performance

ICPU

b3lineicon|b3icon-books||Books

Virtual Tape

VTFM-NewGen

b3lineicon|b3icon-line-chart||Line Chart

Oracle Accelerator

QuickSelect Oracle

b3lineicon|b3icon-line-chart||Line Chart

Oracle Accelerator

QuickSelect Oracle

b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-bar-chart||Bar Chart

CICS Performance

ICPU

b3lineicon|b3icon-books||Books

Virtual Tape

VTFM-NewGen

b3lineicon|b3icon-line-chart||Line Chart

Oracle Accelerator

QuickSelect Oracle

b3lineicon|b3icon-checklist||Checklist

Reference Data

DPT

b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-bar-chart||Bar Chart

CICS Performance

ICPU

b3lineicon|b3icon-books||Books

Virtual Tape

VTFM-NewGen

b3lineicon|b3icon-checklist||Checklist

Reference Data

DPT

b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-bar-chart||Bar Chart

CICS Performance

ICPU

b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-bar-chart||Bar Chart

CICS Performance

ICPU

b3lineicon|b3icon-books||Books

Virtual Tape

VTFM-NewGen

b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-bar-chart||Bar Chart

CICS Performance

ICPU

b3lineicon|b3icon-books||Books

Virtual Tape

VTFM-NewGen

b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-bar-chart||Bar Chart

CICS Performance

ICPU

b3lineicon|b3icon-books||Books

Virtual Tape

VTFM-NewGen

b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-bar-chart||Bar Chart

CICS Performance

ICPU

b3lineicon|b3icon-books||Books

Virtual Tape

VTFM-NewGen

b3lineicon|b3icon-line-chart||Line Chart

Oracle Accelerator

QuickSelect Oracle

b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-bar-chart||Bar Chart

CICS Performance

ICPU

b3lineicon|b3icon-books||Books

Virtual Tape

VTFM-NewGen

b3lineicon|b3icon-line-chart||Line Chart

Oracle Accelerator

QuickSelect Oracle

b3lineicon|b3icon-checklist||Checklist

Reference Data

DPT

b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-bar-chart||Bar Chart

CICS Performance

ICPU

b3lineicon|b3icon-books||Books

Virtual Tape

VTFM-NewGen

b3lineicon|b3icon-line-chart||Line Chart

Oracle Accelerator

QuickSelect Oracle

b3lineicon|b3icon-checklist||Checklist

Reference Data

DPT

b3lineicon|b3icon-atom||Atom

Db2 Solutions

Total Utility Control

QuickSelect for Db2

Policy-1

b3lineicon|b3icon-bar-chart||Bar Chart

CICS Performance

ICPU

b3lineicon|b3icon-books||Books

Virtual Tape

VTFM-NewGen

b3lineicon|b3icon-line-chart||Line Chart

Oracle Accelerator

QuickSelect Oracle

b3lineicon|b3icon-checklist||Checklist

Reference Data

DPT