3 # Increase PAGE_SIZE 2 times of the default
4 # Set MAX_SYS_DB_SIZE=10485760
5 # Set MAX_DB_SIZE=104857600
6 # check all DDL Operations on bigger tables taking recordsize more than 1k
7 # DDL (create table,create index,drop table, drop index)
9 CSQL_CONF
=${PWD}/tools
/Pagesize
/csql.conf
11 if [ -s "$CSQL_CONF" ]
13 REL_PATH
=${PWD}/tools
/Pagesize
19 cp -f $REL_PATH/csql.conf
/tmp
20 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
21 echo USER_DB_KEY
=6666 >>/tmp
/csql.conf
22 echo PAGE_SIZE
=16384 >>/tmp
/csql.conf
23 echo MAX_SYS_DB_SIZE
=10485760 >>/tmp
/csql.conf
24 echo MAX_DB_SIZE
=104857600 >>/tmp
/csql.conf
26 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
27 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
35 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_8tab.sql
44 while [[ $i -lt 2001 ]];do
45 echo "INSERT INTO t8 VALUES($i,$i,'CSQL_Lakshya$i');"
47 done >>${REL_PATH}/insert_t8.sql
49 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insert_t8.sql
>/dev
/null
2>&1
52 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_8tab.sql
53 rm -f ${REL_PATH}/insert_t7.sql
59 echo "$i record inserted"
61 echo "DELETE FROM t8 WHERE f3!='CSQL_Lakshya';" >>${REL_PATH}/delete_t8.sql
63 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/delete_t8.sql
66 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_8tab.sql
67 rm -f ${REL_PATH}/insert_t8.sql
68 rm -f ${REL_PATH}/delete_t8.sql
74 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_8tab.sql
77 rm -f ${REL_PATH}/insert_t8.sql
78 rm -f ${REL_PATH}/delete_t8.sql
87 rm -f ${REL_PATH}/insert_t8.sql
88 rm -f ${REL_PATH}/delete_t8.sql