DB2 maintenance tasks include backup, reorg and statistics collection. TUC automates the generation and triggering of maintenance jobs. Real Time Statistics and thresholds are used to trigger utilities only when needed. TUC identifies any new object and refreshes the maintenance jobs automatically. Customization options allows the administrator to easily control utilities, objects and resources.

Grouping Objects

DB2 objects are grouped in profiles for uniform processing. Utility statements and jobs are generated for all objects in scope. Generic notations can be used to include objects in a profile. Utility statements are refreshed automatically whenever an object is dropped or a new object is created. Skeletons are used to control how a statement should look like. Global and local utility options can be assigned for each profile. Profiles are created automatically for any newly created database. To balance the workload profiles can be processed  by multiple parallel jobs.

Triggering Execution

DB2 collects Real Time Statistics that can be used to identify the rate of changes since the last COPY or REORG. TUC allows you to define rules to qualify objects for utility execution based on Real Time Statistics and catalog tables. Utility jobs can be automatically triggered and handed over to a scheduler for immediate execution. Only objects selected by the rules are processed. Objects are processed by priority and can be excluded. Mangement of incremental copies allows triggering full copies only when needed.

Automating Utilities

TUC automates all the actions required for utility execution including resizing objects, creating mapping tables and exception tables, rebinding dependent packages or adjusting identity columns restart values. Discard conditions can be predefined for automated purging of old data. Unload and discard datasets are recorded in a repository that allows automated reload or recall.

Summary

TUC is the ultimate product to automate the DB2 maintenance procedures by providing dynamic services to match your needs and demands. Take total control of utilities - Use Total Utility Control.