Updating retention for historical loads

[ODSA]

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 ? 

[Ed_Arnold]

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

[ODSA]

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!

[Ed_Arnold]

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