Looking for information about Cognos? I was. My colleague in the UK, Richard Collins, was able to point me to some informational links about Cognos.
For full details on this product, see its home page here: http://www-01.ibm.com/software/analytics/cognos/business-intelligence/
However, your most useful starting point is probably going to be: http://www-01.ibm.com/support/docview.wss?uid=swg27014432
...and in particular, this one: http://www-01.ibm.com/support/docview.wss?uid=swg27019126
Tuesday, November 9, 2010
In the developers resource references there is an attribute for global transaction sharing.The value should be Shareable if the application uses global transactions. But if one is using LTC then one does not need to share the connection. Change the res-sharing-scope to Unshareable as noted above. This eliminates a lot of contention for connection pool threads. For more details on LTC see the link above to understand how it works.