Checking reorg status

Often we schedule our reorgs during off peak hours when nobody is watching . If you are paranoid like me, you would also be wondering whether those reorgs ran and how long they ran, did it run within the maintanence window,  is it slow and so on.   Here is an sql that can check the table reorg status and the amount of time it took for each table.

select rtrim(substr(table_schema,1,10))as “Schema”,rtrim(substr(table_name,1,29)) as “Table_name”,
case reorg_status
  when 1 then ‘Started’
  when 2 then ‘Paused’
  when 3 then ‘Stopped’
  when 4 then ‘Completed’
  when 5 then ‘Truncated’
end as status,
(minute(reorg_end – reorg_start)) as “Minutes_Ran”
from table(sysproc.snapshot_tbreorg(”,-1))as t where date (reorg_start) > (current_date – 3 day) order by reorg_start desc;