Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.