Home > AS/400 Tips > iSeries administrator tips > Why you should clean up old spool files
iSeries 400 Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

ISERIES ADMINISTRATOR TIPS

Why you should clean up old spool files


Dan Reusche
09.01.2005
Rating: -4.38- (out of 5)


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


There are many reasons why you should routinely clean up printer output, also known as spooled files, from your iSeries system. Spooled files take up disk space, they lead to clutter that makes it harder to find the output you want, and -- perhaps most important -- they take up active system resources.

Did you ever notice that when you run the WRKACTJOB (Work with Active Jobs) command, the number of jobs shown is different than the number of jobs shown via the WRKSYSSTS (Work with Disk Status) command? If you look at the help text for the number of active jobs for the WRKACTJOB command, it says, "The current number of jobs active in the system (jobs that have been started but have not yet ended), including both user and system jobs." In other words, the count on this screen is for jobs that are currently running. The help text for the number of jobs on WRKSYSSTS says, "The total number of user and system jobs that are currently in the system." The total includes the following:

  • All jobs on job queues waiting to be processed
  • All jobs currently active (being processed)
  • All jobs that have completed running but still have output on output queues

The last bullet shows why spooled files can be a problem. The system has to track this output, and has to keep around information about the jobs that produced the output.

All jobs in the iSeries -- including jobs that have been submitted but are waiting on job queues, currently running jobs, and jobs with spooled output -- are tracked in an internal structure known as the Work Control Block Table. This structure keeps information pertinent to all of the types of jobs listed above. Usually, the largest percent of entries in the Work Control Block Table are jobs that have completed but still have spooled output.

More Information
Since each entry in the table requires a certain amount of space, the more entries that exist, the more disk and memory resources are needed. Also, certain functions in the system related to jobs must access the Work Control Block Table. In some cases, they must walk through the entire table.

If you have ever heard that the WRKACTJOB command is a bad command for a lot of people to run at once or that it is a system hog, this is the reason why. When you invoke WRKACTJOB, it has to walk through the entire Work Control Block Table to gather the information it needs to display. A classic example is when a system slowdown has occurred and a whole bunch of people invoke WRKACTJOB all at once trying to figure out what is going on. All of the sudden the system slows down even more because of the resource demands of all those WRKACTJOB commands running at once.

It follows then that cleaning up old spooled files that are no longer needed (or not creating them in the first place) can help you avoid the extra overhead of managing the associated jobs. To prevent job logs from being created, you can set the Message Logging parameter in job descriptions to (4 0 *NOLIST), which will prevent jobs using the job description from creating a job log if it ends normally. Doing so can prevent a lot of clutter.

You should also use the automated cleanup options available via GO ASSIST to clean up job logs and other system output after a specified period of time. If your users need to keep output indefinitely, they can either print it or copy it to their PC using iSeries Navigator. From their PC, their output can be burned onto a CD.

Finally, you should periodically go through all output queues and clean up old spooled files that are not needed. Once you become familiar with the kind of output being created on your system, you might want to write some CL code to automate the cleanup process and run it from the job scheduler.

Although the overhead associated with spooled files is not terribly bad, it is best to keep those files cleaned up. IBM has provided some tools such as GO ASSIST to help, but some of the work will be up to you and your users. Like any other cleanup task, if you do it a little at a time, it is easier than waiting until the mess is out of control.

-----------------------------------
About the author: Dan Reusche is a senior systems administrator at Think Federal Credit Union in Rochester, Minn. He has worked with the IBM AS/400 and iSeries platform since 1988, when he worked at the IBM Rochester Development Lab and support of AS/400 systems used within IBM. You may contact him at dreusche@chartermi.net.


Rate this Tip
To rate tips, you must be a member of Search400.com.
Register now to start rating these tips. Log in if you are already a member.


Submit a Tip




Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
iSeries administrator tips
Translating Linux for IBM i admins: Using GUI to make it easy
Translating Linux for IBM i admins: Working with jobs and networking
OpenOffice: What to know before making the transition from Microsoft Office
OpenOffice: An enterprise open source solution
Database performance comparisons on IBM i
Translating Linux for IBM i admins: User profile commands
Modern System i reports using Client Access
Tips for installing Lotus Domino server on a System i partition
The iSeries Blog has a new home on IT Knowledge Exchange
Virtualization for IBM i: Backups

Printing on iSeries
How to print RPG output using iSeries Access
Acknowledging control characters in a print file on IBM i without writing a program
Set up a HP Deskjet 6988 with a built-in internal NIC as a stand-alone printer
Determine printing options available for preprinted medical forms
Direct default print job to tray 2 from IBM i
Solve printing problems when using Personal Communications 5.7
Messages and spool hanging up SAVLIB jobs when OUTPUT(*PRINT) is specified
Using AFPRSC to print .jpg or .pdf files from the IFS on AS/400
Print overlays from the AS/400 using the IBM AFP printer driver
Setting up double-sided printing from the AS/400
Printing on iSeries Research

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
Advanced Function Printing  (Search400.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.



iSeries Security - Security Tools, Physical Security and System Security
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts