|
Problem IC72746
|
Status: Geschlossen |
THE APPL_STATUS FOR LASTUSED DAEMON MAY BE STICKING IN UOW EXECUTING. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
The appl_status monitor element for lastused daemon (db2lused)
is sticking in 'UOW Executing' if db2lused have waited on a lock
to update system catalog. The monitor element shows incorrect
state because db2lused actually do commits in every intervals.
The following steps illustrates one of the scenario to cause
this problem.
1. Update a user table, then take Z lock on the table
2. Wait for more than 15 minutes so that db2lused can update
system catalogs.
3. Print appl_status
$ db2 list application show detail
Application Name Appl. Status DB Name
Handle
------------------- ------- --------------- ---------
db2lused 11 UOW Executing SAMPLE |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users. *
****************************************************************
* PROBLEM DESCRIPTION: *
* The appl_status monitor element for lastused daemon *
* (db2lused) is sticking in 'UOW Executing' if db2lused have *
* waited on a lock to update system catalog. The monitor *
* element shows incorrect state because db2lused actually do *
* commits in every intervals. *
* *
* The following steps illustrates one of the scenario to cause *
* this problem. *
* *
* 1. Update a user table, then take Z lock on the table. *
* 2. Wait for more than 15 minutes so that db2lused can update *
* system catalogs. *
* 3. Print appl_status. *
* $ db2 list application show detail *
* Application Name Appl. Status DB Name *
* Handle *
* ------------------- ------- --------------- --------- *
* db2lused 11 UOW Executing SAMPLE *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to DB2 v9.7 fixpack 4 or later. *
**************************************************************** |
| Local-Fix: |
None, users can ignore the application status. |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
This problem is first fixed in DB2 v9.7 fixpack 4. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 23.11.2010
19.05.2011
19.05.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
