Performance: DPR_Journal_CleanUp and QBM_PDeleteBulk (4327109)

Execution of the process "DPR_Journal_CleanUp" and the stored procedure, "QBM_PDeleteBulk", takes too long.

The process "DPR_Journal_CleanUp" executes the procedure "QBM_PDeleteBulk" to delete the old entries from DPRJournal.

The main purpose of "QBM_PDeleteBulk" is to delete a high count of objects in partitions to avoid big transactions (this would block other processes).

But because the Job Parameter "WithoutTransaction" is not active, the complete execution is wrapped in a big transaction.

WORKAROUND

The Job Parameter WithoutTransaction should be enabled.  Double click the parameter to highlight the blue check-mark and commit the change to database.



STATUS

If you require this immediately corrected, please contact Support for a hotfix, referencing the defect ID 31584.