Kill db2 restore ?

vilius · #1 (**permalink**) 10-21-10, 08:24

Hello,

db2 v9.5 AIX v6.1.
How do I terminate/kill running db2 restore ?
I don't care about db state which is beeing restored.

For backups I was able to kill them by using "force application" command because backup program is listed as db2 application. In case of restore I have doubts that restore application will be listed using "list applications".

thanks
Vilius

Cougar8000 · #2 (**permalink**) 10-21-10, 10:35

how can it be listed if db2 is not up yet

find a process that is running it and kill it on the os level if you do not care about it.

vilius · #3 (**permalink**) 10-21-10, 11:27

Maybe someone knows how to identify THAT process ?

V

n_i · #4 (**permalink**) 10-21-10, 12:01

Quote:

Originally Posted by vilius

Maybe someone knows how to identify THAT process ?

ps -ef | grep -i restore

vilius · #5 (**permalink**) 10-21-10, 12:33

Well thanks

never knew it's that simple

db2girl · #6 (**permalink**) 10-21-10, 18:52

I'd suggest to use the force application command to terminate a running restore (you'll see it in the list applications output). Do not use db2_kill or some other OS command to kill the process unless it's absolutely necessary. Killing it will crash the entire instance.

Cougar, Happy B-day!

Internet Services

Web Development

Digital Marketing

Consumer Tech