CALL SYSPROC.REORGCHK_TB_STATS('S','DB2INST');

select * from session.TB_stats where reorg like '%*%';

select coalesce ('db2 -v reorg table ' || rtrim(a.tabschema) || '.' || rtrim(a.tabname) || ' index ' || coalesce(max(case indextype when 'CLUS' 
then rtrim(indschema) || '.' || rtrim(indname) end), max(case uniquerule
when 'P' then rtrim(indschema) || '.' || rtrim(indname) end), max(case iid
when 1 then rtrim(indschema) || '.' || rtrim(indname) end)) || ' allow no access;',
'date;db2 -v reorg table ' || rtrim(a.tabschema) || '.' || rtrim(a.tabname) || '
allow no access;') from syscat.tables a left outer join syscat.indexes b on
a.tabschema = b.tabschema and a.tabname = b.tabname where
rtrim(a.tabschema) || '.' || rtrim(a.tabname) in (select
rtrim(table_schema)||'.'||rtrim(table_name) from session.TB_stats where
reorg like '%*%') group by a.tabschema, a.tabname;

select 'db2 -v runstats on table '||rtrim(table_schema)||'.'||rtrim(table_name)||
' with distribution on key columns and indexes all;'
from session.TB_stats where reorg like '%*%';

CALL SYSPROC.REORGCHK_IX_STATS('S','DB2INST');
select 'db2 -v reorg indexes all for table
'||rtrim(TABLE_SCHEMA)||'.'||TABLE_NAME||' allow no access;'
from session.IX_stats where reorg like '%*%';