RE: SQL Script Listing Open IFS Share Sessions

Thanks, Rob. The QZLSFILET joblog is helpful. It at least lists the user profile and IP address.

I already looked at the info in Navigator, but that information is at each individual share level. I could look at each one and copy/paste, but I was hoping to get a SQL script that listed all of them.

I don't need to see sessions that have files locked. I am interested in sessions that have mounted a network drive to the IFS. QZLSFILET shows the session connecting and ending - which is a start.

I will submit an idea and see what happens.

Thanks for the info.


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Friday, March 22, 2024 10:09 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL Script Listing Open IFS Share Sessions

________________________________
CAUTION: This email originated from outside of the PENCOR network. Do not click on any links or open attachments unless the sender is known, and the content is verified as safe.
________________________________

I'm not sure each connection warrants it's own job. This could be where session id comes into play. Look at the joblog of QZLSFILET. And all the objects it has locked.

However, this info is listed in Navigator.
Simply list the shares, click on the share and select Properties, at the bottom it will list the sessions using that share including: IP address, session id, user name, etc.
The bad part is the SQL option to see how they gleaned this is greyed out.
Paste that picture into your submitted idea that is the info you want.

On Fri, Mar 22, 2024 at 9:47 AM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

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.htm
l


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.

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