ASP3 abend while retrieving data from a db2 table in cics

namitjai · New User Joined: 12 Feb 2008 Posts: 41 Location: Bangalore

while retrieving data from a db2 table in cics map i got Abend ASP3

Can anybody tell me what exactly is required to solve the problem..I read the document which says its SYNCPOINT problem..but I am not able to understand as to what actually is required to be done to solve this out.
I am getting this abend when I am trying to fetch values from a table using SELECT statement.

Thanks,

enrico-sorichetti · Posted: Wed Nov 19, 2008 1:28 pm

in the document You read what does the ..
User Response paragraph say ??

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dfhg4a06/3.18?ACTION=MATCHES&REQUEST=asp3&TYPE=FUZZY&SHELF=DFHASH0A.bks&DT=20080115160124&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

Raghu navaikulam · Posted: Thu Nov 20, 2008 11:46 pm

Hi

If the reference manual is not giving sufficient information to rectify your problem, then check your plan name related to the transaction. Either plan name is not valid or there is no plan name specified for the transaction. So CICS uses the default PLAN name which is not authorized for the user.

Hope this may help you.
Raghu

namitjai · New User Joined: 12 Feb 2008 Posts: 41 Location: Bangalore

Yes, You were correct. I defined DB2ENTRY for each of the transaction having desired plan name and it ran fine.

Thanks for your help.

Vedant · New User Joined: 19 Oct 2017 Posts: 2 Location: India

Can you please share the program namitjai and the execution steps too? M new to this and have just started this program

enrico-sorichetti · Posted: Fri Oct 20, 2017 1:24 pm

the TS was last active on the forum on Wed Feb 18, 2009
so the chances of getting a reply from him/her/it are pretty slim

and when You have a question rather than tailgating on 9 years old topic
START A NEW ONE

Topic locked