This article is now available in our new knowledge base: IBMi Troubleshooting - Output Queues and Spooled files
Applies to: IBMi Servers
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.
If a job ends abnormally, error messages are written to spooled files on an 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:
- 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)