Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2011
    Location
    Columbus, OH
    Posts
    55

    Unanswered: How to find and kill a reorg process

    I am running DB2 LUW 9.5. Today I accidentally executed a script that began reorging many tables in a production database. I did not know of a way to find the process that was running the reorg and kill it. I know how to kill the process, but I don't know how to find process I want to kill. Does anyone have any ideas?

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Do not kill db2 processes. Instead, identify an application handle and terminate it using FORCE APPLICATIONS. One way is to capture an application snapshot and look for 'Statement = Reorganize' in the output.

  3. #3
    Join Date
    Aug 2011
    Location
    Columbus, OH
    Posts
    55
    Thanks db2girl, I have a followup question to your respone. I'm not sure how to identify the applicaiton handle. Can you please provide more detailed information on how to do this. I ran a 'db2 GET SNAPSHOT FOR ALL APPLICATIONS' I did not find a 'Statement = Reorganize' could that be because the reorg isn't currently running? Thanks again!

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    grep for Reorganize in the snapshot output. If nothing comes back, then most likely reorg isn't currently running. You can also see some reorg info with db2pd -reorg and list history reorg.

  5. #5
    Join Date
    Aug 2011
    Location
    Columbus, OH
    Posts
    55
    Thanks db2girl!

Posting Permissions

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