×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
message: 4
date: Wed, 10 Mar 2021 10:39:50 -0800
from: "James H. H. Lampert" <jamesl@xxxxxxxxxxxxxxxxx>
subject: Is there a way to mass-delete several hundred spool files?
Is there an easy, non-tedious way to mass-delete a few hundred spool
files (all with the same user, jobname, file, and queue)?
Something less tedious than going into WRKSPLF and hammering away at "4"
and "PgDn"?
YES!!!
If you have the lattes ACS... open RunSQL Scripts. Click on the insert
from examples.... If you search for 'managing spool' There is a lovely
bit of SQL that shows how to use the delete_old_spooled_files function
that the operating system has deliver in systools.
For those that dont have that (shame on you...)
call Systools.Delete_Old_Spooled_Files(Delete_Older_Than => current
timestamp - 30 days,
-- p_output_queue_library_name => ,
-- p_output_queue_name => ,
P_User_Name => 'JOEUSER', Preview => 'YES');
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
http://www-03.ibm.com/systems/power/software/i/are/index.html
http://ibm.biz/IBMi_ACS
midrange.com
