Symptom
Db2diag.log shows multiple entries for the below error message
=========================================
<DATE Timestamp> LEVEL: Error
PID : ****** TID : ******* PROC : db2sysc 0
INSTANCE: db2<SID> NODE : 000 DB : <SID>
APPHDL : 0-1103 APPID: *******************
AUTHID : SAPDAT HOSTNAME: sap<SID>
EDUID : 133235 EDUNAME: **************
FUNCTION: DB2 UDB, sort/list services, sqlsFetchNextTempRecord, probe:504
MESSAGE : ZRC=0x80130003=-2146238461=SQLS_INTRP "Interrupt. User Cancel."
DIA8003C The interrupt has been received.
DATA #1 : Codepath, 8 bytes
1
DATA #2 : ZRC, PD_TYPE_ZRC, 4 bytes
0x80130003
DATA #3 : SQLS_MBUFS, PD_TYPE_SQLS_MBUFS, 1720 bytes
SQLS_MBUFS: Address:a000313747cd0f8, Size:x6b8, Size:1720
x0688 pValues a000313748187e0
x0690 recptr a000313748186d0
x06AC records 872164
x0698 recordBuffer a00031374818180
x06A0 iNumBufferedRecords 1
x06A8 mergeFlags x00000002
- SQLS_CALLED_FETCH_NEXT_TEMP_REC
x06B0 sortNum 0
x06B4 bufferedFetchRC 0
Read more...
Environment
- Db2 LUW 10.1, 10.5
- SAP CRM 7.0
- Netweaver 7.01 / 740
- SAP EHP1
Product
Keywords
Wrong SQL plan, RC:-2146238461, SQLSFETCHNEXTTEMPRECORD, IT09843, IT08746, SQL statement, Performance , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.