How to kill a process/query in DB2

sql db2 kill-process
Kayser picture Kayser · Mar 13, 2012 · Viewed 42.8k times · Source

I try to optimize a query. After every change, I must wait long time that the query is finished. It is really time consuming.

Is there any way to see the executed queries and kill/stop them??

Answer

bhamby picture bhamby · Mar 13, 2012

In the DB2 instance command line, you can type

db2 list applications show detail

In this list, you should find your process, note the application id. You can use this command to kill it:

db2 force application (xx)

Where xx is the ID (or a comma-delimited list of IDs).

Here is the DB2 for Linux/Unix/Windows v9.7 Information Center article on FORCE APPLICATION, and here is the one for LIST APPLICATIONS. For both of these commands, you have to have the proper privileges on the database instance (most commonly SYSADM or SYSCTRL).

Related questions

DB2 Query to retrieve all table names for a given schema

I'm just looking for a simple query to select all the table names for a given schema. For example, our DB has over 100 tables and I need to find any table that contains the sub-string “CUR”. I can use the …

Read More
show all tables in DB2 using the LIST command

This is embarrassing, but I can't seem to find a way to list the names of the tables in our DB2 database. Here is what I tried: root@VO11555:~# su - db2inst1 root@VO11555:~# . ~db2inst1/sqllib/db2profile …

Read More
DB2 Date format

I just want to format current date into yyyymmdd in DB2. I see the date formats available, but how can I use them? http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.…

Read More