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
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.
Thank you for ur suggestion Meep...Will try this n let u know.........
Shan