IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to specify different owners during bind?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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
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
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
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts JCL for pl1 db2 precompile, compile a... JCL & VSAM 4
No new posts Bind process DB2 4
No new posts How syntax check at Bind time is diff... DB2 5
No new posts VALIDATE option in BIND jcl DB2 2
No new posts Why myself doing Package Bind always ... DB2 5
Search our Forums:

Back to Top