TUC, Total Utility Control, automates the generation and execution of DB2 utilities and allows you to handle your DB2 maintenance efficiently. TUC allows you to cut the cost of backups, REORG and statistics collection by using Real Time Statistics. It helps saving resources and cutting down expensive maintenance tasks while ensuring full recoverability and availability. TUC improves the DBA productivity and allows easy automation of repeatable tasks. You can minimize the damage of availability loss by ensuring fast recovery. Efficient database maintenance also improves the overall system performance by increasing capacity. TUC is the ultimate product to automate the DB2 maintenance procedures by providing dynamic services to match your needs and demands.
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.