Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to specify different owners during bind?

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

New User


Joined: 30 Nov 2005
Posts: 26

PostPosted: Fri Mar 17, 2006 1:42 am    Post subject: How to specify different owners during bind?
Reply with quote

Hi,

I am developing a program and using a table which is created by me. The program uses many other tables which have a different owner. When binding the plan for this program, how do we specify different owners for tables?

A simple bind card looks something like this. Here the owner DEVLPTC is the owner of most of the tables in the program PTCB99. One table has th owner TS2379. How do we specify this in the bind card? Any suggestion is greatly welcomed! icon_question.gif

DSN SYSTEM(DSNY)
BIND PLAN(PTCB99) OWNER(DEVLPTC)
MEMBER(PTCB99)
ACT(REP)
ISO(CS)
VALIDATE(BIND)
ACQUIRE(USE)
EXPLAIN(NO)
END
Back to top
View user's profile Send private message

martin9

Active User


Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland

PostPosted: Fri Mar 17, 2006 2:40 am    Post subject:
Reply with quote

hy avelayudhan,

the owner of a plan can be different from the owner of the included
tables. therefore you won't be able to change the owner in the bind step
while binding. it is more important, that the user, which will use this program, has the appropriate rights to access, the tables.

martin9
Back to top
View user's profile Send private message
avelayudhan

New User


Joined: 30 Nov 2005
Posts: 26

PostPosted: Fri Mar 17, 2006 4:12 am    Post subject: Re: How to specify different owners during bind?
Reply with quote

Hi Maritn,

You from Switzerland!! I am planning a trip to Switzerland this summer for 10 days. Maybe you could be a guide to us!!

Hey, my bind is failing since that time has owner TS2379 which is not what is in OWNER parameter of the bind jcl. So, the question is how could we circumvent this issue of bind? any idea?

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

Active User


Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland

PostPosted: Fri Mar 17, 2006 6:34 pm    Post subject:
Reply with quote

hy,

owner DEVLPTC must have the right to include
tables form owner TS2379.
what did you get sql -511 ???

martin9
Back to top
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland

PostPosted: Fri Mar 17, 2006 6:39 pm    Post subject:
Reply with quote

hy guys,

if you come to Switzerland,
send me a email before leaving,
maybe we can arrange something...

icon_biggrin.gif

martin9
Back to top
View user's profile Send private message
avelayudhan

New User


Joined: 30 Nov 2005
Posts: 26

PostPosted: Fri Mar 17, 2006 6:53 pm    Post subject: Re: How to specify different owners during bind?
Reply with quote

Yes, I am getting -511 during bind..by the by, what is your email..?
Back to top
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland

PostPosted: Fri Mar 17, 2006 7:42 pm    Post subject:
Reply with quote

hy avelayudhan,

as i thought, you have a problem with the rights,
make a correct GRANT that the first owner has
access for the other. contact your dba, he will do it.

my email is:
martin.holm@helvetiapatria.ch

martin9
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Mon Mar 20, 2006 2:10 pm    Post subject: Re: How to specify different owners during bind?
Reply with quote

Hi avelayudhan,

Create a alias under DEVLPTC which is pointing to table under TS2379 and then give neccessary access on the table(select,update,delete) to DEVLPTC .

Then use the same bind card while binding.
It should go thru.

Hope you understand what I said.

Thanks
Rags
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
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us