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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.