|
View previous topic :: View next topic
|
| Author |
Message |
EnjoyMF
New User
Joined: 27 May 2005
Posts: 88
|
|
|
|
I am working with COBOL DB2 IMS program...
when i submit my RunJCL..my program is getting abend with S04E
ie..At the point of SQL statement it is getting abended ( till the SQl statement 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 |
|
 |
ikumar
New User
Joined: 02 Aug 2005
Posts: 81
|
|
|
|
| Can you give us any spool displays...So that we can help you more. |
|
| Back to top |
|
|
kanak
Moderator
Joined: 12 Mar 2005
Posts: 252
Location: India
|
|
|
|
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 |
|
|
MSreelatha
Guest
|
|
|
|
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
|
|
|
|
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 |
|
|
athul009
New User
Joined: 09 Oct 2007
Posts: 7
Location: US
|
|
|
|
| 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
tags is more than enough |
|
| Back to top |
|
|
umasankarmf
New User
Joined: 08 Sep 2008
Posts: 43
Location: india
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
It's been just 4-years when the original question was posted, hope OP still follow up his posts...  |
|
| Back to top |
|
|
rakesha.hg
Active User
Joined: 21 Mar 2008
Posts: 161
Location: bangalore
|
|
|
|
Anuj,
i'm following it ... i had one today ... this post helped  |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| Great... |
|
| Back to top |
|
|
Balamurugan3
Currently Banned
New User
Joined: 02 Sep 2009
Posts: 14
Location: chennai
|
|
|
|
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 |
|
|
|
|
