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

[wugon.net]

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

[Knut Stolze]

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

[wugon.net]

On May 23, 12:57 am, Knut Stolze <[e-mail]:

[e-mail] 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.