Re: "Phantom" Spool file entries

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

That was the one I was using originally Michael - but it only deleted a few. I could see no error messages so I have no idea why ot failed.


Jon Paris
Jon.Paris@xxxxxxxxxxxxxx



> On Nov 11, 2025, at 9:22 AM, Michael Mayer via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
>
> Thought I'd throw this out there ...
> https://www.ibm.com/docs/en/i/7.4.0?topic=services-delete-old-spooled-files-procedure#rzajqprocdeletesplf__title__2
>
> There is also Delete Spooled File info on my blog on the "IBM i Helpful Tips No Category" page towards the bottom of the page.
>
>
>
> Respectfully, 
> Michael Mayer
> IBM i on Power System Admin
> ERMCO-ECI
> 2225 Industrial Rd
> Dyersburg, Tennessee 38024
> Cell, Office and Text Messages: 518.641.8906
> Email: michael.mayer@xxxxxxxxxxxxx
> https://www.ermco-eci.com   
> https://ermcopower.com/
> IBM i Award Winning Blog Site: https://ibmireference.blogspot.com
> Awarded IBM 2024/2025 Advocate, Contributor, Influencer and IBM i Ready Badges.     
>
>
>
>
>
>
>
> Today's Topics:
>
>   1. Re: "Phantom" Spool file entries (Jon Paris)
>
> ----------------------------------------------------------------------
>
> message: 1
> date: Mon, 10 Nov 2025 17:43:40 -0500
> from: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
> subject: Re: "Phantom" Spool file entries
>
> Thanks, Bryan - didn't think of that one.
>
> Hasn't got rid of all of them - still a few outliers, but since they respond to a good old option 4, it is not a big problem.
>
>
> Jon Paris
> Jon.Paris@xxxxxxxxxxxxxx
>
>
>
> > On Nov 10, 2025, at 5:36?PM, Bryan Dietz <bdietz400@xxxxxxxxx> wrote:
> >
> > maybe this would do it:
> >
> > Start Spool Reclaim (STRSPLRCL)
> >
> > Bryan
> >
> >
> > Jon Paris wrote on 11/10/2025 4:15 PM:
> > > I'm trying to clear up thousands of old spool files.
> > > Tried using SQL to delete anything prior to 2025, and some disappeared, but nowhere near as many as should have. Used option 4 to delete a bunch of the remainder to see if there would be some error message. Nope - nothing.
> > > So I decided to hell with it and used CLROUTQ against those queues that I knew contained nothing that was needed.  That worked - kinda.
> > > I now have this situation in WRKOUTQ:
> > > Queue          Library           Files
> > > QPFROUTQ       QGPL                  0
> > > QPRINT         QGPL               1731
> > > QPRINTS        QGPL                  0
> > > But if I take option 5 against the QPRINT entry, instead of seeing 1,731 files, I see 4! And those 4 are for currently active jobs so all normal. But where the heck are the other 1,727 that WrKOUT shows?
> > > Similar situation with QEZDEBUG, and QEZJOBLOG.
> > > Any ideas on the cause and how to get the numbers to make sense?
> > > Jon Paris
> > > Jon.Paris@xxxxxxxxxxxxxx
> >
> > --
> >
> > -- .
> > Bryan
> >
> > --
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.