We are having issue with Cognos report locking the SQL database table.
Is there anyway to set a "NoLock" option? or at least get Cognos to let go sooner?
Thanks
Jane
You can set the isolation level for the configured connection in Cognos administration. (though a straightforward select should not cause a table lock AFAIK)
Quote from: blom0344 on 19 Feb 2013 03:04:52 PM
You can set the isolation level for the configured connection in Cognos administration. (though a straightforward select should not cause a table lock AFAIK)
Hi Blom0344,
As per my understanding, the we must set the isolation to read uncommitted specially for transactional database right, so that changes made to db is immediately available for next updates in DB?
Reference: http://pic.dhe.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_cra.10.1.0.doc%2Fug_cra_id13211IsolationLevels.html
Concurrency, locking and isolation levels is an extensive topic with relational databases. I do not claim to be an expert on this, but AFAIR from DB2 DBA training (looooong time ago) relationship exists between isolation levels and lock (escalation) , so a low isolation level should minimize locking