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
 
what is the mistake that i had made in the Bind card??

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 IBM Manuals
Quick References
View previous topic :: :: View next topic  
Author Message
prateek_nanda

New User


Joined: 13 Jul 2007
Posts: 19
Location: Gurgaon
PostPosted: Sun Sep 02, 2007 9:10 pm    Post subject: what is the mistake that i had made in the Bind card??
 Reply with quote
Below is my Bind job and it is producing an error plz help me to figure out what can be wrong with this

Code:
 
//JOBLIB   DD  DISP=SHR,                                           
//            DSN=DSN710.SDSNEXIT                                   
//         DD DISP=SHR,                                             
//            DSN=DSN710.SDSNLOAD                                   
//*        4: BIND AND RUN PROGRAMS                                 
//BIND     EXEC PGM=IKJEFT01,DYNAMNBR=20                           
//*DBRMLIB  DD DISP=SHR,                                           
//*         DSN=PRATEEK.DBRM.PDS                                   
//SYSTSPRT DD SYSOUT=*                                             
//SYSPRINT DD SYSOUT=*                                             
//SYSUMUMP DD SYSOUT=*                                             
//SYSOUT   DD SYSOUT=*                                             
//REPORT   DD SYSOUT=*                                             
//SYSTSIN  DD *                                                     
  DSN SYSTEM(DSN1)                                                 
  BIND PACKAGE(DB21) MEMBER(DB21)  ACTION(REPLACE) ISOLATION(CS)-   
        LIBRARY('PRATEEK.DBRM.PDS') VALIDATE(BIND) CURRENTDATA(NO)-
         ENCODING(EBCDIC)                                         
  BIND PLAN(DB21) PKLIST(*.DB21.DB21) MEMBER(DB21)                 
  ISOLATION(RR) ACTION(REP)                                       
//*                                                               
//SYSIN DD *                                                       
GRANT EXECUTE ON PACKAGE DB21.DB21 TO PUBLIC;                     
/*       


error
********************************* TOP OF DATA **********************************
READY
DSN SYSTEM(DSN1)
DSN
BIND PACKAGE(DB21) MEMBER(DB21) ACTION(REPLACE) ISOLATION(CS) LIBRARY(
ENCODING(EBCDIC)
DSNT235I - DSNTBCM2 BIND AUTHORIZATION ERROR
USING MTPLD01 AUTHORITY
PACKAGE = S390LOC.DB21.DB21.()
PRIVILEGE = CREATE IN
DSNT233I - UNSUCCESSFUL BIND FOR
PACKAGE = S390LOC.DB21.DB21.()
DSN
BIND PLAN(DB21) PKLIST(DB21.DB21) MEMBER(DB21)
DSNT250I - BIND UNABLE TO OPEN DBRM LIBRARY
USING MTPLD01 AUTHORITY
PLAN=DB21
DSNT201I - BIND FOR PLAN DB21 NOT SUCCESSFUL
DSN
ISOLATION(RR) ACTION(REP)
DSNE118E ISOLATIO NOT VALID COMMAND
DSN
Back to top
View user's profile Send private message

Bhagyalakshmi C

New User


Joined: 24 Jul 2007
Posts: 38
Location: Bangalore
PostPosted: Mon Sep 03, 2007 12:33 pm    Post subject:
Reply with quote
Hi,

this might be because u may not be having the authorization to that database which u want to use. Check with the people and make sure that you have the authorization..

Am not sure!!! check it out!!!

Please correct if i am wrong!!!
Back to top
View user's profile Send private message
prateek_nanda

New User


Joined: 13 Jul 2007
Posts: 19
Location: Gurgaon
PostPosted: Mon Sep 03, 2007 12:45 pm    Post subject:
Reply with quote
hey ,
Thanks for replying back .......I dont think this is the problem as I am able to bind straight away to Plan for the same program and able to get proper results as well .....
But when i Introduced Package in between I got this error..

icon_sad.gif
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ
PostPosted: Mon Sep 03, 2007 3:10 pm    Post subject:
Reply with quote
prateek_nanda wrote:
hey ,
Thanks for replying back .......I dont think this is the problem as I am able to bind straight away to Plan for the same program and able to get proper results as well .....
But when i Introduced Package in between I got this error..

icon_sad.gif
Read it and weep.....
Code:
DSNT235I  - DSNTBCM2 BIND AUTHORIZATION ERROR                                   
           USING MTPLD01 AUTHORITY                                             
           PACKAGE = S390LOC.DB21.DB21.()                                       
           PRIVILEGE = CREATE IN                                               

Explanation: The authorization ID given does not have the privilege indicated and cannot invoke the bind subcommand on the named package.
Code:
DSNT250I  - BIND UNABLE TO OPEN DBRM LIBRARY                                   
           USING MTPLD01 AUTHORITY                                             
           PLAN=DB21                                                           

Explanation: The BIND subcommand was unable to open the DBRM partitioned data set(s).
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6970
Location: porcelain throne
PostPosted: Mon Sep 03, 2007 11:47 pm    Post subject:
Reply with quote
why is the ISOLATION being changed from CS to RR?
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 How syntax check at Bind time is diff... Poha Eater DB2 5 Wed Mar 21, 2018 9:16 pm
No new posts Need better approach to create a sort... Vamshi Veludandi DFSORT/ICETOOL 8 Thu Mar 08, 2018 5:59 pm
No new posts SORT CARD ram_vizag DFSORT/ICETOOL 13 Thu Mar 01, 2018 4:55 am
No new posts can we hardcode a value in db2 load c... ram_vizag DB2 2 Wed Feb 28, 2018 11:04 pm
No new posts VALIDATE option in BIND jcl Poha Eater DB2 2 Mon Feb 26, 2018 7:08 pm

Facebook
© 2003-2017 IBM MAINFRAME Software Support Division Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us