We have our UIM database server being backed up at a regular schedule, however I do not see an existing job that truncates/deletes the old data. Is it advisable to truncate the old data which are backed up.
There are 3 tables which are being used at the start up of our MOM tool CA SOI namely
And it turns out that the numbers on these tables are quite overwhelming. When trying to drill down for this issue we found that there is no truncation happening in our database and I suspect that these high numbers are due to the server not being truncated which ultimately not starting up the tool. Any suggestion on this please.