IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

recovery from 904 ststus code


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Tim Jones

New User


Joined: 22 Jul 2011
Posts: 11
Location: USA

PostPosted: Mon Jun 04, 2012 6:33 pm
Reply with quote

I'm ttrying to reload the table. The first step is to DELETE OLD TABLE ROWS. This is where I am getting the -904. Can anybody tell me how to recover so I can reload the table ????

Thanks icon_confused.gif
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania

PostPosted: Mon Jun 04, 2012 6:43 pm
Reply with quote

If you use RESUME NO REPLACE option on the load then you do not have to delete the rows first.

Now you need to reset the Check Pending and/or the Recovery Pending Flags.

The try your load as stated above.
Back to top
View user's profile Send private message
Tim Jones

New User


Joined: 22 Jul 2011
Posts: 11
Location: USA

PostPosted: Tue Jun 05, 2012 12:13 am
Reply with quote

Thanks, It appears to have worked. I need to reset the flag and rebuild the indexes.

Thanks Again icon_biggrin.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
No new posts Monitoring production job progress. N... JCL & VSAM 4
Search our Forums:

Back to Top