Dynamic SQL in CICS?



IBM's flagship relational database management system

Dynamic SQL in CICS?

Postby Balr14 » Fri Dec 09, 2016 3:14 am

I have a dynamic SQL that runs fine in batch, but gives me a -551 error on the prepare statement in CICS. Is this just a user ID authorization issue?
Balr14
 
Posts: 41
Joined: Fri Oct 01, 2010 9:43 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Dynamic SQL in CICS?

Postby NicC » Fri Dec 09, 2016 3:23 pm

I don't know. What is the text of the error message? Does the manual give any hints as to how to resolve it?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Dynamic SQL in CICS?

Postby Balr14 » Fri Dec 09, 2016 8:47 pm

When I run this very same prepare statement in a batch program, it works fine. But, in a batch program I do the DB2 connect. When I run under CICS, CICS does it. That's where I get the -551. The text for the error message says user ID doesn't have authorization to execute this statement. But the user ID is blank. My problem is the support staffs for CICS, RACF and DB2 all say it isn't their problem. I want to know who to bitch at!
Balr14
 
Posts: 41
Joined: Fri Oct 01, 2010 9:43 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Dynamic SQL in CICS?

Postby Robert Sample » Fri Dec 09, 2016 9:18 pm

There is a user id associated with your transaction. It might be the user id CICS runs under, or some other user id, but obviously the user id for the transaction is not the same as the batch user id. I recommend going back to the CICS support group and finding out what the default user id is for the region (DFLTUSER system initialization parameter). The problem could also be in the CICS data for RACF for the user id you execute the batch job under, in which case you would need to talk to the security support group.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Dynamic SQL in CICS?

Postby Balr14 » Sat Dec 10, 2016 11:16 am

Thank you for your responses, but after consideration, I decided that using dynamic SQL in a CICS program in this company was not supportable. The tech support staffs just aren't as knowledgeable as they used to be and seem to be getting dumber as time passes. I have been demonstrating this problem to all of them for over a week and they are clueless. I guess that's the result of continually losing mainframe staff.
Balr14
 
Posts: 41
Joined: Fri Oct 01, 2010 9:43 pm
Has thanked: 0 time
Been thanked: 1 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post