Showing posts with label System Performance. Show all posts
Showing posts with label System Performance. Show all posts

03/16/09 Two ways to see what is using disk space

Method #1

Use the commands: RTVDSKINF and PRTDSKINF. The retrieve command will build a file that can then be printed with the print command by *LIB, *FLR, *OWN, *OBJ, *SYS

Method #2
Run a query on file QAEZDISK for more granular detail.


Still another method can be found at the blog post located at: http://visionsolutionsinc.blogspot.com/2008/04/easy-way-to-figure-out-what-is-eating.html


Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.

4/28/08 How to determine what is eating up your disk space

Step 1. Run the following command :

DSPOBJD OBJ(*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE) OUTFILE(QGPL/OBJLIST)

CAUTION: Depending on the number of objects on your system this could take a while so you may want to submit it to batch:

SBMJOB CMD(DSPOBJD OBJ(*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE)
OUTFILE(QGPL/OBJLIST)) JOB(BLDOBJLIST)

Step 2. Go to the interactive SQL processor (STRSQL) and run the following SQL statement:

SELECT * FROM QGPL/OBJLIST ORDER BY ODOBSZ DESC

The biggest offenders will be at the top of the list!

Step 3. Delete the OBJLIST file (created in Step 1): DLTF QGPL/OBJLIST


Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2008, Vision Solutions, Inc. All rights reserved. IBM, System i, iSeries, and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.