RE: SQL to find largest IFS file

["gio.cot" <gio.cot@xxxxxxxxxxx>]

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