|
Problem IC86068
|
Status: Closed |
SYSTEM MODULE ROUTINE DBMS_ALERT.REGISTER MAY INCORRECTLY REMOVE ACTIVE ALERTS. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The system module DBMS_ALERT is used to send alerts between
applications.
Each alert must be registered with the DBMS_ALERT.REGISTER
routine.
If an application disconnects, then any alerts that were
associated to that application are no longer active.
During the register process, db2 will clean up any old alerts
from previous applications that have since disconnected.
However, if multiple alerts are registered from different
applications concurrently with specific timing, then there is a
logic problem that might (depending on specific timing) result
in removing an active registered alert for an application that
is currently connected. This will result in the failure to
signal or wait for the alert that was incorrectly removed.
The problem is more likely to occur on (but not limited to), a
DPF instance. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v97 fixpack 7. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 fixed in v97 fixpack 7. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC86092
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.08.2012
20.10.2012
20.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
