Detailed Description and Symptoms:
Applicable to Applications Manager Versions: v7.1, v8.0
After deleting jobs from the so_job_queue you begin to see slowness in the processing of jobs?
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;