SAP Knowledge Base Article - Preview

2921568 - DB2 crash while executing query with inlist predicates

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

SAP ERP 6.0

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.