Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact

Oninit BenchIt Toolkit

Setup

The setup of the system is very straightforward, once the dbspaces have been built then buildcntl build will generate the standard database. However, if you have altered schema.sql you need to build the database by hand.

After building the core database it needs be loaded with the base data using buildcntl load. This will give you an unlogged system that is nearly ready to go, just turn on logging using your favoured means, i.e. ontape [ontape -s -U benchit] or ondblog [ondblog log benchit].

Note: If you have altered the base schema and the load fails then the most likely problem is the schema, just review the original schema and make sure the basic DDL is still the same.

During the runs some tables are dropped and rebuilt via benchcntl reset. This is not a good idea if ER is being tested. You will need to adjust the runbenchit script as shown below to run a custom reset.sql file.

The Tests

The runbenchit script, listed below controls the running of the actual tests

#! /bin/sh

version=`cat version`
version=`expr $version + 1`
echo $version > version
if [ ! -d results ]
then
    mkdir results
fi
RESHEAD=results/${version}

if [ ! -d "${RESHEAD}" ]
then
    mkdir ${RESHEAD}
fi

TTIME=300

#
# list of number of users to run
#
for RUN in 5 10 20 30
do
    echo RUN NUMBER ${RUN}
    date
    RESDIR=${RESHEAD}/run${RUN}

    echo Results saved to $RESDIR
    if [ ! -d "${RESDIR}" ]
        then
                mkdir ${RESDIR}
    fi

    #./benchcntl reset
        dbaccess benchit reset.sql >/dev/null 2>&1
    onmode -c
    echo Start Test
        echo ==========
    sleep 5
    onstat -z > /dev/null 2>&1
    ./benchit ${RUN} ${TTIME} $RESDIR
    echo End Test
        echo ========
    sleep 5
    ./benchcntl analyze >  ${RESDIR}/sumstat.out
    ./benchcntl info    >  ${RESDIR}/info.out
    ./benchcntl summary >> ${RESHEAD}/summary.out
    sleep 5
    onstat -a           >> ${RESDIR}/onstat
    cat ${RESHEAD}/summary.out
    sleep 5
    onmode -c
    sleep 5
    onmode -l; onmode -l; onmode -l; onmode -l
done

To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.