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
 

 

what is the mistake that i had made in the Bind card??

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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: 6967
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 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 Sort Card to Remove Duplicate records... raj4neo SYNCSORT 2 Wed Jan 25, 2017 4:44 am
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm
This topic is locked: you cannot edit posts or make replies. Sort card to replace text using cross... Susanta SYNCSORT 32 Tue Sep 13, 2016 4:17 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us