6 Tips to Maintain your Cognos Content Store Database

Is the size of your Cognos Content Store database growing and you have no idea why?
There may be several reasons for this, however it is difficult to pinpoint the cause without the proper tool that helps you investigate deeper.

The content store database contains data that the IBM Cognos BI product needs to operate.

 

CognosContentStoreDatabase2

There is a difference between the size of the database and size of the active data. It is entirely possible that the Cognos application deals only with a fraction of the data stored in the content store database.

Cognos comes with free utility tools, which can be used to report the size and the count of all objects in the Content Store database. It allows you to find out why your content store is growing and identify objects that could possibly be deleted.

 

Pic 1

Content Store House keeping

Regular content store maintenance ensures your Cognos system is up and running at optimum capacities.
1. Saved Report Outputs

Saved report outputs are stored in the content store database, therefore you should only keep the lowest number of versions that still meets user requirements. This is possible by modifying the Report output versions settings in a report’s properties.

pic2

The “Content Removal” option in Cognos administration can also be used to remove the output versions for the reports in the “Public” folder or “My Folder”.

 

Pic3

2. Delete unused Exports from Content Administration

Entries are created in the Content Store database to facilitate faster executions of the Export in future. Deleting entries from the Content Administration portal will not delete the entries from the Cognos installation\Deployment folder.

 

pic4

3. IBM Cognos Content Archival

Storing archived content in your external repository provides you with the ability to adhere to regulatory compliance requirements, and can enhance the scalability and performance of IBM Cognos products by reducing the size of content in the content store.

4. Consistency Checks

Run Content Maintenance Consistency Checks through Content Administration to find and fix inconsistencies within the content store, or between the content store and external namespaces.

 

Pic5

5. Cognos Audit

Cognos Audit functionality helps in identifying how many reports are really being used by the business and how often they are used. The default Cognos Audit package contains a set of reports to help you gauge some of your usage statistics.

Monitoring the Audit reports should be part of regular housekeeping activities to identify the reports that are not being used. Once approved by the business, unused reports can either be archived or removed from the system.

6. Contents In Users My Folders

As businesses expand, more and more users and analysts do ad-hoc reporting and save their report versions in “My Folders”. With time, these reports can grow in number and add to the size of Content store database. Most of the users create one-time reports, but never delete them from their folders. Administrators can use CM Size tool to identify the number and size of reports in the “My Folder” of users.

A few simple steps can help ensure that Cognos Server runs with maximum efficiency. Get in touch with the Tridant team to learn more about Content store maintenance.
Share on ...

Kanul Wadhwa

Principal Consultant

Kanul.Wadhwa@tridant.com.au

1300 737 141

View more articles by Kanul Wadhwa

Leave a comment