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:
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
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