- 批量添加数据文件
#!/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
人大金仓KES V7 批量添加数据文件
于 2023-09-04 16:49:42 首次发布