MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

bind unsucessful.

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
culturewyj
Beginner


Joined: 15 Jun 2006
Posts: 15
Topics: 10

PostPosted: Wed Jul 05, 2006 10:03 am    Post subject: bind unsucessful. Reply with quote

Code:
READY                                                                           
DSN SYSTEM(DB7G)                                                               
DSN                                                                             
  BIND PACKAGE (PX27) MEMBER(PX27DB2)    ACT(REP) ISO(CS) ENCODING(EBCDIC) OWNER
DSNT235I  -DB7G DSNTBCM2 BIND AUTHORIZATION ERROR                               
           USING PX27 AUTHORITY                                                 
           PACKAGE = TONGJILP2V7.PX27.PX27DB2.()                               
           PRIVILEGE = CREATE IN                                               
DSNT233I  -DB7G UNSUCCESSFUL BIND FOR                                           
           PACKAGE = TONGJILP2V7.PX27.PX27DB2.()                               
DSN                                                                             
  BIND PLAN(PX27) PKLIST(PX27.*)    ACT(REP) ISO(CS) ENCODING(EBCDIC) OWNER(PX27
DSNT241I  -DB7G BIND AUTHORIZATION WARNING ON PLAN PX27                         
           AUTHORIZATION-ID PX27 NOT AUTHORIZED TO EXECUTE                     
           PACKAGE  PX27.*                                                     
DSNT252I  -DB7G DSNTBCM1 BIND OPTIONS FOR PLAN PX27       


when i try to bind,it reported me those messages.' i query the sysibm.sysuserauth system catalog table, i found the value for BINDADDAUTH is 'Y', any wrong with it?
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12355
Topics: 75
Location: San Jose

PostPosted: Wed Jul 05, 2006 10:08 am    Post subject: Reply with quote

culturewyj,

Wasn't your Question Answered here ?

http://www.mvsforums.com/helpboards/viewtopic.php?t=6678&highlight=bind

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
CZerfas
Intermediate


Joined: 31 Jan 2003
Posts: 211
Topics: 8

PostPosted: Thu Jul 06, 2006 1:48 am    Post subject: Reply with quote

Well, no. Actually he needs the right to create packages in the colletion PX27. BINDADD is already granted.

Kolusu, could you provide a link to the point in the DB2 manuals, where the grants for using collections are discussed?

regards
Christian
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12355
Topics: 75
Location: San Jose

PostPosted: Thu Jul 06, 2006 5:09 am    Post subject: Reply with quote

Quote:

Kolusu, could you provide a link to the point in the DB2 manuals, where the grants for using collections are discussed

CZerfas,

Check this link

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/5.58?DT=20010718164132

Hope this helps...

Cheers

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group