Problem solve Get help with specific problems with your technologies, process and projects.

Binding to the proper subsystem

I have a question regarding DB2 systems and the use of subsystems. We currently have the following set up with our DB2 databases.

        TEST01  TEST0B TEST0M
We recently developed a new database in the TEST0B subsystem. I noticed that the TEST01 subsystem was looking at the TEST0B. I was told the bind dictates the subsystem you are looking at, but that it is stored at the system level.

If I want to test the same program in both TEST01 and TEST0B, does the last bind of the program dictate where it is pointing? Will there need to be two separate DB2 systems to accomplish this?

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:


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 .VO7aaqqaAFk.0@/search390>discussion forums.

This was last published in June 2004

Dig Deeper on IBM DB2 management



Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.