How to remove the report output from OCI DWH content store database
Applies to
Oncommand Insight Data Warehouse (OCI DWH) 7.3.3 and above
Description
OCI Data warehouse Content Store size
As Cognos admins know, the Content Store is the central nervous system for any Cognos instance.
Among the many things stored in this repository are report specifications, published models, and report outputs.
As the Cognos instance matures, the amount of data contained in the Content Store database can expand quite rapidly.
At a certain tipping point, Content Store bloat can adversely affect the overall performance and stability of the Cognos instance.
One best practice for getting the most out of your Cognos Instance is to keep your Content Store “lean and mean” by removing superfluous content. Report outputs are almost always among the largest consumers of space in the Content Store.