db2 reorg

1.reorgchk update statistics on table all
2.(1) reorg table
      reorg table maximo.po use tempspace1
  (2) reorg index all
      reorg indexes all for table maximo.po use tempace1
  (3) reorg tale with one index
      reorg table maximo.po index index1 use tempace1
3.runstats
  runstats on table maximo.po with distribution and detailed indexes all
4.reorgchk

P.S.(1)Pause reorg:
        db2 reorg table schema.table inplace pause
    (2) resume reorg
        db2 reorg table schema.table inplace resume
   
List all tables
db2 SELECT 'REORG TABLE', CONCAT(RTRIM(SUBSTR(TABSCHEMA,1,15)),CONCAT('.',RTRIM(SUBSTR(TABNAME,1,32)))), ';' FROM SYSCAT.TABLES WHERE TYPE = 'T'