Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
S04E abend with COBOL DB2 IMS program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
EnjoyMF

New User


Joined: 27 May 2005
Posts: 88

PostPosted: Sat Sep 24, 2005 12:30 pm    Post subject: S04E abend with COBOL DB2 IMS program
Reply with quote

I am working with COBOL DB2 IMS program...

when i submit my RunJCL..my pgram is getting abend with S04E

ie..At the point of SQL statement it is getting abended ( till the SQl satement steps
it is working fine"

I suppose it is DB2 internal abend

BUT HOW CAN I RESOLVE THIS S04E Error, plz reply me as early as possible


Cheers...Prasad
Back to top
View user's profile Send private message

ikumar

New User


Joined: 02 Aug 2005
Posts: 81

PostPosted: Sun Sep 25, 2005 8:15 pm    Post subject: Re: S04e abend
Reply with quote

Can you give us any spool displays...So that we can help you more.
Back to top
View user's profile Send private message
kanak

Moderator


Joined: 12 Mar 2005
Posts: 252
Location: India

PostPosted: Mon Sep 26, 2005 11:55 am    Post subject:
Reply with quote

As per my manual:

Explanation: When the system detects an error in internal IBM DATABASE 2 (DB2(TM)) processing, it will abnormally end a connected user task (TCB) or one of its own internal tasks. For information about the reason codes associated with this abend code, see DB2 Messages and Codes.
System Action: The system abnormally ends the connected user task or the DB2 internal task.

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.
Back to top
View user's profile Send private message
MSreelatha

Guest





PostPosted: Mon Sep 26, 2005 3:18 pm    Post subject: s04e Abend
Reply with quote

Prasad

S04E error means Duplicate utility id has been created. If your job abends in your run it creates a duplicate utility id. if you submit the same job again without terminating the duplicate utility id then you get so4e error.

You can terminate this utility id in two ways
1. by writing Utility termination step in your jcl (or)
2. In Tso Db2 --select--BMC Administrative Products for DB2 --catalog manager for db2--db2 commands--go for utility termination option
--but this access may only have db2 dba.

Thanks
Sreelatha
Back to top
mlp

New User


Joined: 23 Sep 2005
Posts: 91

PostPosted: Fri Nov 16, 2007 6:27 pm    Post subject: Re: s04e Abend
Reply with quote

The Abend can also occur when there is some problem in the index space. By rebuilding the index space the problem can be resolved.

We also faced similar problem and it was resolved by rebuilding the index space.
Back to top
View user's profile Send private message
athul009

New User


Joined: 09 Oct 2007
Posts: 7
Location: US

PostPosted: Thu May 01, 2008 10:06 pm    Post subject: Re: s04e Abend
Reply with quote

MSreelatha wrote:

So4e error means Duplicate utility id has been created. If your job abends in your run it creates a duplicate utility id. if you submit the same job again without terminating the duplicate utility id then you get so4e error.
You can terminate this utility id in two ways
1. by writing Utility termination step in your jcl (or)


I am using DSNUPROC utility to Unload the Db2 table. And, I got SB37 Error. I increased the SPACe for the Data file; and submitted the job again. And, I got S04E error (Duplicate utility id )!

how do I write Utility termination step in the JCL? Can anyone show me an example? I have attached the JCL for my Unload utility here.
Thanks!!


topic edited to delete the attachment
( useless anyhow for the problem determination and resolution of the current issue )

nest time, please, do not post a jpeg,
a simple plain text cut and paste with the
Code:
tags is more than enough
Back to top
View user's profile Send private message
umasankarmf

New User


Joined: 08 Sep 2008
Posts: 43
Location: india

PostPosted: Fri Aug 21, 2009 7:45 pm    Post subject: Abend Code S04E
Reply with quote

Hi guyes,

If u have Abend Code S04E then something is wrong at the DB2 data. Verify the data then submit the job.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Aug 24, 2009 4:40 pm    Post subject: Reply to: S04e abend with COBOL+DB2+IMS program
Reply with quote

It's been just 4-years when the original question was posted, hope OP still follow up his posts... icon_biggrin.gif
Back to top
View user's profile Send private message
rakesha.hg

Active User


Joined: 21 Mar 2008
Posts: 161
Location: bangalore

PostPosted: Wed Aug 26, 2009 4:15 pm    Post subject: Reply to: S04e abend with COBOL+DB2+IMS program
Reply with quote

Anuj,

i'm following it ... i had one today ... this post helped icon_lol.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Aug 27, 2009 6:50 pm    Post subject:
Reply with quote

Great...
Back to top
View user's profile Send private message
Balamurugan3
Currently Banned

New User


Joined: 02 Sep 2009
Posts: 14
Location: chennai

PostPosted: Tue Sep 29, 2009 4:05 pm    Post subject:
Reply with quote

Hi Msreelatha,

I got the same error S04E while unloading the data from table, for the same reason duplicate utility...

It showed error msg "LOAD UTILITY WITH UTILID = IZLOAD1 ENDED IN PHASE = REPORT, WILL ATTEMPT TO RESTART(CURRENT)
DSNUGUTC - UTILITY 'LOAD' INCONSISTENT WITH LAST INVOCATION "




So i tried for the solution given by u.. terminating utility...


with the foll jcl...

//TERM EXEC PGM=IKJEFT01
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2F)
-TERM UTILITY(IZLOAD1)
/*


It shows error "USER CIZ012 NOT AUTHORIZED FOR
UTILID = IZLOAD1 "


I tried even with master ID which is having all access considering it is a authorization problem.....


But i couldnt find a way... it shows same error msg...


Can u help me reg this... is this a issue with the ID i am using or else am i going wrong somewhere ...


Thank u in advance....
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 ASP3 ABEND IN CICS Vedant CICS 0 Fri Oct 20, 2017 3:18 pm
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us