DB2 - Problem description
Problem IC71324 | Status: Closed |
INSTANCE MIGHT CRASH WHEN USERS USE DB2SORT VARIABLE | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
DB2 instance might crash when users enabled DB2SORT db2set variable. -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00002B27F6FBD93F ossDumpStackTraceEx + 0x01ef (/home/db2la9d4/sqllib/lib64/libdb2osse.so.1) 0x00002B27F6FB8706 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc (/home/db2la9d4/sqllib/lib64/libdb2osse.so.1) 0x00002B27F42D2E0D sqlo_trce + 0x03fb (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F43173FB sqloEDUCodeTrapHandler + 0x0243 (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00000033D280E930 __pthread_mutex_cond_lock + 0x0330 (/lib64/libpthread.so.0) 0x00002B27F4B45C8E _Z25sqluAssignRIDsToDMRecListP13SQLUCACB_TYPEP8sqeAgentP13SQLO_Q UE_DESCS4_S4_PP18SQLU_DMRECORD_LIST + 0x065e (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F4B45513 _Z27sqluRiddifierProcOneSubListP13SQLUCACB_TYPEP8sqeAgentP18SQLU _DMRECORD_LISTP13SQLO_QUE_DESCS6_S6_l + 0x007f (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F4B4442B _Z27sqluRiddifierProcessRecListP13SQLUCACB_TYPEP8sqeAgentP18SQLU _DMRECORD_LISTP13SQLO_QUE_DESCS6_S6_l + 0x08e9 (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F4B475FA _Z22sqluProcessOrCacheListP13SQLUCACB_TYPEP14SQLU_RIDDER_CBP18SQ LU_DMRECORD_LIST + 0x01c4 (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F4B4A315 _Z17sqluGetDMRecListsP13SQLUCACB_TYPEP14SQLU_RIDDER_CBl + 0x05b9 (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F4B4AFAF _Z11sqlulRIDderPhj + 0x043b (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F2E2AD62 sqloEDUEntry + 0x02f4 (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00000033D2806617 pthread_create@@GLIBC_2.2.5 + 0x01a7 (/lib64/libpthread.so.0) 0x00000033D1CD3D1D clone + 0x006d (/lib64/libc.so.6) | |
Problem Summary: | |
Problem Description: INSTANCE MIGHT CRASH WHEN USERS USE DB2SORT VARIABLE Problem Summary: DB2 instance might crash when users enabled DB2SORT db2set variable. -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00002B27F6FBD93F ossDumpStackTraceEx + 0x01ef (/home/db2la9d4/sqllib/lib64/libdb2osse.so.1) 0x00002B27F6FB8706 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc (/home/db2la9d4/sqllib/lib64/libdb2osse.so.1) 0x00002B27F42D2E0D sqlo_trce + 0x03fb (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F43173FB sqloEDUCodeTrapHandler + 0x0243 (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00000033D280E930 __pthread_mutex_cond_lock + 0x0330 (/lib64/libpthread.so.0) 0x00002B27F4B45C8E _Z25sqluAssignRIDsToDMRecListP13SQLUCACB_TYPEP8sqeAgentP13SQLO_Q UE_DESCS4_S4_PP18SQLU_DMRECORD_LIST + 0x065e (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F4B45513 _Z27sqluRiddifierProcOneSubListP13SQLUCACB_TYPEP8sqeAgentP18SQLU _DMRECORD_LISTP13SQLO_QUE_DESCS6_S6_l + 0x007f (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F4B4442B _Z27sqluRiddifierProcessRecListP13SQLUCACB_TYPEP8sqeAgentP18SQLU _DMRECORD_LISTP13SQLO_QUE_DESCS6_S6_l + 0x08e9 (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F4B475FA _Z22sqluProcessOrCacheListP13SQLUCACB_TYPEP14SQLU_RIDDER_CBP18SQ LU_DMRECORD_LIST + 0x01c4 (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F4B4A315 _Z17sqluGetDMRecListsP13SQLUCACB_TYPEP14SQLU_RIDDER_CBl + 0x05b9 (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F4B4AFAF _Z11sqlulRIDderPhj + 0x043b (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00002B27F2E2AD62 sqloEDUEntry + 0x02f4 (/home/db2la9d4/sqllib/lib64/libdb2e.so.1) 0x00000033D2806617 pthread_create@@GLIBC_2.2.5 + 0x01a7 (/lib64/libpthread.so.0) 0x00000033D1CD3D1D clone + 0x006d (/lib64/libc.so.6) | |
Local Fix: | |
n/a | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
Problem is first fixed in Version 9.7 Fixpack 4 | |
Workaround | |
n/a | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC73487 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.09.2010 29.04.2011 29.04.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP4 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.4 |