We help IT Professionals succeed at work.
Get Started

Unable to kill Incomplete Db2 Restore: How can I use extreme force/Abort to release the databse?

Enyimba
Enyimba asked
on
5,138 Views
Last Modified: 2015-03-01
Hi Database Gurus,

I did a redirected restore on a DB2 database using a backup image from a production instance, generated the script, made neccessary changes to the script - ran the set tablespaces commands, changed the container paths and all looked well. After runnig the redirect script, I observed that it appeared to have hanged. Now I am in the situation that if I issue a restore complete it says "DB21080E No previous RESTORE DATABASE command with REDIRECT...." and if I try to do anything else that involves a connection (including trying to drop the damn database) I get "SQL1119N A connection to or activation of database "RAPMT02" cannot be made because a previous restore is incomplete. SQLSTATE=57019".

I have tried "DB2 restore...ABORT..." with no success. I do a ps -ef | grep - restore, get the PID and have also tried to kill
-9 PID but that did not allow me to connect to the database either giving me the "DB21080E No previous RESTORE DATABASE command with REDIRECT....".

I will like not to have to drop the Database. So anyone have any ideas? Can I salvage the restore? If not how can I remove the damaged db so I can start again? If possible, I appreciate an answer tonight as I am working to fix this problem on a deadline.



Thanks all
Comment
Watch Question
Data Warehouse / Database Architect
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE