Oninit BenchIt Toolkit

schema.sql

schema.sql has the basic schema representation of the tables used. This is the schema build when the program buildcntl build is run.

reset.template

The standard schema doesn't use fragmentation; reset.template is the SQL that will need to be modified to reflect your fragmentation. The template needs to be renamed reset.sql before it will be used.

dbspace.sh

The script dbspaces.sh builds the dbspaces the test expects to see, and this script will need to be modified to accommodate the server environment, either edit BENCHDIR or set BENCHDIR in your current environment. The name of the actual dbspaces should not be altered.

 
#! /bin/ksh

BENCHDIR=${BENCHDIR:=/data/benchmark}

if [ ! -d ${BENCHDIR} ]
then
    echo "Error: Directory ${BENCHDIR} found"
    exit
fi

for I in 0 1 2 3 4 5 6 7 8 9
do
    touch ${BENCHDIR}/disk${I}
    ln -s ${BENCHDIR}/disk${I} ${BENCHDIR}/datadbs${I}
    chown informix:informix ${BENCHDIR}/disk${I}
    chmod 660 ${BENCHDIR}/disk${I}
done





onspaces -c -d batdbs   -p ${BENCHDIR}/datadbs0 -o 0       -s 100000
onspaces -c -d acctdbs  -p ${BENCHDIR}/datadbs1 -o 0       -s 2097152
onspaces -a    acctdbs  -p ${BENCHDIR}/datadbs2 -o 0       -s 2097152
onspaces -a    acctdbs  -p ${BENCHDIR}/datadbs3 -o 0       -s 2097152
onspaces -a    acctdbs  -p ${BENCHDIR}/datadbs4 -o 0       -s 2097152
onspaces -a    acctdbs  -p ${BENCHDIR}/datadbs5 -o 0       -s 2097152
onspaces -a    acctdbs  -p ${BENCHDIR}/datadbs6 -o 0       -s 2097152
onspaces -a    acctdbs  -p ${BENCHDIR}/datadbs7 -o 0       -s 2097152
onspaces -a    acctdbs  -p ${BENCHDIR}/datadbs8 -o 0       -s 2097152
onspaces -a    acctdbs  -p ${BENCHDIR}/datadbs9 -o 0       -s 2097152
onspaces -c -d hist0dbs -p ${BENCHDIR}/datadbs1 -o 2097152 -s 2097152
onspaces -c -d hist1dbs -p ${BENCHDIR}/datadbs2 -o 2097152 -s 2097152
onspaces -c -d hist2dbs -p ${BENCHDIR}/datadbs3 -o 2097152 -s 2097152
onspaces -c -d hist3dbs -p ${BENCHDIR}/datadbs4 -o 2097152 -s 2097152
onspaces -c -d hist4dbs -p ${BENCHDIR}/datadbs5 -o 2097152 -s 2097152
onspaces -c -d hist5dbs -p ${BENCHDIR}/datadbs6 -o 2097152 -s 2097152