|
The subsystem that a plan/package is bound in determines where it will run. With the information you have provided, I'm not sure I can give you a clear answer, but I'll try.
If you are set up with one subsystem named DB2T, and then multiple versions of the test tables using with TEST01, TEST0B, and TEST0M as the owner, then you'd have to BIND the plan/package specifying the appropriate value in the QUALIFIER (or OWNER) parameter. For example, to BIND accessing the TEST0B tables, you would bind specifying something like this:
BIND PLAN(SAMPLE) ... QUALIFIER(TEST0B) ...
If you are actually set up with multiple subsystems, where TEST01, TEST0B, and TEST0M are each a separate subsystem, then you'd have to run the BIND against that particular DB2. I don't know how you do your BINDs. They can be done using the DB2I panels, using a standard DB2 program preparation procedure, or using a DB2 program preparation CLIST or REXX EXEC.
If you are using the DB2I panels, then just make sure in your ISPF session that you are getting to the correct DB2 subsystem before binding. If you are using a procedure, CLIST, or REXX EXEC, there are likely to be options that allow you to choose the subsystem or perhaps different versions of the code for each subsystem.
After reading my response here, perhaps the best approach is to talk to your DBA or system programmer for guidance in using your shop's particular methods and standards for binding to the proper subsystem or set of tables.
Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our discussion forums.
|
