We are in a similar spot.
Does the data in RT table gets unloaded as part of the DB Maintenance? this table for us has been growing through out and the earliest date we have record is at the time of system install, more than 18 months.
All the DB Unload job logs indicates only deleting rows from tables MELD, RH, AH and OH.
How do we unload data from RT table? Can UC_UTILITY_REORG be updated?
Check also the value set for the no_archive_check parameter in the ini file of the ucybdbre and ucybdbun utilities. This may exclude records that have not been archived. If you do not run the archive utility, ucybdbar, no record is flagged as "archived". And with the setting no_archive_check=0, records will also not be flagged for suppression, or suppressed even if the deletion flag is set !
Thanks Alain, This morning I updated the no_archive_check=1 on both ucybdbre.ini and ucybdbun.ini and ran the JOBP.AE.MAINTENANCE
However results of running the maintenance job with the default configuration didn’t yield the result we were expecting(unload data older than 60 days) for AH, RH and RT tables. It seems like the REORG job does not flag the older records to be deleted except for MELD table.
Jobs are running with default configuration of 30 and 60 days – any data earlier than those dates should be unloaded, however the earliest data in RH, RT and AH is from june of 2017(time of our environment install).
In the UC_UTILITY_REORG variable in each client are you setting the parameters like follow :
AH => TRUE 0030 TRUE 0006
RH => TRUE 0030 TRUE 0006
MELD => TRUE 0030 0030
VERSION_CONTROL => TRUE 0030 TRUE 0005
OBJECT_AUDIT => TRUE 0030 TRUE
AH/RH => keep 30 days AND 6 versions of any statistics and reports
MELD => keep read and unread messages for 30 days
VERSION_CONTROL => keep old version of objects for 30 days AND 5 versions at least
OBJECT_AUDIT => keep audit records for 30 days and remove them ONLY if extratced and saved in csv file
If you have such setting and some jobs are running only once a year, there are records in AH/RH that can be from the las 6 executions so up to 6 years back !
There is a parameter auto_reorg in the ini file of ucybdbre and ucybdbun that is set by default to 365 to remove forcfully all records older than 365 days. You can change it if you do not want to loose records olde than 365 days to the max value you want.
Note 2 :
If you have obsolete definitions that runs last time a year ago i.e., the AH/RH associated records will stay in the DB as long as the definition is existing. That's why it is recommended to export/unload obsolete definitions as backup (you never know who is going to ask you to run them again =-) ) and remove them from the clients to cleanup the associated statistics and reports ..... Could be also interesting to generate the report or list of the available statistics of those objects for historical recording in that case (all start/end time, status, etc ....).
Sorry to be long but seems that you have some issues in some of the settings maybe if only MELD is cleared.
FYI for one RH records there is one or more RT records as RH is for Report Header (main information about the report generated) and RT is for Report Table (details of the report, in one or more 8K records usually)