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.
SAP Knowledge Base Article - Preview