Here's a question I posted to the VSE list. I know there are few if any VSE
users around here, but I thought a z/OS person (or even another OS) might be
able to answer...
Still pondering VSE and DB2. Don't have DB2 Server for VSE up yet to
actually test anything, but I feel the burning need to have this question
answered sooner rather than later...
According to the SQL Reference (for VSE) both an authorization name (userID)
and a password are always required for a batch job using the CONNECT
statement. What does this mean in terms of operators submitting batch jobs
that access DB2 databases? I can't imagine that you would have the operator
type in their user ID and password each time they need to submit a
production batch job. Do you use your ESM to determine who the user is?
How do you get the password?
Can operators have database rights only through applications? In other
words, we wouldn't want to have an operator be able to connect to a database
via the CLP or Control Center and update tables, but they certainly need to
have update capability when submitting batch jobs. [Actually, I believe I
have found the answer to this, and the answer is yes, by only authorizing
the operators to have rights via bound packages.]
If connecting to a remote DB2/LUW database, how does the DB2/LUW "client"
authentication come in to play. Is there any type of ID mapping available?
For instance, right now I have a VSE user ID of 'FJS', but my ID on our
DB2/LUW server is 'fjswarbr'. Do these names need to be the same, or is
there some way to 'map' them?
Thanks!
Frank
---
Frank Swarbrick
Senior Developer/Analyst - Mainframe Applications
FirstBank Data Corporation - Lakewood, CO USA