Applications Manager Slowness

Document ID : KB000088635
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Applications Manager Slowness
Resolution:

Applicable to Applications Manager Versions:  v7.1, v8.0


Detailed Description and Symptoms:

After deleting jobs from the so_job_queue you begin to see slowness in the processing of jobs?



Investigation:

Perform the following SQL and send the results to support for proper diagnosis and repair.?

 

select so_status_name, count(*) NumberOfValues from so_job_history where so_status_name in ('INITIATED','RUNNING','STAGED','STAGED_PW','QUEUE WAIT','PRED WT HOLD','PRED WAIT','LAUNCH ERROR','KILLING','DATE PENDING','CONDITN WAIT','AGENT WAIT') group by so_status_name;