DB2 - Problem description
Problem IC91038 | Status: Closed |
CREATE EVENT MONITOR FAILS WITH SQL0604N ON "BLOB (32) INLINE LENGTH 32" | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
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 Summary: | |
**************************************************************** * USERS AFFECTED: * * All creating event monitors * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to version 10.1 fix pack 3 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
First fixed in version 10.1 fix pack 3 | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC95230 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.03.2013 27.09.2013 27.09.2013 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.3 | |
10.1.0.3 |