COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: ricky_ru on 22 Oct 2013 05:11:15 AM

Title: Cancel a concurrent queries report does not work well.
Post by: ricky_ru on 22 Oct 2013 05:11:15 AM
With this link:http://pic.dhe.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_cra.10.1.0.doc%2Fug_cra_id9673ConcurrentQueryExecution.html
The performance is really impoved.

Without the concurrent setting, after I cancel the report, I could see the SQL is cancelled in the database side.
But with this setting, click the cancel button, Those SQLs are still running in the database side. I am not sure if this is a expected behavior. I tested several times and got the same. Which trace(UDA?) should I use to trace this cancel behavior to find if it is a cognos defect.

Any suggestion is welcome.

Ricky
Thanks.
Title: Re: Cancel a concurrent queries report does not work well.
Post by: Grim on 22 Oct 2013 09:32:24 AM
UDA and CQE (Cognos Query Execution).