Kill Long-running query

[SivaSivaSivaSiva]

Hello,

How can we kill a long running query in DB2? In the front end, we have one cancel button.When the user clicks cancel button, the query should stop processing.

Regards,
Siva

 

[blom0344]

you should look into the 'force application' commands in the command line processor.
Use 'list applications' to get oversight of connections...

T. Blom
Information analyst
tbl@shimano-eu.com

 

[SivaSivaSivaSiva]

Hello,

Our Operating system is AIX (Production). rightnow the development is going on in Windows 2000 Server.We are using DB2 UDB v8.1

we have one web application and this application has one archiving process.When the user clicks start button in the page, the archiving process will start running. We will be having one cancel button also in the page, and if the user clicks the cancel button or close the web page, we have to kill the archiving process(It has both insert and select). In this case, how can we kill the whole process from the front end?

Please help........

regards,
Siva