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.
SAP Knowledge Base Article - Preview