Re: Spoolfile Cleanup on powerdown/restart -- MIDRANGE-L

Alexei is right, IPL or RCLSPLSTG only gets rid of spool file space that has
already been freed up by deleting spool files, and it only does it based on
the QRCLSPLSTG number of days you set in the system value. (It used to only
do this at IPL after 7 IPLs.... that's probably what your manager is
thinking of.)

The Go Assist Cleanup does NOT clear out or delete any spool files apart
from system ones (joblogs etc).

What you need is TAATOOL command DLTOLDSPLF which you can run in your
overnight procedure, it allows you to specify an age beyond which spool
files will be deleted (3 days is a good one). You can also specify an outq
not to be cleared, and put all the things the users want to keep on this one
(Month end reports etc for the auditors)  Taatool also has commands for
converting a spool file to a data file for storage, and back again for
printing. This reduces overhead on the system.

You need to notify all users that any spool file not printed,  or moved to
the Hold outq WILL be deleted.
Otherwise inertia takes over, and they do nothing (sometimes not even
knowing that their jobs have produced output), then the system may slow down
too, especially if you have not set the QTOTJOB value and increment high
enough. (although I heard somewhere that in later versions of OS/400 it
ignores your value anyway and takes a more realistic one.)

You can buy the TAATOOL tools via the web - just search for Taatool on
Google...

Another way to do this is to buy ROBOT, but that is more expensive!

Hope this helps,

Clare

Clare Holtham
Director, Small Blue Ltd - Archiving for BPCS
web: www.smallblue.co.uk
IBM Certified AS/400 Systems Professional
E-Mail: Clare.Holtham@btinternet.com
Mobile: +44 (0)7960 665958
----- Original Message -----
From: "Alexei Pytel" <pytel@us.ibm.com>
To: <midrange-l@midrange.com>
Sent: Friday, December 06, 2002 2:23 AM
Subject: Re: Spoolfile Cleanup on powerdown/restart


>
>
>
>
> There are two relatively independent things.
> 1) deleting old spool files.
> This is performed by operational assistant (GO ASSIST) or you can write
> your own program, based on some more sophisticated policy than just time
> 2) cleaning up unused space in internal files used by spool file support.
> This is done via Reclaim Spool Storage (RCLSPLSTG) command.
> No IPL is required. System indeed runs this command at IPL, but you can do
> it any time.
>
>     Alexei Pytel
> always speaking for myself
>
>
>
>
>                       "Norbut, Jim"
>                       <Jim.Norbut@Grubb-        To:
<midrange-l@midrange.com>
>                       Ellis.com>                cc:
>                       Sent by:                  Subject:  Spoolfile
Cleanup on powerdown/restart
>                       midrange-l-admin@m
>                       idrange.com
>
>
>                       12/05/2002 04:54
>                       PM
>                       Please respond to
>                       midrange-l
>
>
>
>
>
> Background : 75Gigs of DASD
>              85% Used
>              QSPL is nearly 9 gigs
>
> My boss wants to incorporate a nightly powerdown/restart
> pwrdwnsys option(*immed) restart(*yes) into the nightly
> backup to clear up used spool file space or cleanup qspl in general.
>
> 1) is there such a process to do this already built into the IPL
>
> He says the answer is yes...but only every so many IPL's
> Does it actually "flip the switch" and run this process.
>
> I told him that sounds strange...either it should do it
> Every time or not.
>
> So which one of is more crazy?
>
> P.S. I don't want to hear about RGPFM or any other command
> That will save space...we know about those.
> I just was curious about the spool file cleanup process
> During a restart.
>
> Thanks,
>
> Jim
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>