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 with CICS DB2 program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
mallireddy06

New User


Joined: 05 Feb 2007
Posts: 10
Location: india

PostPosted: Mon Sep 17, 2007 12:19 pm    Post subject: Abend AEY9 with CICS DB2 program
Reply with quote

Hi

i am getting AEY9 abend when i am executing cics,db2 program, this is information screen geeting data form db2 and displaying in cics screen,
please find the screen shot below and let me know your suggestions.

---------------------------------------------------------------------------------
CA-InterTest for CICS r7 - PROTSYM FILE SOURCE LISTING BREAKPOINT
COMMAND ===>
Program= KILAWATC Option # Stmt # Margin= 01
Search=
OPTS 1 Proc div 2 Work-stor 3 Link sect 4 D-map 5 Clst/Pmap 6 Data xref
7 Proc xref 8 Err msgs 9 Srch fwd 10 Srch bwd 11 Ind cmds 12 Bkpt opts
PFKS 1 Help 2 3 Det Bkpt 4 Profile 5 RESUME 6 Menu
7 Backward 8 Forward 9 10 001 Verb 11 Backtrace 12 Status
---------+---------------------------------------------------------------------
01440*****END-EXEC
_ 01441 PERFORM SQL-INITIAL UNTIL SQL-INIT-DONE
A ==> CALL 'DSNHLI' USING SQL-PLIST4 ==>
==> CICS abend intercepted. Abend code = AEY9. after an external CALL.
==>
==> Press PF1 for a detailed description.
==>
_ 01443 IF SQLCODE = +000 AND CAL-TIMESTAMP-IND NOT = -1
01444***** EXEC SQL
01445***** SELECT CAL_OLD_POL,
01446***** CAL_OLD_CLI,
01447***** CAL_NEW_CLI,
01448***** cal_type,
01449***** cal_stat,
---------------------------------------------------------------

i am waiting for your suggestion,

Thanks
mallireddy
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 17, 2007 12:42 pm    Post subject:
Reply with quote

Hello,

Check and see if DB2 is up (or was up when this failed).
Back to top
View user's profile Send private message
mallireddy06

New User


Joined: 05 Feb 2007
Posts: 10
Location: india

PostPosted: Mon Sep 17, 2007 1:26 pm    Post subject:
Reply with quote

hi dick,


yes, it is failing when db2 is up
Back to top
View user's profile Send private message
namitjai

New User


Joined: 12 Feb 2008
Posts: 41
Location: Bangalore

PostPosted: Wed Oct 22, 2008 11:51 am    Post subject:
Reply with quote

Hi,

I am getting an AEY9 abend while running the transaction. As of now I am doing these steps let me know where I need to be corrected:
My online application has 3 programs, main program(MPGM) and two sub programs. My main program is a CICS pgm with no DB2 statements program while subprograms are CICS-DB2 programs. So I am creating packages for all three and creating single plan for them. After this I defined the DB2CONN entry in CICS with the name of DB2 region and group name. After that I INSTALLED the DB2CONN through CEDA INSTALL DB2CONN command. But while running the transactio I am getting AEY9 abend and it is issued at my first EXEC SQL statement.
Please let me know what is required to be done..
Thanks,
Back to top
View user's profile Send private message
Soundammal.S

New User


Joined: 05 May 2008
Posts: 29
Location: Chennai

PostPosted: Wed Oct 22, 2008 1:45 pm    Post subject: AEY9 Abend
Reply with quote

Kindly check whether you have made DB2ENTRY and DB2TRAN definitions corresponding to the transaction you are invoking.
Back to top
View user's profile Send private message
namitjai

New User


Joined: 12 Feb 2008
Posts: 41
Location: Bangalore

PostPosted: Wed Oct 22, 2008 2:48 pm    Post subject:
Reply with quote

Is it necessary to define DB2TRAN and DB2ENTRY because I read that DB2 TRAn is not necessary to initiate cics db2 trans. We can go ahead with just DB2CONN defined. Document says:
You can start the CICS DB2 connection with only a DB2CONN installed--you do not need any DB2ENTRY and DB2TRAN definitions to make the connection. If you do this, there are no special threads for key transactions (entry threads). All transactions use general-purpose threads from the pool, and the most important transactions have to wait just as long as the least important transactions to get their individual connection into DB2. To ensure that your important transactions are prioritized, create DB2ENTRY and, if necessary, DB2TRAN definitions for them
Back to top
View user's profile Send private message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 186
Location: chennai

PostPosted: Thu Oct 23, 2008 12:07 am    Post subject:
Reply with quote

Hi namitjai

AEY9 abend normally comes when there is no connection between CICS and DB2. To check this try a single program using DB2 and CICS and make sure that CICS attachement facility(CICS DB2 Connection) is active.Normally this is automatic( when CICS is statred DB2CONN also started automatically to a specified DB2 region mentioned in DFHSIT)

If CICS attachment facility is active check the RCT entry( DB2Entry ) of the program. Make sure that the PLAN name specified in the DB2Entry is used to bind the PACKAGE.

Hope this will help you.
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts Asynchronous CICS Processing Question moezbud CICS 0 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm


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