Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Posts
    21

    Unanswered: Killing a process

    In the datawarehouse, an update process is running. It's taking too long, so I want to kill it. Does anyone know how to do this? What happens if it is demoted to development while it is running? Thanks.

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    kill

    db2 list applications show detail
    db2 force application(xx)
    this will do
    Best Regards, Guy Przytula
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Feb 2005
    Posts
    21
    Thanks a lot. How about demoting a process while it is running?

  4. #4
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by rhayabusa
    Thanks a lot. How about demoting a process while it is running?
    No no, do not do that , if you are runing an update process and you kill the process with force command , your process will go to rollback process and you will be in trouble, you should kill the process (as a root) by unix command

    kill -9 .....
    sometime even this command does not work and you should use db2_kill command
    at the worst case you should reboot the system.

  5. #5
    Join Date
    Feb 2005
    Posts
    21
    Thanks a bunch M RAS. I appreciate the help.

Posting Permissions

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