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
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.