#!/usr/bin/ksh
# Script to calculate # of commits and rollbacks from a trace file
# Takes trace file as input
#
# XCTEND rlbk=%d rd_only=%d
# ----------------------------------------------------------------------------
#  XCTEND      A transaction end marker.
#  rlbk        1 if a rollback was performed, 0 if no rollback (commit).
#  rd_only     1 if transaction was read only, 0 if changes occurred.
grep XCTEND $1  > /tmp/read.lst
commit=`grep XCTEND /tmp/read.lst | grep "rlbk=0, rd_only=0" | wc -l`
trans=`grep XCTEND /tmp/read.lst | wc -l`
rollback=`grep XCTEND /tmp/read.lst | grep "rlbk=1, rd_only=0" | wc -l`
echo " "
echo "Transactions"
echo "~~~~~~~~~~~~"
echo "Transaction Ends  $trans"
echo "Real Commits      $commit"
echo "Rollbacks         $rollback"