VINAY PALLELA
New User
Joined: 28 Jan 2018
Posts: 24
Location: India
|
|
|
|
Hi All,
Looking for the help on the best way to capture the AUTH ID of the Source application in mainframe DB2 programs.
We want to implicitly set a new flag based on the AUTH ID of the source application.
So that consumers who are hitting our application do not need to change there programs to send the new flag in the input.
We used the SQL commands
CURRENT CLIENT_APPLNAME
CURRENT USER
CURRENT CLIENT_USERID
CURRENT SQLID
EXEC SQL
SET : WS-CLIENT-USERID = CURRENT CLIENT_USERID
END-EXEC
But they are not working in some of the scenarios and there is a limitation to capture only 8 bytes of user ID.
OUR programs will be called from Mainframe batch, CICS, java, Dot net, web services etc.
2) Best way to maintain consumer's AUTH ID's list ?
It has to be fast and stable as our programs called hundreds and thousands of times a day by the down stream applications for data.
Please suggest the manuals on how we can do caching in the mainframe.
Thank you all in advance!! |
|
