I believe in a given subsystem, the plan name is unique regardless of owner or qualifier. Create PLAN2 and bind it with QUAL2 and OWNER2.

________________________________

From: Gard Joe (CBC) [mailto:db2udbdba-ezmlmshield-x56926181.[Email address protected]
Sent: Mon 10/31/2005 9:00 AM
To: LazyDBA Discussion
Subject: binds on z/os



This is a bind question ...

I have a plan named PLAN1. The qualifer is QUAL1. The owner is OWNER1.

When I run this query ..

select name,creator,qualifier from sysibm.sysplan;

I can see that PLAN1 does have a qualifer of QUAL1 and owner of OWNER1.

I now need to run the bind again, but this time using PLAN1 as the name, AND with a qualifier of QUAL2 and owner of OWNER2.

The bind is succesful, but when I look at the sysplan table, the PLAN1 name now shows a qualifier of QUAL2 and owner OWNER2.

I would think that since I am using a different qualifer and owner, I should see two PLAN1 names, each with its own qualifier and owner ....


My goal is create tables with same name but with different qualifiers, however, I want to use the same plan (different database, but same subsystem ID).

I have my JCL setup to use a different dbemlib and loadlib for each plan.

Confidentiality Notice:
This e-mail is intended only for the personal and confidential use of the individual to whom it is addressed and may contain information that is privileged, confidential and protected by law. If you are not the intended recipient, you are hereby notified that any use or disclosure of this information is strictly prohibited. If you have received this message in error, please notify the sender immediately by reply e-mail and delete the original message. Your compliance is appreciated.




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page