Granting plan access to userid in different CICS regions

Karen Dianne Palmera · Posted: Tue Feb 19, 2008 8:27 am

We have this plan PLAN01XX, program PRG01COO, transaction id PR01 and userid USER01XX which are both defined in our CICS Region 1 & CICS Region 3.

When the program is invoked using tran id PR01, we have different results....

In CICS Region 1, the program is successful in executing an SQL Select using the logon /userid
BUT in CICS Region 3, this is the error..
==============================================
TRANSACTION: PR01 PROGRAM: PRG01COO TASK: 0000443 APPLID: TST3CICS DISPLAY: 00
STATUS: COMMAND EXECUTION COMPLETE
CALL TO RESOURCE MANAGER DSNCSQL
EXEC SQL SELECT P.AUTH=1D22 , S.AUTH=
PLAN=DEFAULT, DBRM=PRG01COO, STMT=00234, SECT=00001
SQL COMMUNICATION AREA:
SQLCABC = 136
SQLCODE = -922
SQLERRML = 020
SQLERRMC = 'PLAN ACCESS,00F30034'
SQLERRP = 'DSNAET03'
SQLERRD(1-6) = 000, 000, 00000, 0000000000, 00000, 000
SQLWARN(0-A) = '_ _ _ _ _ _ _ _ _ _ _'
SQLSTATE = 42505
OVAR 001: TYPE=CHAR, LEN=00070

Is there a different granting for different CICS Regions? If there is, how can I do it?

thank you!

dick scherrer · Posted: Tue Feb 19, 2008 9:18 am

Hello,

Karen Dianne Palmera · Posted: Tue Feb 19, 2008 12:24 pm

i have asked our database administrators and they have not experienced this kind of error.

we usually give grants only once and it will take effect in whatever CICS region we have.

dick scherrer · Posted: Tue Feb 19, 2008 8:55 pm

Hello,

Well, somehwere there is a "disconnect" - on your system. The people performing the admin tasks on your system should be able to identify what is raising the security violation (-922).

And yes, different environments/regions often require different "granting". The specifics for your system are unique to your system, so your syupport people will need to issue the proper grant(s).