home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList