View previous topic :: View next topic
|
Author |
Message |
ravven16
New User
Joined: 22 Aug 2006 Posts: 16
|
|
|
|
Hi,
iam getting an bind error like this -924 SQL Code
The SYSTSPRT displays the following message
READY
DSN SYSTEM(DX00)
DSN
RUN PROGRAM(RAMESH) PLAN(RAMESH) LIB('CGEY.TEST.PD.PGMLIB')
PLAN RAMESH NOT AUTHORIZED FOR SUBSYSTEM DX00 AND AUTH ID VS90489
DSN
END
READY
END
I ahve used the following Bind controlcards
DSN SYSTEM(DX00)
BIND PLAN(RAMESH) OWNER(AETOWNR1)-
PKLIST(PDC001.*) -
VALIDATE(BIND) ISOLATION(CS) CACHESIZE(0) -
RELEASE(DEALLOCATE) -
ENABLE(BATCH) -
ACTION(REPLACE) RETAIN
END
DSN SYSTEM(DX00)
BIND PACKAGE(PDC001) OWNER(AETOWNR1) MEMBER(RAMESH) -
ACTION(REPLACE) DISABLE(REMOTE) VALIDATE(BIND) EXPLAIN(NO)
END
My bind process is succesful and iam getting 0 return code.
while running the program using the control card
//SYSTSIN DD *
DSN SYSTEM(DX00)
RUN PROGRAM(RAMESH)-
PLAN(RAMESH)-
LIB('CGEY.TEST.PD.PGMLIB')
END
iam getting an sqlcode code -924.
and ths SYSTPSRT displaces messages like this
READY
DSN SYSTEM(DX00)
DSN
RUN PROGRAM(RAMESH) PLAN(RAMESH) LIB('CGEY.TEST.PD.PGMLIB')
PLAN RAMESH NOT AUTHORIZED FOR SUBSYSTEM DX00 AND AUTH ID VS90489
DSN
END
READY
can anyone explain where iam going wrong or whether I have proper authorization...
What should I do to make the program work?
Regards
Ravi venkatesh KP |
|
Back to top |
|
|
Avinash_Gupta
New User
Joined: 11 May 2005 Posts: 26 Location: Hyderabad
|
|
|
|
Yes, it appears that you lack the authority for execution of the PLAN. You woud have to ask the DBA to give you the right authority for the execution. |
|
Back to top |
|
|
kgumraj
Active User
Joined: 01 May 2006 Posts: 151 Location: Hyderabad
|
|
|
|
I too faced same problem,
Solution: change ISOLATION(CS) to ISOLATION(RR) in bind itself and run the program. It will be resolved |
|
Back to top |
|
|
|