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
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.