Greetings.  Yea. the Javatool box, or jtopen has a lot of options, and you
can and should be able to access everything you mention below, and then
you would have to call to remove things.  There are no automated ways in
the toolbox to clean up spool files.
BUT, with the very latest IBM i Services, there is a new service that may
be of interest. A new services was delivered in the SYSTOOLS library that
allows you to specify the outQ, user and date for spool files that you
want to delete from the system, and this service will clean them up for
Here is an example of that SQL 
call Systools.Delete_Old_Spooled_Files(Delete_Older_Than =>
   current date - 30 days, P_User_Name => 'TIMMR',
   Preview => 'YES')
Latest database Group will provide you with this nifty feature. 

Tim Rowe, timmr@xxxxxxxxxx
Business Architect Application Development & Systems Management for IBM i
IBM i ISV Council
IBM i Development Lab, Rochester, MN
(507) 253-6191 (Tie) 553-6191

----- Original message -----
From: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
Sent by: "JAVA400-L" <java400-l-bounces@xxxxxxxxxxxxxxxxxx>
To: Java Programming on and around the IBM i
Subject: [EXTERNAL] Re: Query status of spool file in outqueue
Date: Tue, May 19, 2020 9:54 AM

The answer to the first is probably yes - there are variations of what I
sent that should give you what you want - google for it.

as for the Java toolkit, as I understand it, you can do just about
anything with it. You'd probably want some command to run, so see what
functions are there for running commands. Another Google for you to do,


On 5/19/2020 8:27 AM, maxbobzien--- via JAVA400-L wrote:
> Perfect, thanks!
> Is there also a way to check for out queues that are in status MSGW?
> And does the Java toolkit offer any options to delete spool files in
SENDING status or clear out queues in MSGW status?
> Max
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [1] ;
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [2] ;.

Help support by shopping at with our affiliate
link: [3] ;



Visible links

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].