|
Problem IC86092
|
Status: Closed |
SYSTEM MODULE ROUTINE DBMS_ALERT.REGISTER MAY INCORRECTLY REMOVE ACTIVE ALERTS. |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - 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 users running DB2 Version 10.1 on Linux, Unix or Windows *
* platform and running SYSTEM MODULE ROUTINE *
* DBMS_ALERT.REGISTER *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update the DB2 Version 10.1 Fix Pack 2. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
This problem is first fixed in DB2 Version 10.1 Fix Pack 2. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.08.2012
31.12.2012
31.12.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
