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
 

 

Plan access problem (-922) with CICS-DB2 prog

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
babuprashad
Warnings : 1

New User


Joined: 09 Aug 2007
Posts: 15
Location: mysore

PostPosted: Fri Jul 09, 2010 4:41 pm    Post subject: Plan access problem (-922) with CICS-DB2 prog
Reply with quote

HI,
we are setting up a new CICS DB2 prog on a new server. yesterday for the first time when we defined and ran a transaction the program was unable to execute SQL commands.....then we found out about DB2conn and included the DB2 library in CICS start up JCL and started the DB2....now we are able to access DB2 from CICS transaction. But, I always get the -922 SQLCODE and SQLERRMC - 'USER AUTHORIZATION,00F30058' ......I have also given the execute privilige on the plan to public......let me know if i have missed any thing in DB2CONN.....we do not use a RACF for CICS region.....

The DB2CONN values is as below:

Code:
 I DB2CONN
 STATUS:  RESULTS - OVERTYPE TO MODIFY
   Accountrec( None )             Planexitname( DSNCUEXT )
   Authid(          )             Priority( High )
   Authtype( Userid )             Purgecyclem( 00 )
   Comauthid(          )          Purgecycles( 30 )
   Comauthtype( Ctx )             Resyncmember(              )
   Comthreadlim( 0001 )           Signid( CICSUSER )
   Comthreads(0000)               Security(              )
   Connecterror( Sqlcode )        Standbymode( Reconnect )
   Connectst( Connected )         Statsqueue( CDB2 )
   Db2groupid(      )             Tcblimit( 0012 )
   Db2id( DB9G )                  Tcbs(0000)
   Db2release(0910)               Threaderror(N906d)
   Drollback(Rollback)            Threadlimit( 0003 )
   Msgqueue1( CDB2 )              Threads(0000)
   Msgqueue2(      )              Threadwait( Twait )
   Msgqueue3(      )
   Nontermrel( Release )
   Plan(          )

                                                     SYSID=S650 APPLID=CICSTS32
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: Fri Jul 09, 2010 7:22 pm    Post subject:
Reply with quote

Hello,

Quote:
we do not use a RACF for CICS region.....
What about database?

I believe the resolution is with your security and/or database support people.
Back to top
View user's profile Send private message
babuprashad
Warnings : 1

New User


Joined: 09 Aug 2007
Posts: 15
Location: mysore

PostPosted: Sat Jul 10, 2010 10:11 am    Post subject: Reply to: Plan access problem (-922) with CICS-DB2 prog
Reply with quote

Yes sir.....But in the DB2 region we use RACF and I have also given execute permission to the Plan to public......
So is it always required for CICS-DB2 to have RACF enabled...sign-on screen.

really confused.... when i do a EDF mode ....the P.auth field is always taken as CICSUSER...from where does it get the info???
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: Sat Jul 10, 2010 12:50 pm    Post subject:
Reply with quote

Hello,

Did you look at the information about this reason code?

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnmcj10/4.26.57

I believe security or database support will be able to provide direction.
Back to top
View user's profile Send private message
babuprashad
Warnings : 1

New User


Joined: 09 Aug 2007
Posts: 15
Location: mysore

PostPosted: Sat Jul 10, 2010 2:22 pm    Post subject: Reply to: Plan access problem (-922) with CICS-DB2 prog
Reply with quote

Yes....I just got the reply from the admin team....They have asked to add the ID's to CICS...and that should resolve the issue.....so we would be doing that on Monday......!!!!
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: Sun Jul 11, 2010 12:11 am    Post subject: Reply to: Plan access problem (-922) with CICS-DB2 prog
Reply with quote

Good to hear you have a resolution - thank you for letting us know icon_smile.gif

d
Back to top
View user's profile Send private message
babuprashad
Warnings : 1

New User


Joined: 09 Aug 2007
Posts: 15
Location: mysore

PostPosted: Mon Jul 19, 2010 4:50 pm    Post subject: Reply to: Plan access problem (-922) with CICS-DB2 prog
Reply with quote

Hi all.....the Admin asked us to add the param SEC=YES in the CICS startup JCL and also a few other params were added to the DFH$SIPx member, we also gave privilages to Surrogate user access and the CICS region was restarted......BUt now i am unable to install the DB2CONN ....It gives an error saying unable to install due to security reasons ......

In most of the manuals the ask to add XUSER=YES param.......can any1 let me know if that is the reason.......????
Back to top
View user's profile Send private message
babuprashad
Warnings : 1

New User


Joined: 09 Aug 2007
Posts: 15
Location: mysore

PostPosted: Wed Jul 21, 2010 6:08 pm    Post subject: Reply to: Plan access problem (-922) with CICS-DB2 prog
Reply with quote

This issue is solved .....thanks for the support !!!!
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Jul 21, 2010 6:24 pm    Post subject:
Reply with quote

Glad to hear that, it would be great to know the final resolution you've used, however? icon_smile.gif
Back to top
View user's profile Send private message
babuprashad
Warnings : 1

New User


Joined: 09 Aug 2007
Posts: 15
Location: mysore

PostPosted: Thu Aug 05, 2010 11:11 am    Post subject: Reply to: Plan access problem (-922) with CICS-DB2 prog
Reply with quote

We had missed out the parameter XUSER=NO.....and unfortunately XUSER parameter has a default value of YES. coz of which we were getting the problem.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Aug 05, 2010 2:34 pm    Post subject:
Reply with quote

Thanks for posting the solution back, nice gesture, appreciate it.
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 How does a called pgm know if its cal... Graeme Westerman COBOL Programming 4 Tue Nov 29, 2016 9:25 pm
No new posts IMS DC screen Access sivasaras IMS DB/DC 3 Fri Nov 18, 2016 6:38 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts CICS NEW SIT PARAMETERS CICS BEHAVIOR... Kyle Carroll CICS 0 Fri Nov 04, 2016 11:55 pm


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