Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2013
    Posts
    3

    Unanswered: Stopping Runstats

    I have a server that has been performing runstats on a table for over 30 hours. I know I should be able to stop it with the term utility command but DB2 acts as if it is not a valid command. This is in DB2 9.7 FP6 64-bit. I've tried running the command a few different ways but am not sure that I ran it correctly. Can someone please provide me with the proper syntax to stop this runstats? Thanks!

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5

  3. #3
    Join Date
    Feb 2013
    Posts
    3
    Thanks Andy, but the runstats is not listed when listing applications, just when listing utilities.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    List application does not show which one is doing Runstats.

    Use this to get the ID to force:

    Code:
    select agent_id from sysibmadm.snapstmt where STMT_OPERATION = 'RUNSTATS'
    Andy

  5. #5
    Join Date
    Feb 2013
    Posts
    3
    Thank you. That didn't kill the runstats process but it did stop the runstatus from running on that table. It has now moved onto the next table. I'll keep an eye on it and see if it hangs anymore. Thanks again for 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
  •