OnDemand User Group

Support Forums => MP Server => Topic started by: ODSA on March 03, 2024, 09:15:11 PM

Title: Updating retention for historical loads
Post by: ODSA on March 03, 2024, 09:15:11 PM
Hi - Our documents are stored in ICOS with different retentions ranging from 1 year to 99 years and we even have some AGs for which we have applied hold using ERM.
I need to update the retention of all the AGs to 7 years and then purge anything that is older than 7 years.
I am planning to do a direct DB update to change the retention to 7 for all the AGs.
Will this approach apply the 7 year retention to the historical load too? And when I run arsmaint for purging, will historical data older than 7 year also be deleted ? 
Title: Re: Updating retention for historical loads
Post by: Ed_Arnold on March 04, 2024, 11:37:57 AM
ODSA -

I don't know the answer to your question but...

> I am planning to do a direct DB update to change the retention to 7 for all the AGs.

...this sounds very dangerous.

Ed Arnold
Title: Re: Updating retention for historical loads
Post by: ODSA on March 04, 2024, 01:01:37 PM
Hi Ed, I mean, I have more than 2K AGs , so I was thinking to do arsxml update.
Your recommendation would be to do it from Admin client ?

Thanks!
Title: Re: Updating retention for historical loads
Post by: Ed_Arnold on March 05, 2024, 12:43:49 PM
I still don't know the answer to your question, but...

I was thinking to do arsxml update.

...that's fine. 

I was concerned that the intention was to use straight SQL to change table values.

Ed Arnold