Re: SQL to find largest IFS file

SELECT path_name,
object_type,
data_size,
object_owner,
create_timestamp,
access_timestamp,
data_change_timestamp,
object_change_timestamp
FROM TABLE (
qsys2.ifs_object_statistics(start_path_name *=>* '/'
, subtree_directories *=>* 'YES')
)
ORDER BY *3* DESC;

But you need to get some popcorn because it's going to be quite long.

HTH
--
Marco Facchinetti

Mr S.r.l.

Tel. 035 962885
Cel. 393 9620498

Skype: facchinettimarco


Il giorno dom 15 feb 2026 alle ore 23:40 gio.cot via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> ha scritto:

Hi all

Which sql statement i can run, to find the largest IFS files ?

Thanks

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.