Performance Test - tc6_run.sh

[Lee-Sangmin-70]

HOST="192.168.1.105" PORT="20301" CONNTYPE="1"

THREADS="32" RECORDS="200000" UNIT="1000" THRESHOLD="100000" CAP="0" USER="SYS" PASSWORD="MANAGER" OPTION="DSN=$HOST;PORT_NO=$PORT;CONNTYPE=$CONNTYPE"

./configure.sh is -f tc6_init.sql make clean make

echo

case $CONNTYPE in "1" ) export ISQL_CONNECTION="TCP" ;; "2" ) export ISQL_CONNECTION="UNIX" ;; "3" ) export ISQL_CONNECTION="IPC" ;; esac echo

HOST="192.168.1.106" PORT="20301" OPTION="DSN=$HOST;PORT_NO=$PORT;CONNTYPE=$CONNTYPE"

START="0" for THREAD in $THREADS do ./bmt_insert $THREAD $START $RECORDS $UNIT $THRESHOLD $CAP $USER $PASSWORD $OPTION START=expr $START + $RECORDS done

HOST="192.168.1.107" PORT="20301" OPTION="DSN=$HOST;PORT_NO=$PORT;CONNTYPE=$CONNTYPE"

for THREAD in $THREADS do ./bmt_insert $THREAD $START $RECORDS $UNIT $THRESHOLD $CAP $USER $PASSWORD $OPTION START=expr $START + $RECORDS done

HOST="192.168.1.108" PORT="20301" OPTION="DSN=$HOST;PORT_NO=$PORT;CONNTYPE=$CONNTYPE"

for THREAD in $THREADS do ./bmt_insert $THREAD $START $RECORDS $UNIT $THRESHOLD $CAP $USER $PASSWORD $OPTION START=expr $START + $RECORDS done

HOST="192.168.1.112" PORT="20301" OPTION="DSN=$HOST;PORT_NO=$PORT;CONNTYPE=$CONNTYPE"

for THREAD in $THREADS do ./bmt_insert $THREAD $START $RECORDS $UNIT $THRESHOLD $CAP $USER $PASSWORD $OPTION START=expr $START + $RECORDS done

HOST="192.168.1.113" PORT="20301" OPTION="DSN=$HOST;PORT_NO=$PORT;CONNTYPE=$CONNTYPE"

for THREAD in $THREADS do ./bmt_insert $THREAD $START $RECORDS $UNIT $THRESHOLD $CAP $USER $PASSWORD $OPTION START=expr $START + $RECORDS done

HOST="192.168.1.105" PORT="20301"

is -f tc6_conf.sql is -f tc6_rebuild.sql

[Lee-Sangmin-70]

tc6_run.sh