DB2 - Problem description
Problem IC73770 | Status: Closed |
DB2SYSC CRASHED IN SQLODIAGNOSEFREEBLOCKFAILURE() FOLLOWING USER INTERRUPT DURING LIKE PREDICATE PROCESSING | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
Signal 11 crash can be experienced during LIKE predicate processing following a user interrupt. Stack trace can resemble the following: sqloCrashOnCriticalMemoryValidationFailure sqloCrashOnCriticalMemoryValidationFailure sqlofmblkEx sqlriCCCLikeLong (or sqlriCCCLikeLongEsc, sqlriCCCLikeComputeRulesCore, sqlriCCCLikeShort or sqlriCCCLikeShortEsc) sqlriExecThread sqlriExecThread sqlrita sqlriExecThread sqlri_mj sqlriSectInvoke sqlrr_smp_router sqlrr_subagent_router sqleSubRequestRouter sqleProcessSubRequest RunEDU EDUDriver sqloEDUEntry | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users performing a user interrupt during a particular point * * of LIKE predicate evaluation involving DBCLOB or other long * * or short data types, in V95 or later releases. * **************************************************************** * PROBLEM DESCRIPTION: * * Users performing a user interrupt during a particular point * * of LIKE predicate evaluation involving DBCLOB or other long * * or short data types, in V95 or later releases, may * * experience signal 11 crash. * **************************************************************** * RECOMMENDATION: * * Don't perform user interrupt, or install 95FP8 or later, * * which contain the fix. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Solution | |
Install 95FP8 or later, which contain the fix. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC74027 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.01.2011 27.06.2011 27.06.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP8 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.8 |