By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,611 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,611 IT Pros & Developers. It's quick & easy.

how to force a disconnect pending application which seems hang?

P: n/a
Hi, I have a "list applications show detail" item below.

DB2INST1 db2bp 524825 GAAF2D07.FB44.0E0F58094019 0003 1 8 0 Disconnect
Pending 08/28/2005 21:24:11.012683 JXCRM
/db2data/db2inst1/NODE0000/SQL00001/

it has been hang there for more than 10 days.

force application(appid) will not work.

since it is a productive environment, I cannot just do some "db2_kill"
like job. the process id is '0', why?

is there any effective way to remove that application in this
situation?

with thanks

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Not sure what DB2 software level you're using. I had similar-sounding
issues with v7.1 FP13 which I raised with IBM. The response was that
problems with the FORCE command had been introduced and that these
problems were only fixed in v8. The solution: upgrade to v8.

Nov 12 '05 #2

P: n/a
oh, my db2level is 8.1.6b...

Nov 12 '05 #3

P: n/a
oh, thank you, bruce, but my db2level is 8.1.6b...

there still be applications which cannot be forced in v8...

Nov 12 '05 #4

P: n/a
Find the UNIX Process which it is associated with by using
DB2PD and kill -9 <process>

Cheers...
Shashi Mannepalli

wy****@gmail.com wrote:
Hi, I have a "list applications show detail" item below.

DB2INST1 db2bp 524825 GAAF2D07.FB44.0E0F58094019 0003 1 8 0 Disconnect
Pending 08/28/2005 21:24:11.012683 JXCRM
/db2data/db2inst1/NODE0000/SQL00001/

it has been hang there for more than 10 days.

force application(appid) will not work.

since it is a productive environment, I cannot just do some "db2_kill"
like job. the process id is '0', why?

is there any effective way to remove that application in this
situation?

with thanks


Nov 12 '05 #5

P: n/a
thanks~

'kill -9' maybe will make the server down.

more, in my case, the process id is '0'...

I think maybe the best things to do is nothing to do.

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.