search cancel

Applications Manager Slowness

book

Article ID: 88635

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Applications Manager Slowness

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

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;