Wednesday, August 3, 2016

AS400 Job Queue Not Processing Job

Scenario -  One of Job Queue is not processing Jobs and All Jobs in that Queue is going into wait status.

How to recover without restarting.  This can be done by fooling AS400 and creating same queue with higher sequence number.

In my case Queue EDIJOB is not processing any Job in JDE. All Job in EDIJOB queue are in wait status. All other Queue are processing Jobs.

1. Find Sequence number of EDIJOB in QGPL library

DSPSBSD SBSD(QBATCH)

do 6 - Job queue entries
Note down SEQ Number for EDIJOB.

2.  Create new JOBQ EDIJOB in QUSRSYS library

CRTJOBQ JOBQ(QUSRSYS/EDIJOB) TEXT('Temporsry EDIJOB Queue')

3. Add EDIJOB Queue to QBATCH Subsystem
Assign Sequence Number above original Jobqueue

ADDJOBQE SBSD(QBATCH) JOBQ(QUSRSYS/USSOP1) SEQNBR(37)

4. Run Job from JDE in EDIJOB and verify Jobs are processing.

--------------------------------------------------------------------------------------------------------

After JDE Maintenance after hour/weekend delete new Jobqueue

 DLTJOBQ JOBQ(QUSRSYS/EDIJOB)