schema.sql has the basic schema representation of the tables used. This is the schema build when the program buildcntl build is run.
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.
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
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.