Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Stored Procedure Uniqueness

I am in an environment where, in a single DB2 Subsystem, we have modules
in various different phases of development.
We use CollectionID and such to identify which "clone" we want.

I need to replicate this with stored procedures, we are running version 5
of DB2.

Can the Stored Procedure key (LUName, AuthID, ProcedureNmae) be modified
such that different AuthID's are used (one for dev1, one for dev2, one for
QA, etc.)to differenciate the different versions of the same module?

If so, is AuthID a RACF class or something that can be assigned to a class
of userid's?

Rich
[642 byte] By [Richard Shen] at [2007-11-9 18:51:15]