Number of concurrent connections to content store?

[Ricky@MDPD]

We have cognos 8.4 environment, installed on one server (win 2003). As soon as cognos services are started, we get 10 concurrent cognos logons into the Oracle content store, even though no user activity is present.

I would like to know:

1- Is it normal to have that many when no users are logged on?
2- what controls/dictates the number of these concurrent logons?
3- can they be reduced? Are they all required for normal cognos operation?

Any feedback is greatly appreciated.

[RobsWalker68]

Hi Richard,

I'm not sure what the default number of database connections in the connection pool usually is although I'm sure its lurking in a config file somewhere, but 10 doesn't sound unreasonable. 

Cognos will set up a pool of database connections so that it doesn't have to create and open a connection for new requests and this therefore improves response times. Is there any reason why you would want to reduce them? 

If you do need to make a change then you can do this through Administration.  Edit the advanced settings of the contentmanagerservice, 'override' and

1. Set Parameter to: CM.DbConnectPoolMax
2. Set value to your desired number.

Rgds


Rob

[Suraj]

You beat me to it Rob. :)
Before I submitted, it warned... there is a new reply...

Here is a link for more details:
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cra.8.4.0.doc/ug_cra_id5797ManagingDatabaseConnectionPoolSettingsforC.html

Try decreasing the connection to 3, and you'll see Cognos can't even start.