Home > Ask the AS/400 Experts > iSeries Backup and Recovery Questions & Answers > Identifying large Integrated File System files
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

Identifying large Integrated File System files

Ken Graap EXPERT RESPONSE FROM: Ken Graap

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


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


>
QUESTION POSED ON: 10 February 2008
I would like to find the very large files in IFS. I have done a disktasks and printed the summary report. It looks like the IFS is big. I did a RTVINFSTS and PRTDIRINF with the selection of '/' (root). I get huge spool files. There are 7,000 pages that are difficult to see. What else can I do to drill the problem?

>
The RTVINFSTS command creates several QAEZD* DB files in library QUSRSYS. One of these files (QAEZD0001O, in my case) contains the names and sizes of objects in the IFS.

You can run a query over this file and limit selection to large objects only.

For example:

SELECT QEZALCSIZE, QEZOBJNAM

FROM QUSRSYS/QAEZD0001O

WHERE QEZALCSIZE >= '8000000'

ORDER BY QEZALCSIZE DESC

This selects objects with allocated space larger that 8,000,000 bytes, sorted in descending order.

QEZALCSIZE QEZOBJNAM
515,551,433 NWN_Import
188,754,385 MU062005.csv
162,195,959 FEAD_062005.zip
123,910,566 WA062005.csv
114,214,151 LA062005.csv
110,795,075 CR062005.csv
108,174,381 CL062005.csv
83,406,351 MA062005.csv
38,991,592 LI062005.csv
33,427,555 CS062005.csv
33,138,161 LC062005.csv
27,815,521 YA062005.csv
27,062,506 ZZZZ.CSV
24,768,128 BE062005.csv
24,432,212 PO062005.csv
21,495,605 GFCCH_VLV.CSV
19,590,124 CT062005.csv
18,186,827 CO062005.csv
16,718,028 NW200104030728.txt

With this information you could then search the PRTDIRINF report to find the directory a large file is stored in.

Hope this helps you identify the big files in the IFS.


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



RELATED CONTENT
iSeries Backup and Recovery
Parallel backups using save option 21
How to migrate old *ALLUSR data using BRMS to V6R1
How to save HMC critical data through the console
Authority restrictions on the AUTL on backup/test systems and AUTL on live system
Perform a full system backup without user profile QSECOFR
Faster backup method for System i
Solve problems concerning the ALLOW OBJECT DIFFERENCES parameter when restoring a library
System i backup not advised using network NETBACKUP
How to clear expired BRMS created *SAVF files from System i
Restore a full system backup from the production partition to the test partition

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



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



iSeries Networking - Printing, Remote Access, TCP/IP
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