SELECT 'DB2 REORG TABLE ' || RTRIM(TABSCHEMA) || '.' || TABNAME FROM SYSCAT.TABLES WHERE TYPE <> 'V'
GO
SELECT 'DB2 RUNSTATS ON TABLE ' || RTRIM(TABSCHEMA) || '.' || TABNAME FROM SYSCAT.TABLES WHERE TYPE <> 'V'
GO
SELECT 'DB2 REBIND ' || RTRIM(PKGSCHEMA) || '.' || PKGNAME FROM SYSCAT.PACKAGES
Saturday, September 13, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment