Spool File Deletion

215 pts.
AS/400 Spool Files
Spool files
How do I delete Spool Files of a particular user for a specified date range. For eg. Spool Files of Rahul needs to be deleted for dates between 01/01/2009 and 30/07/2009. Kindly help since the Spool File Count for many users ranges from 4152 to 86592 and the same are not required & can be deleted. Deleting them using Option 4 on Work with Output Queue is a tedious task.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Try these:


Discuss This Question: 6  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • graybeard52
    Google for DLTOLDSPLF on the web. This is (was) a free urility that could delete or archive spool files based on date, queues, etc.
    3,115 pointsBadges:
  • Brijesh

    The Delete Old Spooled Files (DLTOLDSPLF) program is a program that can be used to delete old spooled files from an IBM System i products system. It also can be used to provide an example on how to code the Print and Spool APIs. DLTOLDSPLF No Longer Needed in V5R4M0 (5.4 or R540) i5/OS and Above because of new support for setting an expiration date on spooled files. After the expiration date is reached on the spooled files, they become eligible for removal from the system by the Delete Expired Spooled Files (DLTEXPSPLF) command.

    Check the similar discussion delete a user’s spoolfile in batch by date rangeDeleting outq spool files 

    Hope this helps.

    14,450 pointsBadges:
  • pdraebel
    I have a program that uses the QUSLSPL API to clean up my spoolfiles. It coul dbe a good starting point for your cleanup program.
    For info and examples on the API, just search the web.
    7,545 pointsBadges:
  • ToddN2000
    The old school way was to do this in a CL program. First a WRKSPLF SELECT(TSTXML) OUTPUT(*PRINT) then CPYSPLF to a flatfile. Then RCVF the record, substring out the info, and if it meet the conditions, DLTSPLF and pass the parms jile /user/jobname/job#/ spool#.
    135,525 pointsBadges:
  • lance2221357
    Could you used iseries Navigator ?
     Workoutq :  Filter user & date & status. 
                       Select more spool files delete at one times.
    270 pointsBadges:
  • WoodEngineer
    To help with this on a regular bases, enter command "GO CLEANUP" and be sure it is running.  This takes care of a lot of older items no longer needed. 
    8,225 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: