Job Restarts take many minutes to activate

Document ID : KB000093629
Last Modified Date : 16/05/2018
Show Technical Document Details
Issue:
When a jobs fails and is restarted through Modify > task, it takes several minutes to actually activate and show up in the activity window.



 
Cause:
There are errors on the database side that is causing the slow activation, particularly on the AH table. 

A common message that should be seen in the logs is this:
20180426/221247.795 - U00003434 Server routine 'JPAKTJ_R/AKTX' required '4' minutes and '9,614' seconds for processing.

As this server routine specifically has to do with job activation. 
Resolution:
-Ensure maintenance is done regularly
-Ensure that fragmentation is low on the AH table (we recommend under 30%)
-Make sure there are no Oracle restore points on the database. If there are, then delete them - this can cause extra stress on the database.