|
Problem IC76637
|
Status: Geschlossen |
INTERRUPTING CLIENT MIGHT LEAD TO ENGINE HANG DUE TO AGENT STUCK IN SEMOP(). |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Lösung |
Problem was first fixed in DB2 UDB Version 9.8 Fix Pack 4. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 25.05.2011
31.07.2011
31.07.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.8.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.8.0.4
|
 |
