View previous topic :: View next topic
|
Author |
Message |
mallireddy06
New User
Joined: 05 Feb 2007 Posts: 10 Location: india
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Check and see if DB2 is up (or was up when this failed). |
|
Back to top |
|
|
mallireddy06
New User
Joined: 05 Feb 2007 Posts: 10 Location: india
|
|
|
|
hi dick,
yes, it is failing when db2 is up |
|
Back to top |
|
|
namitjai
New User
Joined: 12 Feb 2008 Posts: 41 Location: Bangalore
|
|
|
|
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 |
|
|
Soundammal.S
New User
Joined: 05 May 2008 Posts: 29 Location: Chennai
|
|
|
|
Kindly check whether you have made DB2ENTRY and DB2TRAN definitions corresponding to the transaction you are invoking. |
|
Back to top |
|
|
namitjai
New User
Joined: 12 Feb 2008 Posts: 41 Location: Bangalore
|
|
|
|
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 |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008 Posts: 193 Location: chennai
|
|
|
|
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 |
|
|
|