RT table is full and there are no options to increase database size.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

If the Reports Table (RT) reaches this limit, jobs fail to insert report data, and system functionality is restored only after clearing space. When trying to run the DB Maintenance workflow, information from the RH/RT tables are not being removed.

The ucybdbre (DB Reorg) utility log may show that report reorganization is disabled:

U00032209 Reports (RH/RT): Disabled

Environment

• Product: CA Automic Workload Automation

Resolution

To resolve this issue, enable report reorganization for every client in the system to ensure space is reclaimed.

1. Log into each client (including Client 0).
2. Open the UC_UTILITY_REORG variable.
3. Locate the RH entry.
4. Set the retention period to the desired number of days (e.g., 0007 for 7 days). Keep this value as low as possible to minimize RT table growth.
5. Ensure the reorganization is set to TRUE for Reports.
6. Run the ucybdbre (DB Reorg) utility followed by the ucybdbun (DB Unload) utility to flag and remove the records.

⚠️ IMPORTANT: Always test utility settings first in a non-production environment. Take a backup of the database before running mass deletions.