Re: SQL to find largest IFS file

WITH ifsobjs (path) AS (
SELECT path_name
FROM TABLE (
qsys2.ifs_object_statistics(
start_path_name *=>* '/', subtree_directories *=>* 'NO')
) a
WHERE *length*(path_name) > *1* and *SUBSTR*(path_name, *1*, *2*) <>
'/Q'
)
SELECT i.*,
z.*
FROM ifsobjs i,
LATERAL (
SELECT *SUM*(data_size)
FROM TABLE (
qsys2.ifs_object_statistics(
start_path_name *=>* path, subtree_directories *=>* 'YES'
)
)
WHERE data_size IS NOT null
) z
ORDER BY i.path;

HTH
--
Marco Facchinetti

Mr S.r.l.

Tel. 035 962885
Cel. 393 9620498

Skype: facchinettimarco


Il giorno lun 16 feb 2026 alle ore 15:49 gio.cot via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> ha scritto:

Hi Marco

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 this analize also QSYS . for olny IFS stream 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.