If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos Locking database tables during report execution

Started by sshan, 16 Mar 2011 01:51:11 AM

Previous topic - Next topic

sshan

We are using Cognos 8.4.1 reports which connect to SQL Server 2008. When reports are executed, the underlying tables are locked by Cognos. This is hampering our ETL routines which at the same time insert fresh data into the tables. Is there a way we can overcome this problem of Cognos locking the database tables ?

Your help is much appreciated..........
Thanks,
Shan

MFGF

One thing you can check is what transaction isolation level your data source connection has been configured to use in Cognos 8.  You can also try changing it to something low, such as Read Committed.

Regards,

MF.
Meep!

sshan

Thank you for ur suggestion Meep...Will try this n let u know.........

Shan