Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    42

    Unanswered: How to pause online index reorg?

    Hi All,

    I'm using db2 v8 on linux. I can see that it is possible to pause online (i.e. inplace) table
    reorg and then resume it. But the same functionality is not avaiable for index reorgs.
    Is there any workaound for this? I have a script that reorgs the database and pauses the reorg if the CPU load gets too high. I miss the pause mechanism for the index reorgs.

    I have an extra question. Is it recorded somewhere in the system catalog when was the last time a table/index reorg done?

    Thanks in advance.

    Alexander

  2. #2
    Join Date
    Feb 2007
    Posts
    31
    This for the Extra question:

    you can use
    db2pd -db <dbname> -reorg or

    select * from table (sysproc.snapshot_tabreorg('dbname',-1)) as tb
    Regards
    Mohan

  3. #3
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    list history will tell last reog done
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  4. #4
    Join Date
    Nov 2003
    Posts
    42

    thanks

    Thank you for the replies!

    About my main question I guess best I can do is to set utility throttling to min value, find best time at night when the system is least used and hope for the best.

    In v9 it is possible to reorg an index at a time and eventually avoid reorg if the system seems used by the users.

    Are there any other handles I can use to minimize impact on the production system?

Posting Permissions

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