CA OnlineReorg was designed to reorganize DB2 tables online, ensuring continuous availability for applications. It allowed administrators to reorganize tables, indexes, and table spaces without requiring exclusive access, minimizing downtime. The product used configuration files to define reorganization parameters, including table selection criteria and resource allocation.
The architecture likely involved components for parsing configuration files, interacting with the DB2 subsystem, and managing the reorganization process. These components communicated through internal APIs and DB2 interfaces. The product likely used DB2's storage mechanisms for managing reorganized data.
Administration involved configuring reorganization parameters, scheduling jobs, and monitoring progress through a command-line interface (CLI) or batch processing system. Security features likely included authentication and authorization mechanisms, with access control managed through role-based access control (RBAC). Audit logging capabilities tracked reorganization activities for compliance.
CA OnlineReorg is no longer supported and its functionality has been merged into CA Rapid Reorg. Organizations should migrate to CA Rapid Reorg or consider alternatives such as IBM Db2 Online Reorganization, BMC AMI Reorg, Precisely Syncsort Reorg, or Rocket MainView Reorg. These alternatives offer similar online reorganization capabilities, ensuring minimal disruption to business operations.