View previous topic :: View next topic
|
Author |
Message |
sukumar.pm
New User
Joined: 20 Dec 2007 Posts: 27 Location: chennai
|
|
|
|
Hi,
I am getting RC=-1 when i try to connect to DB2 region from REXX using the SSID.
Code: |
ADDRESS TSO 'SUBCOM DSNREXX'
SAY 'RC=' RC
IF RC THEN
S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')
ELSE
SAY 'ERROR IN DB2 CONNECT-CHECK'
ADDRESS DSNREXX 'CONNECT' DB2F
SAY 'CONNECT' RC
IF SQLCODE \= 0 THEN CALL SQLCA
|
Here is my output/error
Code: |
RC=0
ERROR IN DB2 CONNECT-CHECK
TSS7251E Access Denied to DB2PLAN <DB2REXX>
CONNECT -1
SQLCODE = -922
SQLSTATE = 42505
SQLERRMC = 0 |
How to confirm that error is only because of access violation? Can it be rectified by adding SDSN.. PDS to my library?
Regards!
Sukumar |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
SuKumar,
You are getting a Top-Secret Security error, since you don't have access to that plan.
Code: |
TSS7251E Access Denied to DB2PLAN <DB2REXX> |
Thanks,
Sushanth |
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
Check with your DBA and/or DB2 sysprog to see if DSNREXX has been installed in your shop. (Usually they grant access to PUBLIC to the plan needed by DSNREXX) |
|
Back to top |
|
|
sukumar.pm
New User
Joined: 20 Dec 2007 Posts: 27 Location: chennai
|
|
|
|
Thanks!
It happened because of not adding the following PDS in my ISPLLIB??
'DSN.DBT1.DSNLOAD'
'DSN.DBT1.DSNEXIT' |
|
Back to top |
|
|
|