|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.