#!/bin/ksh -x
db2 connect to DB_NAME
for i in `db2 list tables for schema SCHEMA_NAME|grep SCHEMA_NAME|awk '{print $1'}`
do
db2 set current schema SCHEMA_NAME
db2 import from /dev/null/ of del replace into $i
db2 "reorg table $i"
done
exit
åå®æ¸
空表çå¨ä½åéè¦åä¸æ¬¡reorgè¿æ ·ç©ºé´æä¼åæ¶ï¼
å®äºåä¸æ¬¡runstats ç¶åå¯ä»¥éè¿Questå·¥å
·ççæ¯ä¸æ¯ææç表çrowé½ä¸º0
温馨提示:答案为网友推荐,仅供参考