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.