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

This for the Extra question:

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

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

list history will tell last reog done

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?