降低高水位
db2 connect to xxxxxx
db2 alter tablespace DATA_4K reduce max

做Runstats操作
db2 connect to ${dbname}
for tabname in `db2 -x "select rtrim(tabschema)||'.'||tabname from syscat.tables where type='T'"`
do
        echo "----------------------------------- `date` -----------------------------"
        db2 -v "RUNSTATS ON TABLE ${tabname} ON ALL COLUMNS WITH DISTRIBUTION AND DETAILED INDEXES ALL ALLOW WRITE ACCESS"
done
echo "----------------------------------- `date` -----------------------------"
db2rbind ${dbname} -l db2rbind.log