Spool File Deletion

Haaiderali

215 pts.

Tags:

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.

Asked: August 28, 2009 8:39 AM Last updated: December 15, 2014 7:17 PM

Answer Wiki

Last updated: December 15, 2014 7:17 PM GMT

Michael Tidmarsh65,610 pts.
History
Contributors
- Ordered by most recent
- Michael Tidmarsh65,610 pts.
- Teandy5,860 pts.

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 Aug 30, 2009 12:02 AM GMT

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:

report
Brijesh Dec 3, 2014 6:47 PM GMT

Hi,

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 range, Deleting outq spool files
Hope this helps.

14,450 pointsBadges:

report
pdraebel Dec 4, 2014 3:12 PM GMT

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:

report
ToddN2000 Dec 5, 2014 5:03 PM GMT

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#.

119,370 pointsBadges:

report
lance2221357 Dec 8, 2014 2:57 AM GMT

Could you used iseries Navigator ?
Workoutq : Filter user & date & status.
Select more spool files delete at one times.

270 pointsBadges:

report
WoodEngineer Dec 8, 2014 4:37 PM GMT

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,170 pointsBadges:

report