IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Abend AEY9 with CICS DB2 program


IBM Mainframe Forums -> CICS
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Mon Sep 17, 2007 12:42 pm
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
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
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
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
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: 193
Location: chennai

PostPosted: Thu Oct 23, 2008 12:07 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CICS

 


Similar Topics
Topic Forum Replies
No new posts Using API Gateway from CICS program CICS 0
No new posts ISAM and abend S03B JCL & VSAM 9
No new posts Calling an Open C library function in... CICS 1
No new posts How to 'Ping' a CICS region in JCL CICS 2
No new posts Parallelization in CICS to reduce res... CICS 4
Search our Forums:

Back to Top