|
Problem IC71178
|
Status: Closed |
Output from deadlock event monitor shows incorrectly formatted data. |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - 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: *
* 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: |
|
| available fix packs: |
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
|
| Solution |
Problem first fixed in DB2 V91 FP10. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC71480 IC71481 IC71999
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.09.2010
23.06.2011
23.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
