Would this help?
Note: You do not want "job user". You want the current user of the job. In this case "AUTHORIZATION_NAME".
Select
ORDINAL_POSITION, -- A unique number for each row.
JOB_NAME, -- The qualified job name.
INTERNAL_JOB_ID, -- The internal job identifier.
SUBSYSTEM, -- The name of the subsystem where the job is running.
-- Contains the null value if the job is a system job.
SUBSYSTEM_LIBRARY_NAME, -- Library containing the subsystem description.
-- Contains the null value if the job is a system job.
AUTHORIZATION_NAME, -- The user profile under which the initial thread is running at this time. For jobs that swap user profiles, this user profile name and the user profile that initiated the job can be different.
JOB_TYPE, -- Type of active job.
...
CLIENT_IP_ADDRESS, -- Client IP address, in IPv4 format, being used by the job.
-- Contains the null value when no client IP address exists or the job is using IPv6.
...
from table(qsys2.active_job_info(
RESET_STATISTICS => 'NO',
SUBSYSTEM_LIST_FILTER => '' ,
JOB_NAME_FILTER => '*ALL',
CURRENT_USER_LIST_FILTER => '',
DETAILED_INFO => 'NONE'
)) A
-- RESET_STATISTICS: 'YES', 'NO'
-- SUBSYSTEM_LIST_FILTER: ''=ALL, 'MYSBS', 'SBS1,SBS2,SBS3' up to 25 names
-- JOB_NAME_FILTER: '*' = current job, '*ALL', '*CURRENT'=Same name as current job, '*SBS', '*SYS'
-- CURRENT_USER_LIST_FILTER: ''=ALL, 'ROB', 'ROB,SAM,PETE,LOU' up to 10 users
-- DETAILED_INFO: 'ALL', 'NONE' = This is the information in the columns prior to the JOB_DESCRIPTION_LIBRARY column. NONE has less overhead.
;
You can put a where clause on there for the IP address,
or search for a particular user with the CURRENT_USER_LIST_FILTER
or...
http://ibm.biz/DB2foriServices
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Robert Rogerson
Sent: Wednesday, April 17, 2019 11:22 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Getting the ACS job in Windows
Hi all,
I'm drawing blanks on how to research this topic. Basically what I'm looking to find out is the job (jobname/user/job number) which is created when I start a terminal session in ACS.
I want to be able to access this information on the PC which started the session. I've been trying to find answers on google but I'm not having much luck.
If anyone has any ideas or at least the proper terminology I should search for I'd greatly appreciate it.
Thanks,
Rob
--
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@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
