RE: qsys2.IFS_OBJECT_STATISTICS won't return anything under /QNTC. Other SQL options?

I presume this is something that runs in QSH? If yes:
qsh: 001-0019 Error found searching for command ncdu. No such path or directory.

Is there a path that needs to be added? How do I tell whether ncdu is installed?

- Dan

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jacob Banda via MIDRANGE-L
Sent: Tuesday, October 8, 2024 10:22 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: Jacob Banda <jnbanda@xxxxxxxxxx>
Subject: RE: qsys2.IFS_OBJECT_STATISTICS won't return anything under /QNTC. Other SQL options?

Not sure if you're trying to integrate this into a procedure/program or not.

Would ncdu be of any help? Does it work on /QNTC? I haven't tried it myself.

But if it does work, although not an SQL option, it could at least help you list the directories.

Here's what I use to zip and store the output to my home directory for future reference.
Note: You need ncdu and gzip installed. Run during downtime.

For QNTC:
$ ncdu -1xo- /QNTC | gzip > ncdu-export-qntc01.gz

For Libraries:
$ ncdu -1xo- /QSYS.LIB | gzip > ncdu-export-libraries01.gz

For everything else in the IFS:
$ ncdu -1xo- / --exclude /QDLS --exclude /QFileSvr.400 --exclude /QIBM --exclude /QNTC --exclude /QOpenSys --exclude /QOPT --exclude /QSR --exclude /QSYS.LIB --exclude /QTCPTMM | gzip > ncdu-export-ifs01.gz

Then to review them on-demand:
$ zcat ncdu-export-qntc01.gz | ncdu -f-
$ zcat ncdu-export-libraries01.gz | ncdu -f- $ zcat ncdu-export-ifs01.gz | ncdu -f-

-------------
Jacob

*** CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ***