Cognos locking SQL database table

[Jane]

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

[blom0344]

You can set the isolation level for the configured connection in Cognos administration. (though a straightforward select should not cause a table lock AFAIK)

[mdani]

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
 

[blom0344]

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