Monday 6 October 2014

Business Monitor and Cognos performance problem


Recently we have been seeing some issues with our Business Monitor servers on start up.   After running IBM Business Monitor 7.5.1 for over a year, every time we restarted the environment there was a spike in CPU consumption that lasted for over half an hour.

On closer inspection it was the cognos process spawned by Monitor that was consuming all this CPU.    A quick call to IBM support pointed us at the NC tables used by cognos.  A few of our tables had over half a million rows, where as the following document suggestes anything over 1000 could impact performance:

http://www-01.ibm.com/support/docview.wss?uid=swg21637944

So we followed the steps in the technote and cleared down the NC tables and all of a sudden there was no issue following the next restart.

We have been keeping an eye on these tables since then and noticed they do continue to grow.   Further questions to IBM support suggest this is normal behavior as long as there is no rapid increase in the size of the tables.  It just means every now and then we may have to clear down these tables again.
Posted by at

5 comments:

  1. Unknown23 January 2015 at 05:42

    This comment has been removed by a blog administrator.

    ReplyDelete
  2. 21cssIndia22 February 2015 at 19:23

    Websphere admin --- "
    Websphere admin Online Training

    Send ur Enquiry to contact@21cssindia.com
    Introduction
    Presentation – Oriented (Standalone)
    Service Oriented
    Client/Server Application
    Client/Server VS Web Application" more… Online Training- Corporate Training- IT Support U Can Reach Us On +917386622889 - +919000444287 http://www.21cssindia.com/courses/websphere-admin-online-training-75.html

    ReplyDelete
  3. Unknown8 February 2016 at 03:25

    Thanks for nice topic. Very useful information.
    Cognos Online Training are good in giving the cognos nlineTraining

    ReplyDelete
  4. Unknown14 February 2016 at 22:24

    Thanks for nice topic. Very useful information.
    We Ithub Online Training are good in giving the CognosOnlineTraining

    ReplyDelete
  5. Anonymous22 August 2016 at 11:02

    Hi,

    The bigger issue that we need to concern ourselves with is whether or not we have the need for an email database in order to become effective IBM Websphere Email Database in our email marketing

    ReplyDelete

Subscribe to: Post Comments (Atom)