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
 

 

Granting plan access to userid in different CICS regions

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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 19, 2008 8:27 am    Post subject: Granting plan access to userid in different CICS regions
Reply with quote

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! icon_confused.gif
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 19, 2008 9:18 am    Post subject:
Reply with quote

Hello,

Quote:
Is there a different granting for different CICS Regions?
As was posted in your other (same) topic, you need to talk with your database and/or security admin people.

Re-posting the same question multiple times usually just wastes time and gets no additonal useful replies.
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 12:24 pm    Post subject:
Reply with quote

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.
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 19, 2008 8:55 pm    Post subject:
Reply with quote

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).
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts Asynchronous CICS Processing Question moezbud CICS 0 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am


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