3 # Create table t1 in Target DB and insert 5 records in TDB.
4 # Cache t1 table using cachetable -t option
5 # Create table t2 at CSQL and insert 5 records
6 # Both Cached and Non-Cached tables should be durable
8 CSQL_CONF
=${PWD}/cache
/Durability
/csql.conf
10 if [ -s "$CSQL_CONF" ]
12 REL_PATH
=${PWD}/cache
/Durability
16 cp $CSQL_CONFIG_FILE /tmp
/csql.conf
17 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
19 echo CACHE_TABLE
=true
>>$CSQL_CONFIG_FILE
20 echo DURABILITY
=true
>>$CSQL_CONFIG_FILE
21 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
22 echo SYS_DB_KEY
=2288 >>$CSQL_CONFIG_FILE
23 echo USER_DB_KEY
=3377 >>$CSQL_CONFIG_FILE
24 DS
="$DSN $DBUSER $PASSWORD"
25 rm -f /tmp
/csql
/csqlds.conf
/tmp
/csql
/csqltable.conf
26 touch /tmp
/csql
/csqlds.conf
/tmp
/csql
/csqltable.conf
31 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
37 echo INSERTING
5 RECORDS IN TARGET DB
38 isql
$DS < ${REL_PATH}/create_insert_attdb.sql
>/dev
/null
2>&1
41 isql
$DS < ${REL_PATH}/drop_t1.sql
45 isql
$DS < ${REL_PATH}/select_t1.sql
48 isql
$DS < ${REL_PATH}/drop_t1.sql
52 # Setup Environment For site
53 # RUN CSQL SERVER at site
54 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
58 echo "CACHING THROUGH SITE1"
59 echo "cachetable -U root -P manager -t t1"
60 $CSQL_INSTALL_ROOT/bin
/cachetable
-U root
-P manager
-t t1
64 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
65 isql
$DS < ${REL_PATH}/drop_t1.sql
69 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_insert_at_csql.sql
73 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
74 isql
$DS < ${REL_PATH}/drop_t1.sql
75 $CSQL_INSTALL_ROOT/bin
/cachetable
-U root
-P manager
-t t1
-u
79 $CSQL_INSTALL_ROOT/bin
/csqldump
-X >before.sql
82 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
86 echo "Durablity = TRUE"
88 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
91 echo "Checking Durability"
92 $CSQL_INSTALL_ROOT/bin
/csqldump
-X >after.sql
93 diff before.sql after.sql
96 echo Durability Works Fine
98 echo Durability Does Not work fine
101 $CSQL_INSTALL_ROOT/bin
/cachetable
-U root
-P manager
-t t1
-u
105 rm -f before.sql after.sql
106 rm -M 2288 -M 3377 -M 1947 -Q 2525
110 isql
$DS < ${REL_PATH}/drop_t1.sql
114 rm -f before.sql after.sql
115 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
119 echo "drop table t2;" >${REL_PATH}/drop_t2.sql
120 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t2.sql
122 rm -f ${REL_PATH}/drop_t2.sql
123 rm -f before.sql after.sql
126 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525