DB2 - Problembeschreibung
Problem IC95230 | Status: Geschlossen |
CREATE EVENT MONITOR FAILS WITH SQL0604N ON "BLOB (32) INLINE LENGTH 32" | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Creating an event monitor might fail on activity tables in table space of 16k page size : % db2 "CREATE EVENT MONITOR MY_WLM_ACTIVITIES FOR ACTIVITIES WRITE TO TABLE ACTIVITY (TABLE MYTOOLS.ACTIVITY_WLM_ACTIVITIES IN MYEVENTMON ), ACTIVITYSTMT (TABLE MYTOOLS.ACTIVITYSTMT_WLM_ACTIVITIES IN MYEVENTMON ), ACTIVITYVALS ( TABLE TOOLS.ACTIVITYVALS_WLM_ACTIVITIES IN MYEVENTMON ) AUTOSTART" DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0604N The length, precision, or scale attribute for column, distinct type, structured type, array type, attribute of structured type, routine, cast target type, type mapping, or global variable "BLOB (32) INLINE LENGTH 32" is not valid. SQLSTATE=42611 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Using event monitors * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to version 10.5 FP3 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in version 10.5 FP3 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.08.2013 27.02.2014 27.02.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.3 | |
10.5.0.3 |