Automate SPLF deletion in AS/400

25 pts.
Tags:
AS/400
Automation
OUTQ
SPLF
Systems administration
how can I set up the system to delete old splfs?  I am new to a company who is manually deleting old splf because they are 'maxing out the number of jobs and the system starts shutting down subsystems' when this happens.  There may be system values I can manage or write/borrow a small pgm.

Software/Hardware used:
Don't have ROBOT, AS/400

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi RainyDaye,

The system has a command DLTSPLF. You can write a quick CL program to issue this command with its appropriate selections and add a job to the Job Scheduler to call your CL program. You may wish to execute this jon daily or on seelcted days.

Cheers.

Discuss This Question: 10  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Can you tell us the OS version/release? On current releases, you might investigate uses of the DLTEXPSPLF (Delete Expired Spooled files) command. Tom
    125,585 pointsBadges:
    report
  • RainyDaye
    V5R4 - what I want to do is set the expiration date for all joblogs coming out of a specific process. But the process is a 3rd party software and the CHGSPLFA won't let me specify a create date unless I put the exact job number and time created. Without specifying a create date, everytime I execute the command to set a number of days to expire, it will update all of them and none of them will ever expire. I looked at the DLTOLDSPLF pgm and it looks like it uses copybooks I don't have.
    25 pointsBadges:
    report
  • HMSSL2K
    We use a product by WorksRight Software called SOQ. It gives you many ways to delete spood files: ie. Create date, last used date, number of days old plus a few others.
    3,175 pointsBadges:
    report
  • TomLiotta
    I looked at the DLTOLDSPLF pgm and it looks like it uses copybooks I don’t have. Do you feel comfortable as a CL programmer? I have a kind of "template" CL program that you could modify to automate all of it. It's more of a demo of concepts than a serious tool, but it might help get you going. Tom
    125,585 pointsBadges:
    report
  • pdraebel
    Are you using system cleanup ? Type GO CLEANUP. There is an option to delete old system output from certain output queues. For other regular cleanup I use a program that uses API's to detect the outqueus on the system, next list the spools in the outques and cleanup based on creation date and such. This is scheduled to run every night. It has also the possibility to specify retention days per outq or Library and so on.
    2,845 pointsBadges:
    report
  • CharlieBrowne
    The GO CLEANUP options only cleans up joblog output queues
    41,380 pointsBadges:
    report
  • RainyDaye
    The solution I came up with was to use the old DLTOLDSPLF utility (from HKTOOL, not TAATOOL) to selectively purge QEZJOBLOG for the specific software/user and then run the generic run so the user space wouldn't max out. CLEANUP is too generic since the major problem was a nonfunctional EDI polling error that no files were received (how useless). Thanks for the help, though.
    25 pointsBadges:
    report
  • TomLiotta
    ...it looks like it uses copybooks I don’t have. You should be able to get the /copy members by installing 5722SS1, option 13, 'System Openness Includes'. If you can locate your system install CDs/DVDs, it should be an easy install. Most of it is just installing source files so you don't have to create the members from scratch. Make sure that library QSYSINC doesn't already exist on your system -- authority to the library or to the source files could be the problem. If you install the option, I recommend that you copy any source members into one of your in-house libraries before actually using them in production code. Tom
    125,585 pointsBadges:
    report
  • pdraebel
    Agreed, CLEANUP is only cleaning up some system logs. The program I made is buitl around API's QUSLSPL (List Spoolfile) QUSCRTUS (Create user space) and QUSLOBJ (List Object). A little search on the internet should provide examples of programs working with these API's and get you started, after all I did much the same. And it will be a good learning experience.
    2,845 pointsBadges:
    report
  • Bigmac46
    This is something I put out several years ago but is still being used by us today. Sugggest creeating a file and rpg program to read it with outq and days in the file and call the DP8000P with it . It free - it works- and other controls can be added if needed using the SPFDTA. It's outq specific and only maintenance we have ever had to do is add or subtract outqs and number of days old. We also use another version to move onth end and year-end reports to specific outq to save in case reports get lost(they always seem to lose a few). http://search400.techtarget.com/tip/0,289483,sid3_gci919150,00.html
    1,000 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following