Which of the following tools can be used to automate table reorganization Operations ?
-
Control Center
-
Command Center
-
Command Line Processor
-
Task Center
Task Center is the IBM DB2 tool that allows you to schedule and automate maintenance tasks including table reorganization operations. Control Center and Command Center are monitoring/management interfaces but don't handle automation. Command Line Processor requires manual execution of commands.
Task Center is correct. In DB2 (UDB), the Task Center is the scheduling tool that lets administrators define, schedule, and automate recurring administrative jobs — including running REORG/REORGCHK against tables on a timer, without manual intervention. Control Center is the general-purpose administrative GUI for browsing and managing objects, but it runs actions on demand rather than automating recurring schedules. 'Command Center' isn't a real DB2 component (distractor). The Command Line Processor (CLP) is just the interactive/batch SQL and DB2-command shell (db2 command) — it can run a REORG command once you invoke it, but it has no built-in scheduling/automation of its own.