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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.