Wednesday, March 14, 2012

What is CMCAPACITY table?

Recently, I was approached for clarification on CMCAPACITY table and what does it do. Well here's the simple answer

The CMCAPACITY  table keeps track of the registered dispatchers.  Just do a test on your machine, when you start CM, you'll see your dispatcher with usage = 4 and when you shutdown, it should be blank.
If CM has a row = 4  and CM is not running, it could have been improperly shutdown or something of that nature. If there is a usage of 4, it can prevent CM from locking the content store DB on start-up of IBM Cognos.

Well, if you love complex answers, there an developer works article and utilities about understanding your Cognos Content Store database using Content Manager Size and Browser Tools