Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Bind with different Owner & Qualifier.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Hritam

New User


Joined: 27 Jun 2005
Posts: 36
Location: India

PostPosted: Tue Sep 09, 2008 12:24 pm    Post subject: Bind with different Owner & Qualifier.
Reply with quote

Hi,
I got one issue while binding a plan for a Cobol program.
The issue is :
Say this Cobol program A is calling a another program B. Program A and B both has a DB2 call. But Program B calling a DB2 table which is having different qualifier and owner as for Program A.
So while binding the package we need to use different Owner and Qualifier.
Please let me know how will bind the plan now as the Owner and Qualifier is different for both the package. Please advice.

Thanks,
Back to top
View user's profile Send private message

sri_mf

Active User


Joined: 31 Aug 2006
Posts: 216
Location: India

PostPosted: Fri Sep 12, 2008 2:32 pm    Post subject: Re: Bind with different Owner & Qualifier.
Reply with quote

Hritam wrote:
Hi,
I got one issue while binding a plan for a Cobol program.
The issue is :
Say this Cobol program A is calling a another program B. Program A and B both has a DB2 call. But Program B calling a DB2 table which is having different qualifier and owner as for Program A.
So while binding the package we need to use different Owner and Qualifier.
Please let me know how will bind the plan now as the Owner and Qualifier is different for both the package. Please advice.

Thanks,


Can you post a query from program A and program B.
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Fri Sep 12, 2008 5:39 pm    Post subject: Reply to: Bind with different Owner & Qualifier.
Reply with quote

I guess it depends on where your collection is bound, since you are talking about packages. If it is package bound you need not worry about binding the plan.

By the way I dont see a reason why we should bind them to different qualifiers.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts What is Bind Error? Chetan Kumar Mainframe Interview Questions 1 Fri Oct 16, 2015 7:00 pm
No new posts Related to BIND parameters in DB2 sivareddy123 ABENDS & Debugging 2 Fri Jan 30, 2015 4:12 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us