MVSFORUMS.com

Jashu · Posted: Mon Mar 17, 2003 12:06 am Post subject: CICS DB2 PROGRAM

Hi

When We execute the CICS DB2 program , we are getting -922 plan access error.there is no problem in that.

We have started CICS DB2 attachemtn facility and defined DB2ENTRY in CICS.

What could be the reason.

regards

JASHU

Manas Biswal · Posted: Mon Mar 17, 2003 3:29 am Post subject:

Hi Jashu,

Please check that the ID that you are using to run the transaction has EXECUTE permission on the plan that you are using. Also check that the combination of DB2T and DB2E map the correct transaction and plan.

Regards,
Manas

kolusu · Posted: Mon Mar 17, 2003 7:02 am Post subject:

Jashu,

Here is a complete explanation of the sql error code -922

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/2.1.6.420?SHELF=&DT=20010718150520

Hope this helps..

cheers

kolusu

Glenn · Beginner Joined: 23 Mar 2003 Posts: 56 Topics: 3

Have the admin check the RCT.