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
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.