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 allow 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 a table or an index is dropped or created. Skeletons are used to control how a statement should look. 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 examine Real Time Statistics and catalog statistics and qualify objects for utility execution. Utility jobs can be automatically  triggered and handed over to a scheduler to process  only the selected objects. Objects are processed by  priority and can be excluded. The management of incremental copies allows the triggering of full copies only  when needed.

Processing Requests

TUC has a unique mechanism that allows users to trigger  maintenance procedures at meaningful points in time that fit into the application’s jobs flow. Jobs can be handed  over to the scheduler as needed. This approach differs from common solutions because it takes into consideration the business requirements.

TUC allows full integration with application jobs and avoids collision between utility jobs and application processing. In addition, authorized users can indirectly request the execution of maintenance procedures without approaching the DBA team. However, the responsibility and control of the operation stays in the hands of the administrators.