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

[question] db2 v8, how to force applications which status in "Federated request pending"

P: n/a
env: db2 LUW v8 + aix
We encounter some java applications status did not change and keep in
"Federated request pending" for a long time.
we try issue db2 "force applications <handle id>" to terminate the
application, but did not work.

Anyone know how to terminate this kind applications ? Thanks.
================================================== ======
part of snapshot:
Application handle = 50
Application status = Federated request pending
Status change time =
Application code page = 1208
Application country/region code = 88
DUOW correlation token =
AC115020.F104.00C901080340
Application name = javaw.exe
Application ID =
AC115020.F104.00C901080340
Sequence number = 0001
TP Monitor client user ID =
TP Monitor client workstation name =
TP Monitor client application name =
TP Monitor client accounting string =

Connection request start timestamp = 04/11/2007
16:03:35.298796
Connect request completion timestamp = 04/11/2007 16:03:35.299222

May 22 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
wu*******@gmail.com wrote:
env: db2 LUW v8 + aix
We encounter some java applications status did not change and keep in
"Federated request pending" for a long time.
we try issue db2 "force applications <handle id>" to terminate the
application, but did not work.

Anyone know how to terminate this kind applications ? Thanks.
================================================== ======
part of snapshot:
Application handle = 50
Application status = Federated request pending
Status change time =
Application code page = 1208
Application country/region code = 88
DUOW correlation token =
AC115020.F104.00C901080340
Application name = javaw.exe
Application ID =
AC115020.F104.00C901080340
Sequence number = 0001
TP Monitor client user ID =
TP Monitor client workstation name =
TP Monitor client application name =
TP Monitor client accounting string =

Connection request start timestamp = 04/11/2007
16:03:35.298796
Connect request completion timestamp = 04/11/2007 16:03:35.299222
If a db2agent is in "Federated request pending" state, you will have to
initiate a cancel at the remote data source. The local DB2 process will be
blocked until the remote data source comes back with an answer. Therefore,
the force-operation is not detected.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
May 22 '07 #2

P: n/a
On May 23, 12:57 am, Knut Stolze <sto...@de.ibm.comwrote:
wugon....@gmail.com wrote:
env: db2 LUW v8 + aix
We encounter some java applications status did not change and keep in
"Federated request pending" for a long time.
we try issue db2 "force applications <handle id>" to terminate the
application, but did not work.
Anyone know how to terminate this kind applications ? Thanks.
================================================== ======
part of snapshot:
Application handle = 50
Application status = Federated request pending
Status change time =
Application code page = 1208
Application country/region code = 88
DUOW correlation token =
AC115020.F104.00C901080340
Application name = javaw.exe
Application ID =
AC115020.F104.00C901080340
Sequence number = 0001
TP Monitor client user ID =
TP Monitor client workstation name =
TP Monitor client application name =
TP Monitor client accounting string =
Connection request start timestamp = 04/11/2007
16:03:35.298796
Connect request completion timestamp = 04/11/2007 16:03:35.299222

If a db2agent is in "Federated request pending" state, you will have to
initiate a cancel at the remote data source. The local DB2 process will be
blocked until the remote data source comes back with an answer. Therefore,
the force-operation is not detected.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany- Hide quoted text -

- Show quoted text -
Hi Knut ,
Thanks your advice.

May 23 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.