Processes Stuck at Queued
There are a number of reasons why a process might be stuck at queued.
The most obvious is that the process scheduler is down (check the Servers tab in the process monitor). If that's not the issue, check the following tables:
- PSPRCSRQST
- PSPRCSQUE
- PSPRCSPARMS
The row count should be the same in both tables. If one is out of sync with the other, then it can help to remove orphaned instances in of the tables.
A few other things to check:
- Another process may be queued and blocking subsequent processes from running. That process will need to be fixed first.
- Any database errors e.g. Tablespace full or disk full
- Check
Restarting the process scheduler (and master scheduler if you have) and clearing the process scheduler cache will also fix a number of issues.
Remember too that restartable Application Engines will abended with an All Processing Suspended message.
The following query will give you a summary of the requested processes by process status for further troubleshooting.
select
RQST.RUNSTATUS,
RQST.PRCSTYPE,
(
select XLAT.XLATLONGNAME
from PSXLATITEM XLAT
where XLAT.EFFDT = (
select max(XLAT_ED.EFFDT)
from PSXLATITEM XLAT_ED
where XLAT_ED.FIELDNAME = XLAT.FIELDNAME
and XLAT_ED.FIELDVALUE = XLAT.FIELDVALUE
) and XLAT.FIELDNAME = 'RUNSTATUS'
and XLAT.FIELDVALUE = RQST.RUNSTATUS
) as RUNSTATUS_XLAT,
count(RQST.PRCSINSTANCE) as TOTAL_PROCESSES,
min(RUNDTTM) as FIRST_OCCURRED,
max(RUNDTTM) as LAST_OCCURRED
from PSPRCSRQST RQST
group by RQST.RUNSTATUS, RQST.PRCSTYPE
order by RUNSTATUS_XLAT, RQST.PRCSTYPE
No Comments