|
View previous topic :: View next topic
|
| Author |
Message |
Neha Gupta
New User
Joined: 19 Jun 2009
Posts: 2
Location: Chennai
|
|
|
|
Hi All,
I tried some experimentation with LOAD and came across lot of errors.
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?
 |
|
| Back to top |
|
 |
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
| Try to terminate the utility which holds the DB2 object. |
|
| Back to top |
|
|
Neha Gupta
New User
Joined: 19 Jun 2009
Posts: 2
Location: Chennai
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| Why don't you get in contact with your DBA? |
|
| Back to top |
|
|
|
|
