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
-------------

date: Tue, 8 Oct 2024 02:32:47 +0000
from: Dan Bale <dan.bale@xxxxxxxxxxxxxxxxxxxxx>
subject: RE: qsys2.IFS_OBJECT_STATISTICS won't return anything under
/QNTC. Other SQL options?

I also found Carsten Flensburg's CHGIFSATR (Change IFS Attributes)
command/program. I compiled it and tried to change the Read Only attribute
on one of the directories under /QNTC/. It returned an error CPD0085 "Range
of parameter CCSID does not include 0." It turns out that directories
created under /QNTC/ are "assigned" a CCSID = 0.

Command RTVDIRINF also ignores anything under /QNTC/.

- Dan

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Dan
Bale
Sent: Monday, October 7, 2024 6:58 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: qsys2.IFS_OBJECT_STATISTICS won't return anything under /QNTC.
Other SQL options?

IBM docs says: "No rows are returned for remote file system objects. This
means that for the QNTC file system, only a row for /QNTC is returned."

I need to find all the directories under /QNTC. Am I limited to "DSPLNK
OBJ('/qntc/*') OUTPUT(*PRINT) OBJTYPE(*ALLDIR) DETAIL(*NAME) DSPOPT(*ALL)",
then copying the spool file to disk and reading that?

I did see an idea (IBMI-I-2844) submitted by Darren Strong 4 years ago,
which has been under "Future consideration" for 3 years. Yay?

Per Rob's response to Darren, I found the Qp0lGetAttr API and then found
Scott Klement's headers for this. Great, but holy smokes, after reviewing
the Qp0lGetAttr prototype and the Qlg_Path_Name_t and Qp0l_AttrTypes_List_t
data structure definitions, I feel like DSPLNK, CPYSPLF, and querying the
outfile (and hope there are no really long directory names) is the way to
go.

Has anyone already invented this wheel and would they be willing to share?

- Dan