kingbaseESV7批量添加数据文件

#!/bin/bash
LD_LIBRARY_PATH=/home/kingbase/KingbaseES/bin:/home/kingbase/KingbaseES/lib:/home/kingbase/KingbaseES/unixodbc/lib
DBNAME=ABC
DATE=`date '+%Y%m%d_%H%M%S'`
 
for i  in {1..200}
do
isql -h127.0.0.1 -USYSTEM -WMANAGER -c "ALTER TABLESPACE SYSTEM ADD DATAFILE (NAME=${DBNAME}_${DATE}_${i} FILENAME='${DBNAME}_${DATE}_${i}.dbf' SIZE=200 MAXSIZE=16000 filegrowth=10);"  ${DBNAME}
done
 
for i in {1..100}
do 
isql -h127.0.0.1 -USYSTEM -WMANAGER -c "ALTER SYSTEM ADD LOGFILE(NAME=LOG${i} FILENAME='LOG${i}.lf' size=2000);"  ${DBNAME}
done