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
 

 

abend AEY9 at "CALL 'DSNHLI' USING SQL-PLIST3

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
abhilashapandey

New User


Joined: 22 Nov 2006
Posts: 12
Location: Delhi

PostPosted: Fri May 18, 2007 5:27 pm    Post subject: abend AEY9 at "CALL 'DSNHLI' USING SQL-PLIST3
Reply with quote

Hi,

I am coding an DB2 CICS program and when I tried to open a cursor, it gave me an abend AEY9 at "CALL 'DSNHLI' USING SQL-PLIST3 ".

*****EXEC SQL
***** OPEN TRANS-LIST
*****END-EXEC
PERFORM SQL-INITIAL UNTIL SQL-INIT-DONE
CALL 'DSNHLI' USING SQL-PLIST3
==> CICS abend intercepted. Abend code = AEY9. after an external CALL.
==>
==> Press PF1 for a detailed description.
==>

Please let me know how to remove this.
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Fri May 18, 2007 7:12 pm    Post subject:
Reply with quote

Is DB2 installed/active in that CICS?

AEY9
Explanation: One of the following:
An EXEC CICS command has been issued that is not supported by the EXEC interface program DFHEIP.
A transaction has issued an EXEC CICS command which is supported in principle by the EXEC interface program DFHEIP, but for which the prerequisite function has not been included in the current CICS start-up.
A non-CICS command has been issued via an application "stub" (expansion of a DFHRMCAL macro), and the program DFHERM has detected that the necessary non-CICS support is not available.
An attempt has been made to use remote resources, but the local SYSID has been specified in an EXEC CICS command, or vice versa.
An attempt has been made to use remote resources, but ISC is not supported.
An EXEC CICS command contains an invalid AID or CONDITION identifier. This indicates that the EXEC CICS command has become corrupted.
Back to top
View user's profile Send private message
skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Mon Jun 04, 2007 4:37 pm    Post subject: Re: abend AEY9 at "CALL 'DSNHLI' USING SQL-PLIST3
Reply with quote

Go for step by step execution..Check whether the can is sucessfull or not...What do u do after the call??? Is the program displaying the data after the call??

Regards,
Syam
Back to top
View user's profile Send private message
anv2005

New User


Joined: 14 Jul 2005
Posts: 44
Location: US

PostPosted: Mon Jun 04, 2007 10:11 pm    Post subject:
Reply with quote

It probably indicates a link edit error.

Make sure your program module picks up CICS version of DSNHLI stub, i.e. module named DSNCLI from within CICS library SDFHLOAD, during MVS BINDER step, i.e. MVS LINK EDIT.

Alex.
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 -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts Amount field is getting corrupted whe... thesumitk SYNCSORT 5 Tue Oct 18, 2016 8:20 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts Cobol EZASOKET call to SETSOCKOPT fails Andi1982 COBOL Programming 6 Thu Oct 06, 2016 7:12 pm


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