db2 "connect to databasename user db2app using d"
while read test
do
echo $test
db2 "describe indexes for table SCOTT.IMAGE_$test "
db2 "drop index SCOTT.IMAGE_"$test"_1"
db2 "drop index SCOTT.IMAGE_"$test"_2"
db2 "drop index SCOTT.IMAGE_"$test"_3"
db2 "drop index SCOTT.IMAGE_"$test"_4"
db2 "drop index SCOTT.IMAGE_"$test"_5"
db2 "create index SCOTT.IMAGE_"$test"_1 on SCOTT.IMAGE_"$test" (DOCDATE ASC) PCTFREE 10"
db2 "RUNSTATS ON TABLE SCOTT.IMAGE_"$test" for INDEX SCOTT.IMAGE_"$test"_1 shrlevel reference"
db2 "create index SCOTT.IMAGE_"$test"_2 on SCOTT.IMAGE_"$test" (DOCID ASC) PCTFREE 10"
db2 "RUNSTATS ON TABLE SCOTT.IMAGE_"$test" for INDEX SCOTT.IMAGE_"$test"_2 shrlevel reference"
done < ADOC
while read idx
do
echo $idx
db2 "describe indexes for table SCOTT.IMAGE_$idx "
db2 "drop index SCOTT.IMAGE_"$idx"_1"
db2 "drop index SCOTT.IMAGE_"$idx"_2"
db2 "drop index SCOTT.IMAGE_"$idx"_3"
db2 "drop index SCOTT.IMAGE_"$idx"_4"
db2 "drop index SCOTT.IMAGE_"$idx"_5"
db2 "create index SCOTT.IMAGE_"$idx"_1 on SCOTT.IMAGE_"$idx" (DOCDATE ASC) PCTFREE 10"
db2 "RUNSTATS ON TABLE SCOTT.IMAGE_"$idx" for INDEX SCOTT.IMAGE_"$idx"_1 shrlevel reference"
db2 "create index SCOTT.IMAGE_"$idx"_2 on SCOTT.IMAGE_"$idx" (DOCID ASC) PCTFREE 10"
db2 "RUNSTATS ON TABLE SCOTT.IMAGE_"$idx" for INDEX SCOTT.IMAGE_"$idx"_2 shrlevel reference"
db2 "create index SCOTT.IMAGE_"$idx"_3 on SCOTT.IMAGE_"$idx" (MOBILENO ASC) PCTFREE 10"
db2 "RUNSTATS ON TABLE SCOTT.IMAGE_"$idx" for INDEX SCOTT.IMAGE_"$idx"_3 shrlevel reference"
db2 "create index SCOTT.IMAGE_"$idx"_4 on SCOTT.IMAGE_"$idx" (VOLUMENO ASC) PCTFREE 10"
db2 "RUNSTATS ON TABLE SCOTT.IMAGE_"$idx" for INDEX SCOTT.IMAGE_"$idx"_4 shrlevel reference"
done < AIDX
db2 "disconnect databasename "
阅读(1088) | 评论(0) | 转发(0) |
