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

AICA abend in DB2


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
feellikeneo

New User


Joined: 19 Mar 2007
Posts: 73
Location: Chennai

PostPosted: Thu Jan 29, 2009 8:36 pm
Reply with quote

We faced an AICA abend (running for a long time) for a CICS transaction. From Dump master we found that the looping occurred due to a perform statement. Below is the piece of code.

Code:
PARA-INSERT.
       
EXEC SQL
       INSERT INTO TXX TABLE
END-EXEC

<If we encounter a -911/-904 here we perform this same paragraph ( PERFORM PARA-INSERT THRU INSERT-EXIT) again. If we encounter more than thrice, we throw an error message and come out of the program>

INSERT-EXIT. EXIT.


We tried to simulate the same scenario by forcing -911. But the above piece of code worked fine (i.e tried performing INSERT para thrice and came out of the program throwing error message) and did not fail with AICA abend code.

Any particular reason for the AICA abend. Any help to simulate the AICA abend would also be useful.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Thu Jan 29, 2009 9:05 pm
Reply with quote

The CICS Messages and Codes says about AICA:
Quote:
Explanation: A task has been executing for longer than the runaway time interval (defined by the ICVR operand on the system initialization table macro, DFHSIT) without giving up control. The runaway task condition indicates a possible loop in the application.
The DB2 task may be running perfectly fine but you still get an AICA in CICS because the program has been running DB2 longer than the runaway task time interval. You need to consult with your CICS support person (and possibly DB2 support person) about the setting of the runaway time interval and why your transaction is getting the AICA. You may need to insert some CICS EXEC statement before jumping back into the DB2 code to ensure CICS doesn't think your program is looping when it isn't.
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 -> DB2

 


Similar Topics
Topic Forum Replies
No new posts ISAM and abend S03B JCL & VSAM 9
No new posts Abend S0C4 11 (Page Translation Excep... PL/I & Assembler 16
No new posts WER999A - UNSUCCESSFUL SORT 8ED U Ab... SYNCSORT 5
No new posts the system or user abend SF0F R=NULL COBOL Programming 0
No new posts Need to get an DLI abend like U0200 IMS DB/DC 2
Search our Forums:

Back to Top