Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Problems by LOAD termiation in RELOAD

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Neha Gupta

New User


Joined: 19 Jun 2009
Posts: 2
Location: Chennai

PostPosted: Fri Jun 19, 2009 1:35 pm    Post subject: Problems by LOAD termiation in RELOAD
Reply with quote

Hi All,

I tried some experimentation with LOAD and came across lot of errors.
icon_redface.gif

I terminated LOAD in RELOAD phase and obviously table went into RECP and RDBP status. Now problem occurred when i saw that there exists no image copy to recover the table back. But i used
-START DB() SPACNAM() ACCESS(FORCE)
to remove RECP status. But RDBP still exist. So when i tried running REBUILD INDEX then it failed saying dupilcate exists.
Can anyone suggest what can i do in this case?
icon_confused.gif
Back to top
View user's profile Send private message

Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 788
Location: Chennai, India

PostPosted: Fri Jun 19, 2009 1:43 pm    Post subject:
Reply with quote

Try to terminate the utility which holds the DB2 object.
Back to top
View user's profile Send private message
Neha Gupta

New User


Joined: 19 Jun 2009
Posts: 2
Location: Chennai

PostPosted: Fri Jun 19, 2009 7:49 pm    Post subject:
Reply with quote

Table is in RW status only. I want to make table accessible again. So i tried running UNLOAD again ,it went on fine. SO before running LOAD i tried taking image copy but it failed with abend
UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'0B37'
UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40347

And when i checked its status it was in UTRO so i started the database again & its back to RW mode. Now will image copy run properly?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Jun 22, 2009 3:38 pm    Post subject:
Reply with quote

Why don't you get in contact with your DBA?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us