RE: How to obtain size of ifs directories and sub-directories

Apologies for jumping in late on this thread, or if I've already missed the answer.

Am I missing something, but won't RTVDIRINF work for this ( I don't recall which version this was introduced). There is also the 'Analyze IFS Storage Consumption' example query in Run SQL Scripts of ACS. This query can take a bit to run, but will analyze your IFS folders and subfolders returning counts and sizes of their contents.

The final resulting list is generated from:
SELECT QEZDIRNAM1 AS IFS_DIRECTORY,
COUNT(*) AS IFS_OBJECT_COUNT,
SUM(QEZALCSIZE) AS IFS_BYTES_ALLOCATED
FROM IFSINFO.IFSINFO2O O INNER
JOIN IFSINFO.IFSINFO2D D ON O.QEZDIRIDX = D.QEZDIRIDX
GROUP BY QEZDIRNAM1
ORDER BY 3 DESC;


Thanks,
Matt

subject: RE: How to obtain size of ifs directories and sub-directories

Nice.

I am also creating an IFS crawler as a Native .Net C# example. Much of the granular dir and file handling functionality is built-in to .Net.

My example crawled about 200000 files in 2 minutes, although I am going to add a thread throttle setting since it chews up as much CPU as it can get ?

Found a gotcha though because the DIR list functions will iteratively crawl directories set up as symbolic links so I had to put an extra check in for that to prevent endless loops when crawling symbolic links.

Regards,
Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com