Re: SQL Script Listing Open IFS Share Sessions

Would be nice if you could get details on the last column in the following:
SELECT
SERVER_SHARE_NAME, SHARE_TYPE, TEXT_DESCRIPTION, PATH_NAME,
CURRENT_CONNECTIONS
FROM QSYS2.SERVER_SHARE_INFO
WHERE SHARE_TYPE = 'FILE';
Like what jobs are in CURRENT_CONNECTIONS and what is the current user
profile being serviced by those jobs.
This is where I would leave it if you want to submit a new idea.

Would that be ZLS0600 at
https://www.ibm.com/docs/en/i/7.5?topic=ssw_ibm_i_75/apis/qzlslsti.html


On Fri, Mar 22, 2024 at 8:52 AM Sizer, Joseph via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

I am able to run a SQL script to list the IFS server share info and it
shows the number of current connections using

SELECT * FROM QSYS2.SERVER_SHARE_INFO
WHERE SHARE_TYPE = 'FILE';

Is anyone aware of a SQL script that would list the actual sessions
showing user ID and some additional job information for active sessions. I
am attempting to get a list of all users that are currently connected to an
IFS share. I am not looking for file locks but rather anyone that has
mounted a network share drive from a PC to the IFS.

Thanks.

Joe Sizer

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.