IBM MAINFRAME HELP & SUPPORT FORUMS

EnjoyMF · Joined: 27 May 2005 Posts: 92

Hi Guys

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,plz reply me as early as possible

Cheers...Prasad

ikumar · Joined: 02 Aug 2005 Posts: 85

Can you give us any spool displays...So that we can help you more.

kanak · Joined: 12 Mar 2005 Posts: 259 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.

MSreelatha · Guest

Prasad

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)
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

mlp · Guest Joined: 23 Sep 2005 Posts: 1

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.

athul009 · Guest Joined: 09 Oct 2007 Posts: 5 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!!