Saturday, September 13, 2008

DB2 GENERATE MAINTENANCE COMMAND

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

No comments: