|
View previous topic :: View next topic
|
| Author |
Message |
babuprashad
Warnings : 1
New User
Joined: 09 Aug 2007
Posts: 15
Location: mysore
|
|
|
|
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 |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
babuprashad
Warnings : 1
New User
Joined: 09 Aug 2007
Posts: 15
Location: mysore
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
| Back to top |
|
|
babuprashad
Warnings : 1
New User
Joined: 09 Aug 2007
Posts: 15
Location: mysore
|
|
|
|
| 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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Good to hear you have a resolution - thank you for letting us know 
d |
|
| Back to top |
|
|
babuprashad
Warnings : 1
New User
Joined: 09 Aug 2007
Posts: 15
Location: mysore
|
|
|
|
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 |
|
|
babuprashad
Warnings : 1
New User
Joined: 09 Aug 2007
Posts: 15
Location: mysore
|
|
|
|
| This issue is solved .....thanks for the support !!!! |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| Glad to hear that, it would be great to know the final resolution you've used, however? |
|
| Back to top |
|
|
babuprashad
Warnings : 1
New User
Joined: 09 Aug 2007
Posts: 15
Location: mysore
|
|
|
|
| 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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| Thanks for posting the solution back, nice gesture, appreciate it. |
|
| Back to top |
|
|
|
|
