SAP Knowledge Base Article - Preview

2690093 - System Measurement: Job (RSUVM007) does not end - SAP ASE for Business Suite

Symptom

  • RSUVM007 is very slow - and takes days to complete on SAP systems running on SAP ASE.
  • The following slow query is identified via ST05 / ST12 / DBACockpit->Processes->Details->SQL Statement while the job is in progress:

SELECT DISTINCT "REF" ."MANDT" , "REF" ."ORGLOGSYS"
FROM "/SAPSLL/CUHD" "CU"
INNER
JOIN "/SAPSLL/CORREF" "REF"
ON "REF" ."MANDT" = "CU" ."MANDT"
AND "REF" ."GUID_MOBJ" = "CU" ."GUID_CUHD"
INNER
JOIN "/SAPSLL/CUHDSTA" "STA"
ON "STA" ."MANDT" = "CU" ."MANDT"
AND "STA" ."GUID_MOBJ" = "CU" ."GUID_CUHD"
WHERE "CU" ."MANDT" = ?
AND "CU" ."CDTYP" = ?
AND "CU" ."CRTSP" BETWEEN ? AND ?
AND "STA" ."MOBJT" = ?
AND "REF" ."QALREF" = ?
AND "REF" ."MOBJT" = ?
AND ( "STA" ."STSPL_AGG" IN ( ? , ? , ? ) OR "STA" ."STEMB_AGG" IN ( ? , ? , ? ) OR "STA" ."STLDT_AGG" IN ( ? , ? , ? ) OR "STA"
."STEHS_AGG" IN ( ? , ? , ? ) )

 

  • Following Z-indexes are created but do not help in improving performance: 

on /SAPSLL/CUHD - columns: MANDT, CDTYP, CRTSP
on /SAPSLL/CORREF - columns: QALREF MOBJT

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP NetWeaver 7.4

Keywords

RSUVM007, concurrency_opt_threshold, "System Measurement", slow, /SAPSLL/CUHD, /SAPSLL/CORREF , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.