IBM Business Analytics Diagnostics: Use Case: Content Store Database Growing Significantly Every Day

Product(s): IBM Cognos BI; Area of Interest: Infrastructure

In this particular scenario, the administrator notices that the IBM Cognos BI Content Store is growing in size significantly day after day in a way that he cannot explain.

Business Analytics Proven Practices Team, Business Analytics Proven Practices Team, IBM

Business Analytics Proven Practices Team



28 March 2012

Also available in Russian

Introduction

Purpose

This document is intended to provide a troubleshooting methodology which incorporates publicly available utilities to diagnose and resolve an issue identified within a specific use case. The use case will be presented as a scenario where an IBM Cognos Support Analyst is working with a client to diagnose and solve a particular issue.

The utilities mentioned in this document can be found at http://www.ibm.com/software/analytics/support/cognos_sdk.html.

Applicability

Although the troubleshooting approach outlined is not IBM Cognos BI version specific, some of the diagnostic utilities used are. The version of the utility to be downloaded will be specific to the IBM Cognos BI version that is experiencing the issue.


Use Case Description

In this particular scenario, the administrator notices that the IBM Cognos BI Content Store is growing in size significantly day after day in a way that he cannot explain.


Troubleshooting the Use Case

As with troubleshooting any use case, a set of basic information needs to be collected in order to further clarify the environment and the issue at hand.

The environment consists of a single server install with the following details:

  • IBM Cognos BI version: 8.4.1
  • Operating System: Windows 2003
  • Content Store Database: Microsoft SQL Server 2008r2

The support analyst asked the administrator to down load the IBM Cognos BI Content Manager Size Diagnostic‎ utility from the following URL,
http://www.ibm.com/support/docview.wss?uid=swg24021252.

NOTE: This utility is also available in most IBM Cognos BI versions under the bin/utilities/diagnostictools sub-directory of the IBM Cognos BI installation directory.

The IBM Cognos BI Content Manager Diagnostic utility reports the size and count of all objects in the Content Store database. Within specified search scope and type of objects, it returns the count, approximate size and Content Store search path of the object.

In order to look at the entire Content Store, the administrator logs in with an IBM Cognos BI System Administrators account. What they find are about 1500 reports and about 15 reports that have a large size of saved outputs in public folders.

The IBM Cognos Support Analyst tells the administrator to run this utility every day, for several days and monitor the activity.


Conclusion

What the administrator found after a few days of monitoring is that the number of reports is staying the same but the 15 reports with large report outputs are growing very significantly.

The administrator then checks on the reports from IBM Cognos Connection and finds that these are all bursted reports being sent to over 1000 users. In addition, 30 versions of the report output for each user are being saved to the Content Store. The administrator goes off to work with his colleagues to find out if the bursted reports still need to be sent to all the 1000+ users and if the number of report outputs that are saved for each user can somehow be reduced.

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Big data and analytics on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Business analytics, Information Management
ArticleID=807193
ArticleTitle=IBM Business Analytics Diagnostics: Use Case: Content Store Database Growing Significantly Every Day
publish-date=03282012