SAP Knowledge Base Article - Preview

3457711 - Db2 10.5 crashes with Signal #11 trap.

Symptom

The Db2 database crashed Signal #11 trap showing the following stack:
===================================================================================
<StackTrace>
-------Frame------ ------Function + Offset------
0x090000000BA1A488 sqlno_generate_zzjn_plans__FP13sqlno_globalsP11sqlno_qpcsb + 0x517C
0x090000000BA12200 sqlno_generate_zzjn_plans__FP13sqlno_globalsP11sqlno_qpcsb + 0x2F4
Stack traceback unavailable.
</StackTrace>
===================================================================================


In this case the stack was reported in file '12714150.119773.000.trap.txt'.

Additionally,  the AIX 'errpt -a' output showed the following error and stack:
===================================================================================
CORE FILE NAME
/db2/PE1/db2dump/FODC_Trap_2024-03-10-05.37.32.226499_0000/12714150.000.core/core
PROGRAM NAME
db2sysc
STACK EXECUTION DISABLED
           0
COME FROM ADDRESS REGISTER
??
PROCESSOR ID
  hw_fru_id: 0
  hw_cpu_id: 78

ADDITIONAL INFORMATION
sqlno_gen 517C
sqlno_gen 4D20
sqlno_gen 2F8
??
??
sqlno_gen 10C
sqlno_pla 2D14
sqlno_pla 2864
??
sqlno_pla 24
sqlno_eac 1074
sqlno_wal F8
sqlno_eac D30
sqlno_top 10C
sqlno_eac 674
sqlno_sca 790
sqlno_pla D8
sqlno_pla 11D8
sqlno_pla 1320
sqlno_exe 694
sqlnn_cmp 12DC
sqlnn_cmp 5C
sqlra_com 850
sqlra_fin 10C8
sqlra_get B4C
sqlrr_pre 19C
sqljsPars E018
@72@sqljs 7E8
@72@sqljs 7E8
@72@sqljs 3DC
@72@sqljs AC
@72@sqljs 5F8
RunEDU__8 48258
RunEDU__8 128
EDUDriver 130
sqloEDUEn 398
_pthread_ F4
??

Symptom Data
REPORTABLE
1
INTERNAL ERROR
0
SYMPTOM CODE
PCSS/SPI2 FLDS/db2sysc SIG/11 FLDS/sqlno_gen VALU/517c FLDS/sqlno_pla
===================================================================================


The db2diag.log reports:
===================================================================================
2024-03-10-05.37.32.708382-240 I281793288A597       LEVEL: Error
PID     : 12714150             TID : 119773         PROC : db2sysc 0
INSTANCE: db2sap               NODE : 000           DB   : PE1
APPHDL  : 0-507                APPID: 111.111.111.111.35228.231226224646
AUTHID  : SAPPE1               HOSTNAME: saphost
EDUID   : 119773               EDUNAME: db2agent (PE1) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:1
MESSAGE : Error in agent servicing application with coor_node:
DATA #1 : Hexdump, 2 bytes
0x0A000001FF00E610 : 0000                                       ..

2024-03-10-05.37.32.720986-240 I281801084A384       LEVEL: Event
PID     : 15139042             TID : 1              PROC : db2vend
INSTANCE: db2sap               NODE : 000
HOSTNAME: saphost
EDUID   : 1
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScriptDirect, probe:10
START   : Invoking /db2/db2sap/sqllib/bin/db2cos_trap from oper system services sqloEDUCodeTrapHandler

2024-03-10-05.39.14.734540-240 I281812070A222     LEVEL: Severe
PID:12714150 TID:119773 NODE:000 Title: **** DRDA ASCB ****
Dump File:/db2/PE1/db2dump/FODC_Trap_2024-03-10-05.37.32.226499_0000/12714150.119773.000.dump.bin

2024-03-10-05.39.14.740258-240 I281825044A1023      LEVEL: Severe
PID     : 12714150             TID : 119773         PROC : db2sysc 0
INSTANCE: db2sap               NODE : 000           DB   : PE1
APPHDL  : 0-507                APPID: 111.111.111.111.35228.231226224646
AUTHID  : SAPPE1               HOSTNAME: saphost
EDUID   : 119773               EDUNAME: db2agent (PE1) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:250
MESSAGE : ZRC=0x87120007=-2028863481=SQLR_SEVERE_PGM_ERROR
          "Severe programming error"
          DIA8516C A severe internal processing error has occurred.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: 437   sqlerrml: 1
 sqlerrmc: 1
 sqlerrp : SQLNO181
 sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3) 0x00000000
           (4) 0x00000000      (5) 0x00000000      (6) 0x00000000
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)    
           (7)      (8)      (9)      (10)        (11)     
 sqlstate:      

2024-03-10-05.39.14.743171-240 I281832590A605       LEVEL: Severe
PID     : 12714150             TID : 119773         PROC : db2sysc 0
INSTANCE: db2sap               NODE : 000           DB   : PE1
APPHDL  : 0-507                APPID: 111.111.111.111.35228.231226224646
AUTHID  : SAPPE1               HOSTNAME: saphost
EDUID   : 119773               EDUNAME: db2agent (PE1) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:550
RETCODE : ZRC=0x87120007=-2028863481=SQLR_SEVERE_PGM_ERROR
          "Severe programming error"
          DIA8516C A severe internal processing error has occurred.

2024-03-10-05.39.18.874207-240 E281855353A1262      LEVEL: Severe
PID     : 12714150             TID : 119773         PROC : db2sysc 0
INSTANCE: db2sap               NODE : 000           DB   : PE1
APPHDL  : 0-507                APPID: 111.111.111.111.35228.231226224646
AUTHID  : SAPPE1               HOSTNAME: saphost
EDUID   : 119773               EDUNAME: db2agent (PE1) 0
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:90
MESSAGE : ADM14011C  A critical failure has caused the following type of error: 
          "Trap". The DB2 database manager cannot recover from the failure. 
          First Occurrence Data Capture (FODC) was invoked in the following 
          mode: "Automatic". FODC diagnostic information is located in the 
          following directory: 
          "/db2/PE1/db2dump/FODC_Trap_2024-03-10-05.37.32.226499_0000/".
DATA #1 : Signal Number Recieved, 4 bytes
11
DATA #2 : Siginfo, 64 bytes
0x0A000001FF00EDC0 : 0000 000B 0000 0000 0000 0033 0000 0000    ...........3....
0x0A000001FF00EDD0 : 0000 0000 0000 0000 0000 0000 0000 0010    ................
0x0A000001FF00EDE0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x0A000001FF00EDF0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
===================================================================================


Read more...

Environment

  • DB2 v10.5 fixpack 10 or earlier

Product

SAP enhancement package 7 for SAP ERP 6.0

Keywords

Db2 , db2sysc , DIA8516C sqlno_generate_zzjn_plans__FP13sqlno_globalsP11sqlno_qpcsb , FODC_Trap , core , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.