|
View previous topic :: View next topic
|
| Author |
Message |
prateek_nanda
New User
Joined: 13 Jul 2007
Posts: 19
Location: Gurgaon
|
|
|
|
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 |
|
 |
Bhagyalakshmi C
New User
Joined: 24 Jul 2007
Posts: 38
Location: Bangalore
|
|
|
|
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 |
|
|
prateek_nanda
New User
Joined: 13 Jul 2007
Posts: 19
Location: Gurgaon
|
|
|
|
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..
 |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| why is the ISOLATION being changed from CS to RR? |
|
| Back to top |
|
|
|
|
