2 # With param,insert 5 stmt, upd 2 stmt, del 1 stmt, select 2 record
3 # check stmt and redo logs. Recover and check logs
5 CSQL_CONF
=${PWD}/durability
/redologs
/csql.conf
9 REL_PATH
=${PWD}/durability
/redologs
15 cp -f $REL_PATH/csql.conf
/tmp
16 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
17 echo ID_SHM_KEY
=6666 >>/tmp
/csql.conf
18 echo DURABILITY
=true
>>/tmp
/csql.conf
19 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
22 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
26 echo "CREATE TABLE t1(f1 int, f2 int);" >${REL_PATH}/t1.sql
28 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/t1.sql
33 rm -f ${REL_PATH}/t1.sql
37 $CSQL_INSTALL_ROOT/bin
/redo
-al
43 echo "Checking Durability"
44 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
49 $CSQL_INSTALL_ROOT/bin
/redo
-al
51 rm -f ${REL_PATH}/t1.sql