|
Problem IC62592
|
Status: Closed |
SQL1619N MAY BE ENCOUNTERED WHEN DROPPING AN EVENT MONITOR. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
A timing hole exists when the event monitor is shutting down
(set event monitor state 0) and when the event monitor is
dropped. The condition may arise where the event monitor cannot
be dropped due to the state 0 invocation. Event monitors may
still exist even though the client has requested it to be
dropped. As this occurs after the shutting down of the event
monitor; no real harm exists to the database or instance.
DROP EVENT MONITOR <name>
leads to
>>
DB21034E The command was processed as an SQL statement because
it was not a valid Command Line Processor command. During SQL
processing it
returned:
SQL1619N Cannot DROP an active event monitor. SQLSTATE=55034 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All DB2 LUW server environments are affected. *
****************************************************************
* PROBLEM DESCRIPTION: *
* A timing hole exists when the event monitor is shutting down *
* *
* (set event monitor state 0) and when the event monitor is *
* *
* dropped. The condition may arise where the event monitor *
* cannot *
* be dropped due to the state 0 invocation. Event monitors may *
* *
* still exist even though the client has requested it to be *
* *
* dropped. As this occurs after the shutting down of the event *
* *
* monitor; no real harm exists to the database or instance. *
* *
* DROP EVENT MONITOR <name> *
* leads to *
* >> *
* DB21034E The command was processed as an SQL statement *
* because *
* it was not a valid Command Line Processor command. During *
* SQL *
* processing it *
* returned: *
* SQL1619N Cannot DROP an active event monitor. SQLSTATE=55034 *
****************************************************************
* RECOMMENDATION: *
* Recommended to upgrade to DB2 LUW v95 fix pack 5. *
**************************************************************** |
| Local Fix: |
You should be able to bypass the issue by adding a sleep
between the deactivate and the drop. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The problem has been fixed in DB2 LUW v95 fix pack 5. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC63780
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.08.2009
24.02.2010
24.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.5
|
 |
