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
 

 

AEY9 Abend with program using DB2 connection

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

New User


Joined: 11 Mar 2009
Posts: 28
Location: India

PostPosted: Tue May 05, 2009 10:39 am    Post subject: AEY9 Abend with program using DB2 connection
Reply with quote

Hi,

We are getting AEY9 abend in CICS region, and program using DB2 connection. I have checked DB2 connection and they are fine as well as TCB limit also.....but still we are finding this abend.

Please advice on it....
Back to top
View user's profile Send private message

Garry Carroll

Active Member


Joined: 08 May 2006
Posts: 995
Location: Dublin, Ireland / Edinburgh, Scotland

PostPosted: Tue May 05, 2009 12:51 pm    Post subject:
Reply with quote

What have you tried to diagnose this? Try running the task in EDF to see what command is failing or examine the trace in a dump.

Garry.
Back to top
View user's profile Send private message
aishwarya_20

New User


Joined: 19 Nov 2008
Posts: 57
Location: pune

PostPosted: Tue May 05, 2009 1:17 pm    Post subject: Reply to: AEY9 Abend
Reply with quote

DB2 could be down, This is the only reason. Try after some time.
Back to top
View user's profile Send private message
Garry Carroll

Active Member


Joined: 08 May 2006
Posts: 995
Location: Dublin, Ireland / Edinburgh, Scotland

PostPosted: Tue May 05, 2009 1:50 pm    Post subject:
Reply with quote

In the explanation for AEY9, no specific mention is made of DB2, so DB2 being down is not the only reason.

Quote:
AEY9

Explanation: One of the following:

o

o An EXEC CICS command has been issued that is not supported by the EXEC
interface program DFHEIP.

o 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.

o 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.

o An attempt has been made to use remote resources, but the local SYSID
has been specified in an EXEC CICS command, or vice versa.

o An attempt has been made to use remote resources, but ISC is not
supported.

o An EXEC CICS command contains an invalid AID or CONDITION identifier.
This indicates that the EXEC CICS command has become corrupted.
System Action: The transaction is abnormally terminated with a CICS
transaction dump.

User Response: Check that the sysid specified and the resource names were
correct. If not, notify the system programmer. Either the command (or an
application stub) has become corrupted, or the unavailable function needs
to be generated (CICS command), ENABLEd (non-CICS command), or
exceptionally the non-CICS support has suffered damage and is attempting
to withdraw itself from the CICS system.

Module(s): DFHEIP, DFHEEI


Garry.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue May 05, 2009 2:01 pm    Post subject:
Reply with quote

at the top of every page in this site is a 'download' button.

one of the offerings is something called ABEND Assistant.
I have found that it saves me a lot of time
when I am too lazy to look-up an error code in the manuals.

I think Garry's suggestion should be followed,
and
would like aishwarya_20 to explain his post:

Quote:
DB2 could be down, This is the only reason. Try after some time.
Back to top
View user's profile Send private message
aishwarya_20

New User


Joined: 19 Nov 2008
Posts: 57
Location: pune

PostPosted: Tue May 05, 2009 2:11 pm    Post subject:
Reply with quote

From my hands on experience i have learnt that some times AEY9 could occur due to DB2 problem. In my case it was DB2 Bind which worked.

One of the explanation above indirectly points to this :-

An attempt has been made to use remote resources, but the local SYSID
has been specified in an EXEC CICS command, or vice versa.
Back to top
View user's profile Send private message
cicsknow

New User


Joined: 11 Mar 2009
Posts: 28
Location: India

PostPosted: Tue May 05, 2009 3:54 pm    Post subject:
Reply with quote

Thanks for your reply on it,

But as far as checking on this abend, we have monitored DB2 system and CICS system during connection started and both are up during that time and CICS successfully connected also to DB2 system..

But, still we are getting this abend, As far as this abend occur in program which provided by our vendor....and its in load module form so cant see a code also...

is there any possibility of SIT parameter or any CICS side setup........
Back to top
View user's profile Send private message
aishwarya_20

New User


Joined: 19 Nov 2008
Posts: 57
Location: pune

PostPosted: Tue May 05, 2009 4:00 pm    Post subject:
Reply with quote

You can debug it by using CEDF command..... and also try rebinding the program and then do NEWCOPY and submit.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8118
Location: East Dubuque, Illinois, USA

PostPosted: Tue May 05, 2009 5:19 pm    Post subject:
Reply with quote

Is this a new application that you're testing? If so, the configuration may not be right -- SYSID for example could be incorrectly specified. If it is an existing application, what changed? Start by identifying the changed components and how they impacted the system.
Back to top
View user's profile Send private message
cicsknow

New User


Joined: 11 Mar 2009
Posts: 28
Location: India

PostPosted: Tue May 05, 2009 5:31 pm    Post subject:
Reply with quote

Thanks a lot for help,

But we solved problem, because they need some IP socket config.

Thanks & regards
Back to top
View user's profile Send private message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 193
Location: chennai

PostPosted: Thu May 07, 2009 1:53 am    Post subject: Reply to: AEY9 Abend with program using DB2 connection
Reply with quote

Hi cicsknow

Thanks for the last post regarding the solution of the problem.

But I am surprised that you are advised for a REBIND and NEWCOPY.

Quote:
You can debug it by using CEDF command..... and also try rebinding the program and then do NEWCOPY and submit.


What is the need for a REBIND in AEY9 abend. RE(BIND) is required for an SQLCODE of -805 because of the timestamp in the load module and the timestamp in the validated DBRM is not matching. In your case the transaction is not able to connect to DB2. Then there is no question of
RE(BIND). Actually we are doing a BIND not a REBIND. Repeatedly doing BIND is not REBIND. There are special situations where we go for a REBIND.
But debug using CEDF is a good advise.

Regards
Raghu
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 Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm
No new posts C03 ABEND sjiraga PL/I & Assembler 1 Thu Jun 01, 2017 4:51 pm
No new posts COBOL DB2 program - zIIP eligible vasanthz COBOL Programming 7 Wed May 31, 2017 5:12 am


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