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

• 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

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

RSUVM007, concurrency_opt_threshold, "System Measurement", slow, /SAPSLL/CUHD, /SAPSLL/CORREF , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem