Identifying large Integrated File System files |
 |
EXPERT RESPONSE FROM: Ken Graap

|
 |
|


|
| > |
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?
|
|
|
To continue reading for free, register below or login
To read more you must become a member of Search400.com
');
// -->

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.
|
|
|

|
|
 |

 |
 |
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.
|
 |
 |
 |
|
 |
 |
 |
|
 |
|
 |