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.