Hi Bharath,
do you know what kind of information is stored in R* tables, i.e. have you run a sql query like this:
select RH_Client, RH_Type, count(1)
from RH
group by RH_Client, RH_Type
order by RH_Client, RH_Type
Also interesting to know: how many executions happen per day?
Did you ever run a health check?
What about long term statistics of R-tables: did the growth happen recently or can you see a trend in it?
regards,
Peter
Original Message:
Sent: 09-10-2020 05:42 AM
From: B Bharath Kumar Reddy
Subject: Huge number of records in RT Table - Not getting deleted by Maintenance jobs
Hi Peter,
We are performing archive/reorg/unload on Client 0 as well.
I've just ran a query and observed that there are close to 7 million records are there in the RH Table for the last 15-30 days. So, I am thinking probably all the records are valid in the RT Table as well.
Any thoughts?
------------------------------
Bharath B.
Original Message:
Sent: 09-10-2020 05:08 AM
From: Peter Grundler
Subject: Huge number of records in RT Table - Not getting deleted by Maintenance jobs
Hi Bharath,
please check the archive/reorg/unload logs for client 0 as well.
regards,
Peter
Original Message:
Sent: 09-10-2020 02:36 AM
From: B Bharath Kumar Reddy
Subject: Huge number of records in RT Table - Not getting deleted by Maintenance jobs
Hello Team,
Our RT Table records are almost 440 million at the moment and the record count is not decreasing even after running the Maintenance jobs on daily basis.
Below is the summery of job executions on an average:
Number of executions: 100K (For the last 9 months) and it's around 700k in the last 3 days due to a new release
RT Table size: Around 40 GB with 420 million records
RH Table: 15 million records.
We've modified the DB Archive & Reorg settings to keep only last 30 days statistics and We've disabled the option to keep last 30 versions and re-ran the Maintenance jobs again but there is no improvement in the record size and the records in RH table are not getting flagged to delete.
Attached are the config files and the latest logs of the Archive, reorg and unload jobs.
I've also verfied the previous questions from the community but they are of no help to our situation. :(
------------------------------
Bharath B.
------------------------------