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
 

 

SYSTEM = 04E REASON CODE = 00E70007

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
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    Post subject: SYSTEM = 04E REASON CODE = 00E70007
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    Post subject:
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: 2150
Location: At my coffee table

PostPosted: Fri May 30, 2008 11:01 pm    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Mon Jun 09, 2008 8:03 pm    Post subject: Reply to: SYSTEM = 04E REASON CODE = 00E70007
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    Post subject:
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

Site Director


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

PostPosted: Mon Jul 07, 2008 9:02 pm    Post subject: Reply to: SYSTEM = 04E REASON CODE = 00E70007
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    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm
No new posts How system know which REXX to excute? jackzhang75 CLIST & REXX 14 Thu Jul 06, 2017 1:09 am
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am


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