DB2 - Problembeschreibung
| Problem IC91038 | Status: Geschlossen |
CREATE EVENT MONITOR FAILS WITH SQL0604N ON "BLOB (32) INLINE LENGTH 32" | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - 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: * * All creating event monitors * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to version 10.1 fix pack 3 * **************************************************************** | |
| Local-Fix: | |
| verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
| Lösung | |
First fixed in version 10.1 fix pack 3 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC95230 Nachfolger : | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.03.2013 27.09.2013 27.09.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
| Problem behoben lt. FixList in der Version | |
| 10.1.0.3 |
|
| 10.1.0.3 |
|