|
Problem IC76637
|
Status: Closed |
INTERRUPTING CLIENT MIGHT LEAD TO ENGINE HANG DUE TO AGENT STUCK IN SEMOP(). |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problem description: |
In this example 'db2look' was used as the client.
After interrupting 'db2look' using CTRL-C we can see that the
'db2look' process is gone as it does not appear in the 'ps'
output
anymore.
$ ps -ef | grep db2look | grep -v grep
However, db2look still appears in the list of applications.
$ db2 list applications
Auth Id Application Appl. Application Id
DB # of
Name Handle
Name Agents
-------- -------------- ----------
--------------------------------------------------------------
-------- -----
E95Q7A db2look 97 *LOCAL.e95q7a.110408030010
SAMPLE 1
$ db2pd -db sample -locks
Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days
00:04:13 -- Date 04/05/2011 13:34:33
Locks:
Address TranHdl Lockname Type
Mode Sts Owner Dur HoldCount Att ReleaseFlg
0x07000000303505C0 2 4442324C32473032E3E6718241
Internal P ..S G 2 1 0 0x00 0x40000000
0x0700000030350E80 2 00000001000000010001240056
Internal V ..S G 2 1 0 0x00 0x40000000
0x0700000030350A80 2 00000005000000000000000054 Table
.IN G 2 1 1 0x00 0x40000000
0x0700000030351C80 2 00000061000000000000000054 Table
.IN G 2 1 1 0x00 0x40000000
0x0700000030351A80 2 0000000C000000000000000054 Table
.IN G 2 1 1 0x00 0x40000000 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* In this example 'db2look' was used as the client. *
* *
* After interrupting 'db2look' using CTRL-C we can see that *
* the 'db2look' process is gone as it does not appear in the *
* 'ps' output anymore. *
* *
* *
* $ ps -ef | grep db2look | grep -v grep *
* *
* *
* However, db2look still appears in the list of applications. *
* *
* *
* $ db2 list applications *
* *
* Auth Id Application Appl. Application Id *
* DB # of *
* Name Handle *
* Name Agents *
* *
* -------- -------------- ---------- *
* --------------------------------------------------------------
* -------- ----- *
* *
* E95Q7A db2look 97 *LOCAL.e95q7a.110408030010 *
* SAMPLE 1 *
* *
* *
* $ db2pd -db sample -locks *
* *
* *
* *
* Database Partition 0 -- Database SAMPLE -- Active -- Up 0 *
* days 00:04:13 -- Date 04/05/2011 13:34:33 *
* Locks: *
* Address TranHdl Lockname Type *
* Mode Sts Owner Dur HoldCount Att ReleaseFlg *
* *
* 0x07000000303505C0 2 4442324C32473032E3E6718241 *
* Internal P ..S G 2 1 0 0x00 *
* 0x40000000 *
* 0x0700000030350E80 00000001000000010001240056 *
* Internal V ..S G 2 1 0 0x00 0x40000000 *
* *
* 0x0700000030350A80 2 00000005000000000000000054 *
* Table .IN G 2 1 1 0x00 0x40000000 *
* *
* 0x0700000030351C80 2 00000061000000000000000054 *
* Table .IN G 2 1 1 0x00 0x40000000 *
* *
* 0x0700000030351A80 2 0000000C000000000000000054 *
* Table .IN G 2 1 1 0x00 0x40000000 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB version 9.8 fixpack 4. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Solution |
Problem was first fixed in DB2 UDB Version 9.8 Fix Pack 4. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.05.2011
31.07.2011
31.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.4
|
 |
