Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
Karen Dianne Palmera

New User


Joined: 08 Feb 2008
Posts: 5
Location: Makati,Philippines

PostPosted: Tue Feb 12, 2008 1:43 pm    Post subject: CICS/COBOL program works in CICS region 1 but not in region3
Reply with quote

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! icon_question.gif
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Tue Feb 12, 2008 8:46 pm    Post subject:
Reply with quote

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'
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Feb 12, 2008 9:17 pm    Post subject:
Reply with quote

Hello,

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

What could be triggering the problem?
The 2 cics regions have different "rules".

As suggested, you should talk with the database and/or security people.
Back to top
View user's profile Send private message
Karen Dianne Palmera

New User


Joined: 08 Feb 2008
Posts: 5
Location: Makati,Philippines

PostPosted: Wed Feb 13, 2008 6:16 am    Post subject: Reply to: CICS/COBOL program works in CICS region 1 but not
Reply with quote

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!
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Wed Feb 13, 2008 6:22 am    Post subject:
Reply with quote

Karen Dianne Palmera wrote:
Does it mean that there is a separate granting for different CICS regions?
Usually, yes....
Quote:
As we have checked, Both CICS Regions definition are the same.
Well, something is different..... Explore that direction....
Quote:
Where can we find the CICS ruling?
Sorry, I am just the CICS guy, that question is more for the DBAs and RACF guys...grin....
Back to top
View user's profile Send private message
Karen Dianne Palmera

New User


Joined: 08 Feb 2008
Posts: 5
Location: Makati,Philippines

PostPosted: Tue Feb 19, 2008 7:52 am    Post subject:
Reply with quote

ah...okay thanks! icon_lol.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts INDEPENDENT CICS TS 4.1 MRO REGION UP... Kyle Carroll CICS 0 Wed Dec 14, 2016 6:55 pm
No new posts CICS START AND CANCEL blayek CICS 1 Wed Dec 07, 2016 3:27 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us