Reduce Content Store Size

[LDJB81]

Hi all,

I have upgraded a client from 8.4 to 10.2.1 this week. The content store (Oracle 11g) was 20GB and some of this was due to report saved outputs that have been kept for audit purposes. To remove alot of these outptuts, I have made use of the Content Archival/Retention Rules administration tasks which has worked ok. Even though I have now have 4GB of saved outputs on the server which have been removed from the content store, the database is still the same size. Do I need to run a stored procedure to reduce the size?

Another thing which I have noticed is the archival process didn't work for reports where the default action is "View most recent report". Is this a bug?

Thanks
Lloyd

[Grim]

Running Database and Index Cleanup Scripts
http://pic.dhe.ibm.com/infocenter/cbi/v10r2m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.inst_cr_winux.10.2.1.1.doc%2Ft_rundatabasecleanupscripts.html&path%3D0_19_23_4_0

<cognos>\configuration\schemas\content\oracle\dbClean_oracle.sql
<cognos>\configuration\schemas\content\oracle\dbCleanRows_oracle.sql

[LDJB81]

Cheers Grim :)

[Grim]

 ;D