Database RW,UTUT Error - S04E loading data

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
hparthas
Member
Posts: 43
Joined: Thu Oct 21, 2010 11:17 pm

Database RW,UTUT Error - S04E loading data

Post by hparthas » Fri Dec 31, 2010 9:36 pm

Hi,

My job is trying to load DB2 table. When I try to load the database my job failed with S04E return code.

When I check this, I found that the database is in RW,UTUT status.

I have cleared this through TERM UTILID and the database was in RW status again.

When I re-start the job again after some time and above process, still my job is failing with below error message.

Code: Select all

 DSNT360I  -DB2T ***********************************                     
 DSNT361I  -DB2T *  DISPLAY DATABASE SUMMARY                             
                 *    GLOBAL                                             
 DSNT360I  -DB2T ***********************************                     
 DSNT362I  -DB2T     DATABASE = D0155CCC  STATUS = RW                   
                    DBD LENGTH = 117092                                 
 DSNT397I  -DB2T                                                         
 NAME     TYPE PART  STATUS            PHYERRLO PHYERRHI CATALOG  PIECE 
 -------- ---- ----- ----------------- -------- -------- -------- ----- 
 SZQHI    TS         RW,UTUT                                             
 ******* DISPLAY OF DATABASE D0155CCC ENDED      ********************** 
 DSN9022I  -DB2T DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION           

Is there any other way to solve this issue ASAP, this is daily load DB process and my job failed.

Any help would be great !!!!

Thanks & Regards,
Harikrishnan

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

Post by Natarajan » Sun Jan 02, 2011 9:47 pm

do you have step to remove copy pending status after load step?
Natarajan
Chennai

hparthas
Member
Posts: 43
Joined: Thu Oct 21, 2010 11:17 pm

Post by hparthas » Sun Jan 02, 2011 10:27 pm

Yes, I have included the step. Do you have any other to solve this !!!!

Thanks & Regards,
Harikrishnan

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

Post by Natarajan » Mon Jan 03, 2011 6:12 pm

Try to contact your DBA group to solve this issue.
If you feel , the problem is with your jcl. post the jcl step that you have used.
so that we can analyse and tell some suggestion, if any changes are required.

another suggestion is , get DB2 e-book , where you have load jcl explained well.
since you have complete 15 posts, you are eligible to get DB2 e-book.
Natarajan
Chennai

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

S04E S04E abend while loading.

Post by Natarajan » Wed Jan 05, 2011 6:10 pm

another reason why use job had failed is ..because of invalid data loading to the table.

Refer below ibm manual for S04E
Natarajan
Chennai

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Re: S04E S04E abend while loading.

Post by Anuj Dhawan » Thu Jan 06, 2011 2:25 pm

Natarajan wrote:Refer below ibm manual for S04E
I think you forgot to attach that, Natarajan.
Regards,
Anuj

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

Post by Natarajan » Fri Jan 07, 2011 9:49 pm

Oh.. thanks anuj for pointing out.

here is the link..

http://publibz.boulder.ibm.com/cgi-bin/ ... 4240&CASE=
Natarajan
Chennai

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Sat Jan 08, 2011 2:52 pm

You're welcome, Natarajan. :)

have a good one,
Regards,
Anuj

academyindia4

Topic deleted by Admin

Post by academyindia4 » Tue Jan 19, 2016 7:58 pm

<< Content deleted By Admin >>

academyindia4

Topic deleted by Admin

Post by academyindia4 » Mon Feb 01, 2016 1:41 am

<< Content deleted By Admin >>

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others