Page 1 of 1

Database RW,UTUT Error - S04E loading data

Posted: Fri Dec 31, 2010 9:36 pm
by hparthas
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

Posted: Sun Jan 02, 2011 9:47 pm
by Natarajan
do you have step to remove copy pending status after load step?

Posted: Sun Jan 02, 2011 10:27 pm
by hparthas
Yes, I have included the step. Do you have any other to solve this !!!!

Thanks & Regards,
Harikrishnan

Posted: Mon Jan 03, 2011 6:12 pm
by Natarajan
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.

S04E S04E abend while loading.

Posted: Wed Jan 05, 2011 6:10 pm
by Natarajan
another reason why use job had failed is ..because of invalid data loading to the table.

Refer below ibm manual for S04E

Re: S04E S04E abend while loading.

Posted: Thu Jan 06, 2011 2:25 pm
by Anuj Dhawan
Natarajan wrote:Refer below ibm manual for S04E
I think you forgot to attach that, Natarajan.

Posted: Fri Jan 07, 2011 9:49 pm
by Natarajan
Oh.. thanks anuj for pointing out.

here is the link..

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

Posted: Sat Jan 08, 2011 2:52 pm
by Anuj Dhawan
You're welcome, Natarajan. :)

have a good one,

Topic deleted by Admin

Posted: Tue Jan 19, 2016 7:58 pm
by academyindia4
<< Content deleted By Admin >>

Topic deleted by Admin

Posted: Mon Feb 01, 2016 1:41 am
by academyindia4
<< Content deleted By Admin >>