Re: who and when held the job queue?

[Ed Fishel <edfishel@xxxxxxxxxx>]

Rob Berendt wrote on 05/08/2007 07:58:46 AM:

> I don't think you can, except by analyzing certain joblogs.  You can pin
> down activity by the following:
> CHGOBJAUD OBJ(ROB/ONEATATIME) OBJTYPE(*JOBQ) OBJAUD(*CHANGE)
> 08:49:35 - HLDJOBQ JOBQ(ROB/ONEATATIME)
> 08:49:38 - RLSJOBQ JOBQ(ROB/ONEATATIME)
> 08:51:27 - SBMJOB CMD(DSPOBJD OBJ(ROB/ONEATATIME) OBJTYPE(*JOBQ)
> OUTPUT(*PRINT)) JOBQ(ROB/ONEATATIME)
> DSPJRN JRN(QAUDJRN) FROMTIME(050807 084934) JOB(435313/ROB/ROBHQ1)
> Sequence  Code  Type  Object      Library     Job         Time
> 59163479   T     ZC                           ROBHQ1       8:49:35
> 59163510   T     ZC                           ROBHQ1       8:49:39
> 59165589   T     ZC                           ROBHQ1       8:51:27
>
> Peter Sazbo wrote on 05/08/2007 02:02:45 AM:
>
> > How can I investigate when and which user or job held or released a job
> > queue?

The information you are looking for is in the security audit journal. If
your system is at V5R4 you can use the new CPYAUDJRNE command to copy the
audit information. Once the file has been created use your favorite query
to select and print the fields you are interested in. If you are on an
earlier release you should first use CRTDUPOBJ OBJ(QASYZCJ5) FROMLIB(QSYS)
OBJTYPE(*FILE) TOLIB(QTEMP) to create a physical file in QTEMP and then use
DSPJRN with OUTFILFMT(*TYPE5) to copy the ZC audit records to that file.
The remaining steps to display the data will be the same as for V5R4.

The answer to this specific question can be found in the Access Type field.
The table at the end of Appendix F of the Security Reference manual
indicates that Access Type will be 24 when the job queue is held and 37
when it is released.

Ed Fishel,
edfishel@xxxxxxxxxx