CICS/COBOL program works in CICS region 1 but not in region3

Karen Dianne Palmera · Posted: Tue Feb 12, 2008 1:43 pm

What could possibly cause this -922 error in my CICS/COBOL program?

-We have defined program PGM1ACOO, map MAP1A & transaction ID TEST in CICS region 3 & CICS region 1.
-We have also defined plan PGMPLAN & transaction ID TEST in RCT definition.
-We have compiled RCT.
-We have restarted both regions. (DOWN-UP CICS Region 1 & CICS Region 3)
-We have given all the grants to the tran ID and plan.
-Then did program compilation, bind and new copy.

When executing the transaction ID in CICS Region 1, the program is working including all the sql select. But when the transaction ID is invoked in CICS Region 3, the program returns a -922 error when selecting from the table. Region 3 cant seem to get the plan and login/userid to be used in sql select.

Example:
P.AUTH=AW02 ---> instead of username
PLAN=DEFAULT ---> instead of PGMPLAN
...
SQLERRMC = 'PLAN ACCESS,00F30034'

The userid is working since, same userid is used for both CICS Region 1 & 3.

What could be triggering the problem?

thanks!

CICS Guy · Posted: Tue Feb 12, 2008 8:46 pm

You should be talking to your DBA and/or security people...
-922 AUTHORIZATION FAILURE: error-type ERROR. REASON reason-code
Explanation: Authorization failed because of the error indicated by 'error-type'

dick scherrer · Posted: Tue Feb 12, 2008 9:17 pm

Hello,

Karen Dianne Palmera · Posted: Wed Feb 13, 2008 6:16 am

As of the grants (Database Admin), grants are already given to the plan, username & transaction ID since, the program can do SQL select in CICS Region 1.

Does it mean that there is a separate granting for different CICS regions?

As we have checked, Both CICS Regions definition are the same. Where can we find the CICS ruling?

thanks!

CICS Guy · Posted: Wed Feb 13, 2008 6:22 am

Karen Dianne Palmera · Posted: Tue Feb 19, 2008 7:52 am

ah...okay thanks!