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 |
|