SAP Knowledge Base Article - Preview

3375046 - DB6- db2diag.log reports continuous SQLD_INTRP "USER INTERRUPT DETECTED" in Db2 version 11.5

Symptom

The db2diag.log entries contain "SQLD_INTRP "USER INTERRUPT DETECTED" errors

2023-08-09-XXXX                                                LEVEL: Error
PID     : XXXX                 TID : XXXX                     PROC : db2sysc 0
INSTANCE: XXXX            NODE : 000            DB   : XXXX
APPHDL  : XXXX                APPID: XXXX 
UOWID   : XXXX            ACTID: 4              
AUTHID  : XXXX                HOSTNAME: XXXX

FUNCTION: DB2 UDB, sort/list services, sqlsmergerec, probe:2607
MESSAGE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT DETECTED"
          DIA8003C The interrupt  has been received.
DATA #1 : SQLS_SLDES_SLESTATUS, PD_TYPE_SQLS_SLDES_SLESTATUS, 8 bytes
x0000000008458EA0
         - SQLS_IDENT_16BIT
         - SQLS_FAILED_SORT
         - SQLS_EOMRG
         - SQLS_USENEWDVAL
         - SQLS_USE_BINSORT
         - SQLS_LPASS
         - SQLS_SHARED_MEM
         - SQLS_MONITOR
         - SQLS_OVERFLOW
         - SQLS_TABLE_IN
DATA #2 : Dumped object of size 3776 bytes at offset 0, 40 bytes
/db2/XXXX /db2dump/0000000000000.dump.bin
DATA #3 : SQLS_MBUFS, PD_TYPE_SQLS_MBUFS, 1744 bytes
SQLS_MBUFS: Address:0x7faff282a828, Size:x6d0, Size:1744
   x0698    pValues                       0x7fb022b77820
   x06A0    recptr                        0x7fb022b771a0
   x06C0    records                       1048
   x06A8    recordBuffer                  0x7fb022b771a0
   x06B0    iNumBufferedRecords           0
   x06B8    mergeFlags                    x00000002
            - SQLS_CALLED_FETCH_NEXT_TEMP_REC
   x06C8    sortNum                       0
   x06CC    bufferedFetchRC               -2147221501

Other errors may include:

FUNCTION: DB2 UDB, common communication, sqlcctcptest, probe:11
MESSAGE : Detected client termination
DATA #1 : Hexdump, 2 bytes
0x00007F5816BFA856 : XXXX                     


FUNCTION: DB2 UDB, base sys utilities, sqeAgent::AgentBreathingPoint, probe:10
CALLED  : DB2 UDB, common communication, sqlcctest
RETCODE : ZRC=0x00000036=54


Read more...

Environment

Db2 LUW IBM

Product

SAP ERP 6.0

Keywords

 Level, , KBA , BC-DB-DB6-DBA , Database Administration , Known Error

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.