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.
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.
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!!