DB2 FOR LUW / DB2FORLUW / 970 - DB2

There is a potential for a crash in  sqlex_find_group when 
cumulative length of group names  returned for an user id is 
greater then 64K. 
 
Stack similar to: 
DB2 build information: DB2 v9.7.0.6 special_30249 SQL09076 
timestamp: 2015-01-23-10.14.28.601216 
instance name: db2inst1.000 
EDU name     : db2agent (SAMPLE) 0 
EDU ID       : 232 
Signal #11 
uname: S:Linux R:2.6.18-308.13.1.el5 V:#1 SMP Thu Jul 26 
05:45:09 EDT 2012 M:x86_64 N:hz867c1n7 
process id: 25547 
thread id : 46979170167104 (0x2ABA30BFE940) 
</Header> 
<SignalDetails> 
<Siginfo_t length="128"> 
Signal #11 (SIGSEGV): si_addr is 0x0000000000000000, si_code is 
0x00000080 (SI_KERNEL:Send by kernel.) 
</SignalDetails> 
<ResourceLimits> 
Data seg top [sbrk(0)] = 0x0000000002704000 
Cur cpu time limit (seconds)  = 0xFFFFFFFF 
Cur file limit (bytes)  = 0xFFFFFFFF 
Cur data size (bytes)  = 0xFFFFFFFF 
Cur stack size (bytes) = 0x00A00000 
Cur core size (bytes)  = 0x3D090000 
Cur nofiles (descriptors)  = 0x0000FFFE 
Cur memory size (bytes)  = 0xFFFFFFFF 
</ResourceLimits> 
<Registers> 
   rax 0x0000000000000000  rbx 0x6f743c3e656d6974 
   rcx 0x0000000000006f63  rdx 0x0000000000000024 
 
rbp 0x6d6d6f635f6c6174  rsp 0x00002aba30bf23f8 
   rsi 0x00002aba30bf2344  rdi 0x00002aba30bf22c0 
rflags 0x0000000000010202  rip 0x00002aaaabff567f 
   r8  0x0000000000000002  r9  0x0000000000000002 
   r10 0x00002aaab3b90406  r11 0x000000000041830a 
   r12 0x3e656d69745f7469  r13 0x6c61746f742f3c30 
   r14 0x0000000000000000  r15 0x5f74696d6d6f635f 
</Registers> 
<POFDisassembly> 
 _Z16sqlex_find_groupPc14sqlo_mem_descr + 0x0203 
(/var/ibmdb2/db2inst1/sq 
llib/lib64/libdb2e.so.1) 
 
        0x00002AAAABFF567F : C3BD06000020EBE7 
</POFDisassembly> 
<StackTrace> 
 
 
Diag log  entry 
 
 
2015-01-23-10.14.29.098656-300 I953892E519         LEVEL: Severe 
PID     : 25547                TID  : 46979170167104PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE 
APPHDL  : 0-42121              APPID: 
10.184.115.248.36738.1501231514 
AUTHID  : ETLMIGP 
EDUID   : 232                  EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, RAS/PD component, 
pdEDUIsInDB2KernelOperation, probe:180 
MESSAGE : Stack analysis failed due to incomplete  'StackTrace' 
section in trap 
          file. 
 
2015-01-23-10.14.29.099039-300 I954412E527         LEVEL: Severe 
PID     : 25547                TID  : 46979170167104PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE 
APPHDL  : 0-42121              APPID: 
10.184.115.248.36738.1501231514 
AUTHID  : ETLMIGP 
EDUID   : 232                  EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, RAS/PD component, 
pdEDUIsInDB2KernelOperation, probe:190 
MESSAGE : Stack analysis failed, which implies stack corruption 
or failed to do 
          'stack walk'. 
 
 
====================================

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V9.7 Fix Pack 11                                  * 
****************************************************************

Reduce the number of groups for the user id

Upgrade to V9.7 Fix Pack 11

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

27.01.2015
13.10.2015
13.10.2015

9.7.FP11