|
Problem IC71178
|
Status: Geschlossen |
Output from deadlock event monitor shows incorrectly formatted data. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
Sample deadlock event monitor output:
436) Deadlock Event ...
Deadlock ID: 3
Deadlock node: 0
Number of applications deadlocked: 2
Deadlock detection time: 07/27/2010 23:05:01.791504
Rolled back Appl participant no: 2
Rolled back Appl Id: *N0.dwhprod.100727210357
Rolled back Appl seq number: : 000d
437) Connection Header Event ...
Appl Handle: 1023
Appl Id: *N0.dwhprod.100727210357
Appl Seq number: 00013
Here, we can see couple of problems:
1. Two ':' (colons) on line starting with 'Rolled back Appl seq
number'.
2. Line starting with 'Rolled back Appl seq number' shows hex
values. In the same output, rest of the values are decimal. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Prior to DB2 V91 FP10. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Output from deadlock event monitor shows incorrectly *
* formatted data. *
* *
* Sample deadlock event monitor output: *
* *
* *
* *
* 436) Deadlock Event ... *
* *
* Deadlock ID: 3 *
* *
* Deadlock node: 0 *
* *
* Number of applications deadlocked: 2 *
* *
* Deadlock detection time: 07/27/2010 23:05:01.791504 *
* *
* Rolled back Appl participant no: 2 *
* *
* Rolled back Appl Id: *N0.dwhprod.100727210357 *
* *
* Rolled back Appl seq number: : 000d *
* *
* 437) Connection Header Event ... *
* *
* Appl Handle: 1023 *
* *
* Appl Id: *N0.dwhprod.100727210357 *
* *
* Appl Seq number: 00013 *
* *
* *
* *
* Here, we can see couple of problems: *
* *
* *
* *
* 1. Two ':' (colons) on line starting with 'Rolled back Appl *
* seq number'. *
* *
* 2. Line starting with 'Rolled back Appl seq number' shows *
* hex values. In the same output, rest of the values are *
* decimal. *
****************************************************************
* RECOMMENDATION: *
* Upgrade DB2 to DB2 V91 FP10. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Lösung |
Problem first fixed in DB2 V91 FP10. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC71480 IC71481 IC71999
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 14.09.2010
23.06.2011
23.06.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP10
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.10
|
 |
