How can minimize System ASP used

10 pts.
Tags:
AS/400 administration
AS/400 storage
Auxiliary Storage Pool
Spool files
My As/400 System % System ASP Used goes to 76 %, How can we minimize this, I already delete Spool File.

Answer Wiki

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

You can also run a RCLSTG (option *ALL), but be sure to run an entire system save before. It could take many hours. I recommend this sequence Entire system save, rclstg and IPL at least every month. But first check what Mr. Gilbert said, this is the first step you have to do.

regards
Hector

Hi,

Make sure you have a backup of anything that you’re going to delete !

You can try deleteing journal receivers, history log files (file QHST* in QSYS). You can also try reorganizing files with deleted records (check with someone that knows how your software works first – some software needs to keep the data in the same sequence).

It might be a good idea to schedule the system cleanup job to automatically delete old spooled files and journal receivers, etc – GO CLEANUP allows you to schedule this.

An IPL can sometimes recover unused space.

Regards,

Martin Gilbert.

Discuss This Question: 11  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
  • Gilly400
    Hi, You can also try using the RTVDSKINF and PRTDSKINF commands to give you an idea where most of your space is being used. Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • slack400
    with the results from the Cleanup reports you can check any really big files to ensure they're set to reuse deleted records. You can then run RGZPFM commands on those file to get some space back. This could have a huge payoff depending. I've seen systems get 20 -50 GB back when they run this the first time. I get back about 2 GB a month on my current system and I only reorg 20 files or so.
    2,705 pointsBadges:
    report
  • deepu9321
    Hi, We can get the Libraries list which are occupying much ASP size by using PRTDSKINF. Is there any command or tool available in AS/400 for getting the Libraries list which are not used for more than 30/60/90 days. Thanks&Regards, Pradeep
    3,695 pointsBadges:
    report
  • TomLiotta
    ...the Libraries list which are not used for more than 30/60/90 days. Please define "used". A library might have objects that are never referenced, yet the library might be listed on a job description. If the library is deleted, jobs that use that job description will fail to start. So, the library isn't actually 'used', but it still needs to be there until other things are changed. More commonly, sites might be interested in objects that are contained in libraries and never used. But then the library wouldn't show as not being "used". Or a library might only be used at the end of a fiscal year. It might not be used during any given 30/60/90 day period, but it might be needed tomorrow. It can be tricky trying to determine what is "used" and what isn't. Tom
    125,585 pointsBadges:
    report
  • deepu9321
    Hi, That would be fine to use the word 'objects' instead of 'Library'. But, I was concentrated on Libraries, Because, I have Some test libraries which were using previously and not at all required currently. Could I be able to get the list of these Libraries(or Objects)? Pradeep
    3,695 pointsBadges:
    report
  • Splat
    Deepu9321, a library is an object so DSPOBJD OBJ(*ALL/*ALL) OBJTYPE(*LIB) OUTPUT(*OUTFILE) OUTFILE([library name]/[file name]) would give you information on the libraries including the last used date. I would recommend that, if the library falls within your selection criteria, you review the objects within the library. And as Tom pointed out, job descriptions can come back to bite you.
    7,215 pointsBadges:
    report
  • TomLiotta
    DSPOBJD ... would give you information on the libraries including the last used date. Unfortunately, no, it won't. For *LIB objects, the Last Used Date will be blank on all of them. Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    That would be fine to use the word ‘objects’ instead of ‘Library’. No. I wasn't using objects’ instead of ‘Library’. A library is a 'container' object. A library contains other objects like files. You use the files every day, but you rarely use the library. You don't need to know when the "library" was used as much as you need to know when the "files inside the library" were used. If you have a library named BUSINESS, and there are files in the library named ORDERS and PAYMASTER, the usage will show against the files. You need to be more concerned with objects inside the libraries. Those objects might be files or programs or other things. Those objects might be used every day, or they might be used once each year. If you want to know when a library is "used", you need to know what is meant by "used". And we need to know what you mean when you ask us. First thing you should probably do is review all of the objects in any library that you think might not be used. Check those objects to see if they have Last Used Dates and Days Used Counts. Those help you know the last dates as well as how many different days. Tom
    125,585 pointsBadges:
    report
  • Splat
    My apologies to Deepu9321 and others, along with my thanks to TomLiotta: I'd never actually looked at the last used date for libraries in a DSPOBJD outfile and made the (evidently erroneous) assumption that it would be populated.
    7,215 pointsBadges:
    report
  • DanTheDane
    Look at these IBM-docs: http://www-912.ibm.com/s_dir/SLKBase.nsf/1ac66549a21402188625680b0002037e/2905aa0dabd217a186256a5b0057ef4b?OpenDocument http://www-01.ibm.com/support/docview.wss?uid=nas12905aa0dabd217a186256a5b0057ef4b rgds DanF
    2,555 pointsBadges:
    report
  • TomLiotta
    ...looked at the last used date for libraries... Yeah, it touches on why the definition of "used" becomes important (IMO). Under what circumstances should usage statistics be updated for a *LIB object? If I call a program out of a library, did I "use" the library? If pgm A calls pgm B 10000 times, should the system update library usage stats 10000 times? Since all *LIB objects exist in QSYS, does usage of library X imply a usage of library QSYS? For libraries, "usage" gets tricky. The system would spend a lot of time keeping usage stats updated for some objects, libraries perhaps more than anything else. So, focus on objects contained within libraries seems to be the right direction. At least, I haven't found any better one. Tom
    125,585 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