DB2 - Problem description
Problem IC89859 | Status: Closed |
DB2 MAY ABEND WHEN USING DB2 TEXT EXTENDERS | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
A rare timing condition involving loading/unloading of the DB2 client library when using DB2 text extenders may cause a DB2 instance to shutdown abnormally (trap). The trap symptoms may vary and are similar to memory corruption. Examples: _getpwnam_shadow_r _posix_getpwnam_shadow_r osshomepath.getpwnam_r ossBuildHomeDirectoryRelativePath GlobalReg.GetGlobalRegPathnameInternal GlobalReg::init GlobalReg::GlobalReg ossOpenInstanceList EnvRegRefresh EnvRegOpen sqloPRegQueryDefaultValue EnvGetDB2SysVar EnvQueryDB2SystemVariables sqloInitEnvironment .sqloAppLibInit mod_init1 usl_init_mods uload load1 load loadAndInit dlopen sqloAIXLoadModuleTryShr sqloLoadModule sqlerLibraryLoad .sqlerRoutineLoad .sqlriOneTimeInitRtn1Trusted sqlriOneTimeInitRtn ... sqleAddToFreeCtxList sqleFreeTrustedCtxInternal sqleUCtrustedRtnTerm sqlerLibraryTrueUnload sqlerLibraryUnloadAll sqlri_close_udf_eog sqlrr_appl_term ... | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Systems running DB2 Text Extenders * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 3 * **************************************************************** | |
Local Fix: | |
A workaround is to invoke a trusted routine over a persistent connection. This will keep the client library loaded in the db2 server process, thus avoiding the timing condition. db2 connect to <database> db2 "values dayofyear(current timestamp)" < leave this connection open continuously > | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
Problem first fixed in DB2 Version 10.1 Fix Pack 3 | |
Workaround | |
see Local Fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.01.2013 04.12.2013 04.12.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 |