Yes plan names are not qualified and must be unique per subsystem. The way to handle the issue of binding a program which references unqualified table names where you wish to use two different qualifiers as in:

NEWYORK.EMP_TABLE
TEXAS.EMP_TABLE

is to have one plan with 2 (or more) packages in two (or more) collections. You'll specify a different owner or qualifier parameter for each package in the plan. Look up the SET CURRENT PACKAGESET statement as a way to process these two tables in one "generic" program.

Hal Steiner

-----Original Message-----
From: Abel Mike J <db2udbdba-ezmlmshield-x75235284.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Mon, 31 Oct 2005 11:23:37 -0600
Subject: RE: binds on z/os


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





---------------------------------------------------------------------
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