Re: calc directory size on IFS

[Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>]

You can invoke them from any SQL environment.
For the example I did it in iACS "Run SQL Scripts".
You could do it remotely via ODBC if you wished.
This is Db2 Services for i. To paraphrase the late Jimmy Durante, "They've
got a million of them." :)

On Mon, Mar 28, 2022 at 4:43 PM Jerry Draper <midrangel@xxxxxxxxxxxxx>
wrote:

> From where are these functions evoked?
>
> J
>
> On 3/25/2022 5:09 PM, Jack Woehr via MIDRANGE-L wrote:
>
> Db2 for i Services to the rescue: IFS_OBJECT_STATISTICS table function<https://www.ibm.com/docs/en/i/7.3?topic=services-ifs-object-statistics-table-function> <https://www.ibm.com/docs/en/i/7.3?topic=services-ifs-object-statistics-table-function>
>
> Sum the ALLOCATED_SIZE column.
>
> On Fri, Mar 25, 2022 at 5:14 PM Jerry Draper <midrangel@xxxxxxxxxxxxx> <midrangel@xxxxxxxxxxxxx>
> wrote:
>
>
>    I have a directory on the IFS that has some 1,158,058 files varying in
>    size.
>
>    Mgmt wants to know how total GB of files in this directory.
>
>
>
> --
> Jerry Draper, Trilobyte Software Systems, since 1976
> IBM I, Network, and Connectivity Specialists, LAN/WAN/VPN
> Representing WinTronix, Synapse, HiT, and others .....
> (415) 457-3431 . www.trilosoft.com