Symptom
- Db2 crash while executing query with inlist predicates.
- LEVEL: Severe
PID : 10000 TID : 123456789 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000 DB : SID
APPHDL : 0-22222 APPID:
AUTHID : SAPSID HOSTNAME: saphost
EDUID : 000 EDUNAME: db2agent (SID) 0
FUNCTION: DB2 UDB, RAS/PD component, pdResilienceIsSafeToSustain, probe:800
DATA #1 : String, 37 bytes
Trap Sustainability Criteria Checking
DATA #2 : Hex integer, 8 bytes
0x0000000400011000
DATA #3 : Boolean, 1 bytes
true
2020-01-01-01.01.01 I180586414E603 LEVEL: Severe
PID : 10000 TID : 123456789 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000 DB : SID
APPHDL : 0-22222 APPID:
AUTHID : SAPSID HOSTNAME: saphost
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : RDS UCINTFC: pStatementText =
DATA #1 : Hexdump, 275 bytes
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: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL10054
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: -
Checking the trap files:
<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00007FFFEC934205 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0385
(/db2/db2sid/sqllib/lib64/libdb2osse.so.1)
0x00007FFFEC933E0C ossDumpStackTraceV98 + 0x002c
(/db2/db2sid/sqllib/lib64/libdb2osse.so.1)
0x00007FFFEC92EF0D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00fd
(/db2/db2sid/sqllib/lib64/libdb2osse.so.1)
0x00007FFFF2DD3194 sqlo_trce + 0x0404
(/db2/db2sid/sqllib/lib64/libdb2e.so.1)
0x00007FFFF2E286CA sqloEDUCodeTrapHandler + 0x027a
(/db2/db2sid/sqllib/lib64/libdb2e.so.1)
0x0000003D9920F710 address: 0x0000003D9920F710 ; dladdress: 0x0000003D99200000 ; offset in lib: 0x000000000000F710 ;
(/lib64/libpthread.so.0)
0x00007FFFF0CDAC36 _Z31sqlnr_qsort_compare_inlist_expsPKvS0_ + 0x0006
(/db2/db2sid/sqllib/lib64/libdb2e.so.1)
Read more...
Environment
- Db2 Linux Unix and Windows 10.5
Product
Keywords
inlist, sqlrr_prepare, qsort , KBA , BC-DB-DB6-DBA , Database Administration , 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