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

SYSTEM = 04E REASON CODE = 00E70007


IBM Mainframe Forums -> ABENDS & Debugging
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
arnab

New User


Joined: 13 Mar 2006
Posts: 59
Location: UK

PostPosted: Fri May 30, 2008 10:46 pm
Reply with quote

Hi,

Can anyone help me to resolve this abend ? There is no Dump formatter to format the SYUDUMP that I am getting. We have IPCS but for this abend only SYSUDUMP gets produced so IPCS would not be of musch help.

From the DB2MSTR job the following message can be ssen:
14.39.43 STC14768 DSN3201I <DB2P ABNORMAL EOT IN PROGRESS FOR 820
820 USER=MQP1APP CONNECTION-ID=PROD CORRELATION-ID=0060JIEV
820 JOBNAME=MRPRODF ASID=00B9 TCB=008E2228

The SYSUDUMP shows:
0COMPLETION CODE SYSTEM = 04E REASON CODE = 00E70007

PSW AT ENTRY TO ABEND 077C1001 93293FD4 ILC 02 INTC 000D
0PSW ADDRESS 13293FD4 AT TIME OF ERROR DOES NOT POINT TO AN ACTIVE MODULE

Could you please let me know the probable causes for this kind of an abend.? This seems to be an internal DB2 error but not sure what statement is causing it as it happens quite frequently.
Please help.
Back to top
View user's profile Send private message
anv2005

New User


Joined: 14 Jul 2005
Posts: 44
Location: US

PostPosted: Fri May 30, 2008 10:58 pm
Reply with quote

DB2 Messages and Codes manual reads: "00E70007
Explanation: A bad application-supplied address was encountered while trying to copy SQLCA back to the application program."

See the complete message text at:
00E70007

Take a look at SYMPTOM DUMP and SYSUDUMP (you may want to get SVC dump or SYSABEND dump at least) to diagnose the actual problem.

What DB2 attachment do you use? Locate application SQLCA. It could be a memory overlay related issue.

Alex.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Fri May 30, 2008 11:01 pm
Reply with quote

04E

Explanation: When the system detects an error in internal IBM
DATABASE 2(*) (DB2(*)) processing, it will abnormally end a connected
user task (TCB) or one of its own internal tasks.

Source: DFSMSdfp

System Action: The system abnormally ends the connected user task or
the DB2 internal task.

Application Programmer Response: Check register 15 of the SDWA
section 'General Purpose Registers at Time of Error', and locate the
accompanying reason code. In addition, check the information
displayed at the user's terminal, and in the corresponding logrec data
set entry.

System Programmer Response: If the error recurs and the program is
not in error, look at the messages in the job log for more
information. Search problem reporting data bases for a fix for the
problem. If no fix exists, contact the IBM Support Center. Provide
the SYSOUT output for the job and the logrec data set error record.
Back to top
View user's profile Send private message
anv2005

New User


Joined: 14 Jul 2005
Posts: 44
Location: US

PostPosted: Fri May 30, 2008 11:12 pm
Reply with quote

DB2 terminates abnormally a thread within the client TCB's using ABEND code 04E upon many error conditions. It is VERY important to look at the exact reason code associated with the ABEND code 04E.

The current reason code is 00E70007. Hence, it's necessary to look at the exact explanation for this reason code.

Regards,
Alex.
Back to top
View user's profile Send private message
arnab

New User


Joined: 13 Mar 2006
Posts: 59
Location: UK

PostPosted: Sat May 31, 2008 8:00 pm
Reply with quote

Many thanks to everyone..
Back to top
View user's profile Send private message
arnab

New User


Joined: 13 Mar 2006
Posts: 59
Location: UK

PostPosted: Mon Jun 09, 2008 6:51 pm
Reply with quote

Hi Again,

I traced the programs and recreated the i/p in TEST environment. This is working fine in my test environment but failing in Acceptance Test and prod environment. I tried recompiling in A/T environment, but it is still failing with same error.

Could you please help me regarding this ?
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Mon Jun 09, 2008 8:03 pm
Reply with quote

very little we can do from here...
Work with Your support group to
find the differences between the test and the acceptance/prod environment
and modify things accordingly

it' a mission of support to provide similar/same environment setup
in order to avoid the issue You are just facing
Back to top
View user's profile Send private message
arnab

New User


Joined: 13 Mar 2006
Posts: 59
Location: UK

PostPosted: Mon Jul 07, 2008 7:11 pm
Reply with quote

Hiya,

Thanks to everyone for their help on this issue. I finally managed to find the root cause of this issue and resolved it.

The problem was with a module referencing outside the array bounds. Since the SSRANGE option was not on, this was not being handled causing the program to fail at some other point with a S04E.

The search for SQLCA from the SYSUDUMP gave a lot of information about the input string , so I could recreate the same in my test environment and finally find the RC.

Thanks again to everyone for their help and support..!

Cheers,
Arnab
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 Jul 07, 2008 9:02 pm
Reply with quote

Hello Arnab,

Good to hear it is resolved - thanks for lettng us know icon_smile.gif

d
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 -> ABENDS & Debugging

 


Similar Topics
Topic Forum Replies
No new posts Sysplex System won't IPL at DR site I... All Other Mainframe Topics 2
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts Reorg abended with REASON=X'00E40347' DB2 2
No new posts REASON 00D70014 in load utility DB2 6
Search our Forums:

Back to Top