DB2 reorg runstats rebind specific operation

DB2 reorg runstats rebind specific operation

#reorg table
Db2-x "SELECT ' reorg table ' | | RTrim (Tabschema) | | tabname| | '; ' from syscat.tables where type= ' T ' "> Reorg.sql

#reorg Index
Db2-x "SELECT ' reorg indexes all for table ' | | RTrim (Tabschema) | | tabname| | '; ' from syscat.tables where type= ' T ' "> Reorg_index.sql

#runstats table
Db2-x "SELECT ' runstats on table ' | | RTrim (Tabschema) | | tabname| | ' and indexes all, ' from syscat.tables where tabschema= ' nrwausr ' and type= ' T ' "> Runstats.sql

# rebind
Db2-x "SELECT ' rebind package ' | | RTrim (Pkgschema) | | pkgname| | '; ' from Syscat.packages where Pkgschema isn't in (' Nullid ') and pkgschema= ' Nrwausr ' "> Rebind.sql

DB2-TVF reorg.sql-z Reorg_error.log
DB2-TVF reorg_index.sql-z Reorg_index.log
DB2-TVF runstats.sql-z Runstats_error.log
DB2-TVF rebind.sql-z Rebind_error.log

DB2 reorg runstats rebind specific operation