Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2007
    Posts
    62

    Unanswered: Kill db2 restore ?

    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

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    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.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Nov 2007
    Posts
    62
    Maybe someone knows how to identify THAT process ?

    V

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by vilius View Post
    Maybe someone knows how to identify THAT process ?
    ps -ef | grep -i restore

  5. #5
    Join Date
    Nov 2007
    Posts
    62
    Well thanks never knew it's that simple

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •