Re[2]: qsys2.IFS_OBJECT_STATISTICS won't return anything

If your OSS Environment is already provisioned, you just need to install
'ncdu' and 'gzip' using the ACS Package Manager found here:
ACS Menu > Actions > Management > Open Source Package Management

If you don't' have an OSS Environment provisioned, then follow these steps:

https://www.ibm.com/support/pages/getting-started-open-source-package-manag

ement-ibm-i-acs

https://ibmi-oss-docs.readthedocs.io/en/latest/yum/README.html#installing-w

ith-access-client-solutions-acs

Then connect over SSH with Putty and adjust your path:
(This will allow you to run commands without needing to fully qualify them).

https://ibmi-oss-docs.readthedocs.io/en/latest/yum/README.html#adjusting-yo

ur-path

After that, log off and log back on over SSH with Putty, and the ncdu
commands should work.

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

date: Tue, 08 Oct 2024 15:26:42 +0000
from: MidrangeL <midrangel@xxxxxxxxxxxxxxxxx>
subject: Re[2]: qsys2.IFS_OBJECT_STATISTICS won't return anything
under /QNTC. Other SQL options?

Dan, check the open source package management in ACS. You can see there
what is and is not installed, and install it if needed.
The IFS path is /OQpenSys/pkgs/bin to get to the installed stuff.


--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


------ Original Message ------

From "Dan Bale" <dan.bale@xxxxxxxxxxxxxxxxxxxxx>

To "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Date 10/8/2024 9:38:36 AM
Subject 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