Troubleshooting
Problem
Attempting to terminate an application in "Connect Completed" has no effect by using FORCE APPLICATION command.
Symptom
- The following application can be identified from snapshot, db2pd or list applications command:
$ db2 get snapshot for application agentid 19631
Application handle = 19631
Application status = Connect Completed
...
Application name = db2fw3
...
- FORCE APPLICATION has been issued:
$ db2 force application "(19631)"
DB20000I The FORCE APPLICATION command completed successfully.
DB21024I This command is asynchronous and may not be effective immediately.
- However the application persists:
$ db2 list applications show detail
CONNECT Auth Id Application Name Appl. Application Id Seq# Number of Coordinating Coordinator Status Status Change Time DB Name DB Path
Handle Agents member number pid/thread
-------------------------------------------------------------------------------------------------------------------------------- -------------------- ---------- -------------------------------------------------------------- ----- ---------- ---------------- --------------- ------------------------------ -------------------------- -------- --------------------
HWANG db2fw3 19631 *LOCAL.DB2.160927193903 00001 1 0 9628 Connect Completed Not Collected SAMPLE /home2/db2v105a/db2v105a/NODE0000/SQL00001/MEMBER0000/
...
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Performance - Event Monitor","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.5;11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
01 May 2025
UID
swg21991316