Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 785
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 Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm
This topic is locked: you cannot edit posts or make replies. ERROR WHILE SUBMITTING LOAD JOB ANURADHA NEELAKANTAN JCL & VSAM 12 Thu Aug 25, 2016 11:50 am
No new posts Execute multiple DB2 Load commands in... faizm DB2 4 Wed Aug 03, 2016 12:53 pm
No new posts Search a Load Module sreekanth1984 TSO/ISPF 8 Tue Jun 07, 2016 8:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us