Symptom
Processing messages (SMQ1) shows large queues after Kernel upgrade to 753_REL.
The following shortdump is found in ST22.
Category ABAP Programming Error
Runtime Errors TIME_OUT
ABAP Program SAPLQOWK
Application Component BC-MID-RFC
Time limit exceeded
What happened?
Program "SAPLQOWK" has exceeded the maximum uninterrrupted runtime and has therefore been terminated.
"TIME_OUT"
"SAPLQOWK" bzw. LQOWKU07
"HANDLE_QUEUES"
Outbound queues getting stuck on statement for table TRFCQOUT.
SELECT /* FDA WRITE */ DISTINCT "TRFCQOUT"."ARFCIPID", "TRFCQOUT"."ARFCPID", "TRFCQOUT"."ARFCTIME", "TRFCQOUT"."ARFCTIDCNT", "TRFCQOUT"."QNAME", "TRFCQOUT"."DEST", "TRFCQOUT"."QCOUNT", "TRFCQOUT"."QSTATE" FROM "TRFCQOUT", ( SELECT * FROM TABLE( SAPTOOLS.
MEMORY_TABLE( CAST( ? AS BLOB( 2G )) ) CARDINALITY 1 ) AS "t_00" ( "C_0" VARCHAR(72) , "C_1" VARCHAR(96) ) GROUP BY ( "C_0", "C_1") ) AS "t_00" WHERE "TRFCQOUT"."MANDT" = ? AND "TRFCQOUT"."QNAME" = "t_00"."C_0" AND "TRFCQOUT"."DEST" = "t_00"."C_1" AND
"TRFCQOUT"."NOSEND" = ? WITH CS
DBACOCKPIT -> Diagnosis -> Explain shows that there is indexscan on index TRFCQOUT~3 with key columns=2 for this statement.
Read more...
Environment
Db2 Linux Unix and Windows
Product
Keywords
MSJOIN, NLJOIN , 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