Toad World® Forums

How do I kill a query (that won't die) that's running against a DB2 table?

Message from: phil.white_203

How do I kill a query (that won’t die) that’s running against a DB2
table? At times I have a query that just keeps churning after I cancel it. And
terminating the TOAD session doesn’t kill the DB2 thread either.


Historical Messages

Author: phil.white_203
Date: Fri Sep 16 11:18:28 PDT 2011
How do I kill a query (that won’t die) that’s running against a DB2
table? At times I have a query that just keeps churning after I cancel it. And
terminating the TOAD session doesn’t kill the DB2 thread either.

__


How do I kill a query (that won’t die) that’s running against a DB2
table? At times I have a query that just keeps churning after I cancel
it. And terminating the TOAD session doesn’t kill the DB2 thread either.
Well, can you kill the session on the DB2 database?


Cheers,
Norm. [TeamT]

I pull the network cable… if that doesn’t get it I call the dba

Sent via Samsung Galaxy S from Cellular South

On Sep 17, 2011 12:28 PM, "Norman Dunbar" wrote:

How do I kill a query (that won’t die) that’s running against a
DB2
table? At times I have a q…

Well, can you kill the session on the DB2 database?

--
Cheers,
Norm. [TeamT]

Message from: phil.white_203

No. I don’t have permissions. I have to call the DBA. I’d like to save
the trouble, if possible.


Historical Messages

Author: phil.white_203
Date: Tue Sep 20 09:50:11 PDT 2011
No. I don’t have permissions. I have to call the DBA. I’d like to save
the trouble, if possible.

__

Author: gene.l.bradley
Date: Sat Sep 17 15:53:06 PDT 2011
I pull the network cable… if that doesn’t get it I call the dba Sent via
Samsung Galaxy S from Cellular South On Sep 17, 2011 12:28 PM, “Norman Dunbar”
wrote: > How do I kill a query (that won’t die) that’s running
against a DB2 > table? At times I have a q… Well, can you kill the session on
the DB2 database? – Cheers, Norm. [TeamT]
__

Author: Norman Dunbar
Date: Sat Sep 17 10:33:50 PDT 2011

How do I kill a query (that won’t die) that’s running against a DB2 > table?
At times I have a query that just keeps churning after I cancel > it. And
terminating the TOAD session doesn’t kill the DB2 thread either. Well, can you
kill the session on the DB2 database? – Cheers, Norm. [TeamT]
__

Author: phil.white_203
Date: Fri Sep 16 11:18:28 PDT 2011
Message from: phil.white_203 How do I kill a query (that won’t die)
that’s running against a DB2 table? At times I have a query that just keeps
churning after I cancel it. And terminating the TOAD session doesn’t kill
the DB2 thread either. _______________________________________ Historical
Messages Author: phil.white_203 Date: Fri Sep 16 11:18:28 PDT 2011 How do I kill
a query (that won’t die) that’s running against a DB2 table? At times I
have a query that just keeps churning after I cancel it. And terminating the
TOAD session doesn’t kill the DB2 thread either. __


__


No. I don’t have permissions. I have to call the DBA. I’d like to save the trouble, if possible.

Morning Phil,

No. I don’t have permissions. I have to call the DBA. I’d
like to save the trouble, if possible.
In that case, you have only two options I’m afraid:

  1. Get the DBA to give you permissions; or

  2. Continue to request that the DBA kill your runaway sessions.

On the other hand, there may be a way that the DBA can investigate why
the session runs away and cannot be killed?

Good luck.

Cheers,
Norm. [TeamT]

Norman Dunbar
Contract Senior Oracle DBA
Capgemini Database Build Team
Internal : 7 28 2051
External : 0113 231 2051

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk