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