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.
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.
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.
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.