IBMi Troubleshooting - Output Queues and Spooled files

Applies to: IBMi Servers

Preface

Working with Output Files – Spooled Files

Output queues are areas where printer output files (also called spooled files) wait to be processed and sent to the printer.

Printer output is created either by the system or by the user using a print file.

A spooled file holds output data until it can be printed. The spooled file collects data from a device until a program or device is able to process the data.
A program uses a spooled file as if it were reading from or writing to an actual device. This is input and output spooling.

Details

If a job ends abnormally, error messages are written to spooled files in output queue, QEZJOBLOG. These files are very helpful in tracking down database access problems.

WRKSPLF SELECT(<user_profile>)command to view messages for jobs that are no longer running.

Where <user_profile> is the user profile under which the job was running.

Specify option 5 (Display) in front of the file you want to view.

Zend Products are using the following user profiles:

• ZENDADMIN
• QTMHHTTP
• NOGROUP
• MYSQL

Create a new OUTQ 

• Most of the users created by Zend are using the jobd  QGPL/QDFTJOBD
  

  CHGJOBD JOBD(QDFTJOBD) OUTQ(*USRPRF) TEXT(' Default job description')

• You can also change the users profiles listed above as needed.

  CHGUSRPRF USRPRF(ZENDADMIN) OUTQ(QGPL/ZENDOUTQ) – run the command for the users listed above.

• When ending the Zend SBS a joblog will be created in the default IBMi OUTQ -> to include this log run the command ->
  

  CHGSPLFA FILE(QPJOBLOG) JOB(QSECOFR/ZSJAVA_BRG)OUTQ(QGPL/ZENDOUTQ)
  CHGSPLFA FILE(QPRINT) JOB(QTMHHTTP/ZSMONMNG) OUTQ(QGPL/ZENDOUTQ)
  CHGSPLFA FILE(QPRINT) JOB(QTMHHTTP/ZSDAEMON) OUTQ(QGPL/ZENDOUTQ)
  CHGSPLFA FILE(QPRINT) JOB(QTMHHTTP/ZSJOBQMNG) OUTQ(QGPL/ZENDOUTQ)
  CHGSPLFA FILE(QPRINT) JOB(QTMHHTTP/ZSDEPLMNG) OUTQ(QGPL/ZENDOUTQ)
• Same for ZENDDBi MySQL:
  CHGSPLFA FILE(QPRINT) JOB(MYSQL/ZENDDBID) OUTQ(QGPL/ZENDOUTQ)