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
 

 

Owner in Bind

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

New User


Joined: 05 Oct 2005
Posts: 94

PostPosted: Wed Feb 08, 2006 2:16 pm    Post subject: Owner in Bind
Reply with quote

Hi,
In which step of a DB2 Cobol program compilation/execution is the owner parameter value assigned for Bind.
Thanks,
Nikhil .S.
Back to top
View user's profile Send private message

ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Wed Feb 08, 2006 3:36 pm    Post subject: Re: Owner in Bind
Reply with quote

Hi,
Your Question is not clear.
OWNER parameter is used during bind which will come in to the picture after compilation. bind step will assign the owner and creates the package under that owner.


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

New User


Joined: 05 Oct 2005
Posts: 94

PostPosted: Wed Feb 08, 2006 7:57 pm    Post subject: Re: Owner in Bind
Reply with quote

Hi Rags,
In Our System We create the bind package prior to compilaton of the pgm.The Owner gets assigned during that time itself in the package library.Further the bind occurs during the compilation tim itself.
The problem which troubles me, the Owner obtained is not the RACF ID making the package.Is there any way in which I can come to know how this owner is getting assigned.
Thanks,
Nikhil .S.
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Wed Feb 08, 2006 9:58 pm    Post subject: Re: Owner in Bind
Reply with quote

Hi Nikil,
since you compiled the program after bind , this bind is not useful. And you did bind package after compilation it will replace existing package (or) add a new package depends on bind options.

Here you might have given a owner during bind (after compilation).
OWNER keyword is used for mentioning authorized ID. I mean the value (RACF id or RACF group) in OWNER should have previlege to bind the package. If you did not mention QUALIFIER parameter in bind , then all the tables mentioned in the program will use OWNER parameter value as their DB2 qualifier.

Otherwise "QUALIFIER.table name" will be used during execution of the program.

Hope you got me.If not,Please paste me the error you are getting so that I will try to explain.

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

New User


Joined: 10 Jan 2006
Posts: 24
Location: Germany

PostPosted: Wed Feb 08, 2006 10:04 pm    Post subject: Re: Owner in Bind
Reply with quote

nikyojin wrote:
Hi Rags,
In Our System We create the bind package prior to compilaton of the pgm.The Owner gets assigned during that time itself in the package library.Further the bind occurs during the compilation tim itself.
The problem which troubles me, the Owner obtained is not the RACF ID making the package.Is there any way in which I can come to know how this owner is getting assigned.
Thanks,
Nikhil .S.


Hi Nik,

to run your DB2-COBOL-program, you use a DB2 PLAN
(In Batch you can see it in the JCL).

This PLAN refers to the PACKAGE(S) that you have bound after compilation.

The PACKAGE (and the PLAN as well) contain the OWNER keyword.

When running the COBOL-program all DB2 queries use the ID specified
in the OWNER keyword.
So the OWNER has to be granted on all DB2 tables used in the program,
while iit's not necessary that your user-id has privileges on the DB2 tables.
But you do have to be granted to use the PLAN and PACKAGE.

I hope this answers your question.

Take care,

Michael
Back to top
View user's profile Send private message
nikyojin

New User


Joined: 05 Oct 2005
Posts: 94

PostPosted: Thu Feb 09, 2006 12:01 pm    Post subject: Re: Owner in Bind
Reply with quote

Hi Michael/Rags
Thanks for the Information given.
Problem:- A program ABC compiled in Test .Prior to compilation the package setup was done in test region.After compilation ABC was bound to production.
The bind JCL abended with SQLCODE -551.
The Owner used did not have the authority.
I changed the owner parameter value and the bind was successful when I passed this value thru SYSTIN.
I noticed the Owner was getting picked up prior to compilation when we were making the package setup.I actually wanted to know from where this owner is getting picked up.
Regards,
Nikhil .S.
Back to top
View user's profile Send private message
MichaelKBS

New User


Joined: 10 Jan 2006
Posts: 24
Location: Germany

PostPosted: Thu Feb 09, 2006 5:27 pm    Post subject: Re: Owner in Bind
Reply with quote

How do you setup your package?
Do you use an utility or CLIST/REXX-Procedure?
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Fri Feb 10, 2006 10:17 am    Post subject: Re: Owner in Bind
Reply with quote

Hi Nikil,
From your problem I can understand that, It is not DB2 problem.
It is in your bind job setup. I mean depends on how you are passing the parameters to bind step, it tried to bind. That means if you are passing test region owner to prod region bind step, it will fail.

DB2 will not use OWNER parameter by default. you have to provide.It will use the parameters you provided and try to bind.


In your case,test region owner may be passed by mistake. So you got
-551.


Let me know if you did not understand.

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

New User


Joined: 05 Oct 2005
Posts: 94

PostPosted: Mon Feb 13, 2006 9:51 am    Post subject: Re: Owner in Bind
Reply with quote

Thanks Rags and MichaelKBS for ur valuable suggestions.

The owner in our System comprises of the region in which the Package is being setup followed by the two initial letters of the "Program".Hence it was giving the Group Owner which is being obtained as stated above.Since my program was set up in Test the owner was the Test Region Owner which didn't have the authority in Production which resulted in, the Sqlcode -551 during Production Bind.

Regards,
Nikhil .S.
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