home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC77679 Status: Geschlossen

ACTIVATING A V9.1 TABLESPACE OR BUFFERPOOL or V9.1 or V9.5 CONNECTION OR
DATABASE EVENT MONITOR RETURNS SQL20155N

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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.
verfügbare FixPacks:
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

Lösung
Problem was first fixed in Version 9.7 Fix Pack 5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.07.2011
21.12.2011
21.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList