|
Problem IC71481
|
Status: Closed |
Output from deadlock event monitor shows incorrectly formatted data. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* Users prior to DB2 V97 FP4 *
****************************************************************
* PROBLEM DESCRIPTION: *
* Output from deadlock event monitor shows incorrectly *
* formatted *
* data. *
****************************************************************
* RECOMMENDATION: *
* Upgrade DB2 to V97 FP4. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
Problem is first fixed in DB2 V97 FP4. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.09.2010
09.05.2011
09.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
