Re: SQL Script Listing Open IFS Share Sessions

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

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.