|
Problem IC77679
|
Status: Closed |
ACTIVATING A V9.1 TABLESPACE OR BUFFERPOOL or V9.1 or V9.5 CONNECTION OR DATABASE EVENT MONITOR RETURNS SQL20155N |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
If a bufferpool or tablespace event monitor has been created in
V9.1 and the database is upgraded to V9.7, activating the event
monitor will fail and return SQL20155N.
If a connection or database event monitor has been created in
V9.1 or V9.5 and the database is upgraded to V9.7, activating
the event monitor will fail and return SQL20155N. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Anybody using bufferpool, connection or database event *
* monitors. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When an event monitor activates each target table is *
* validated to ensure the columns match elements. The *
* BUFFERPOOL target table created for BUFFERPOOL event *
* monitors created in V9.1 will fail table validation and stop *
* the event monitor from activating. The TABLESPACE target *
* table created for TABLESPACE event monitors created in V9.1 *
* will fail table validation and stop the event monitor from *
* activating. The CONN target table created for CONNECTION *
* event monitors created in v9.1 or v9.5 will fail table *
* validation and stop the event monitor from activating. The *
* DB target table created for DATABASE event monitors created *
* in v9.1 or v9.5 will fail table validation and stop the *
* event monitor from activating. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Versoin 9.7 Fix Pack 5 *
**************************************************************** |
| Local Fix: |
Drop and recreate the event monitors. |
| available fix packs: |
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 was first fixed in Version 9.7 Fix Pack 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.07.2011
21.12.2011
21.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
