DB2导出所有table的runstat sql

dmewy

SELECT 'runstats on table $1'||'.'||TABNAME||' on all columns with distribution and detailed indexes all allow write access;' FROM SYS
CAT.TABLES WHERE TABSCHEMA='$1' and TYPE in ('T','S') order by 1" >> $SqlFile
 
 
其中$1是schema