#!/bin/bash

##################################################
# Author: QAD Inc. (eos@qad.com)
# Date: July-08-2011
#
# Script to analyse an the Table ReadVST information generated by the tableReadVST monitor
# - Created in response to an escalation -
#
# Please use at own risk.
#
# Usage
# -----
# For usage message run the script without any arguments
#
##################################################

#useage message
if [[ $# -lt 1 ]]; then
echo -e "
DESCRIPTION

This command analyses the output of the tableReadVST monitor

  It requires one comulsory argument

USAGE

   $0 <filename>
   where:
   <filename> - Compulsory
       Is the name of the dbactivityVST monitor file

OUTPUTS:
   <filename>-Processed.csv
"
exit
fi

##################
# Set up variables
##################

fName=$1
outFile=$fName-Processed.csv

##################
# Error checks ...
##################

if [ ! -e $fName ]; then
 echo -e "
   NOTE -
   Input file $fName does not exist, exiting
  "
 exit
fi

###############################################
more $fName | awk 'function printDif(prevSample,currSample){return (currSample - prevSample)}function parseTimeStamp(tStamp){split(tStamp,tStampNew,"+");return tStampNew[1];}BEGIN{FS=",";count=1;print "Time,%BufferHits,%APW_Writes,%BIW_Writes,%AIW_Writes,RecReads,RecUpdates,RecCreates,RecDeletes,RecLocks,RecWaits,DB_Reads,DB_Writes,BI_Writes,Transactions,Checkpoints";}{if(count == 2){prevRec["RecReads"]=$6;prevRec["RecUpd"]=$7;prevRec["RecCreate"]=$8;prevRec["RecDel"]=$9;prevRec["RecLocks"]=$10;prevRec["RecWaits"]=$11;prevRec["DB_Reads"]=$12;prevRec["DB_Writes"]=$13;prevRec["BI_Writes"]=$14;prevRec["Transactions"]=$15;prevRec["Checkpoints"]=$16;}else if(count > 2){print parseTimeStamp($1) "," $2 "," $3 "," $4 "," $5 "," printDif(prevRec["RecReads"],$6) "," printDif(prevRec["RecUpd"],$7) "," printDif(prevRec["RecCreate"],$8) "," printDif(prevRec["RecDel"],$9) "," printDif(prevRec["RecLocks"],$10) "," printDif(prevRec["RecWaits"],$11) "," printDif(prevRec["DB_Reads"],$12) "," printDif(prevRec["DB_Writes"],$13) "," printDif(prevRec["BI_Writes"],$14) "," printDif(prevRec["Transactions"],$15) "," printDif(prevRec["Checkpoints"],$16);prevRec["RecReads"]=$6;prevRec["RecUpd"]=$7;prevRec["RecCreate"]=$8;prevRec["RecDel"]=$9;prevRec["RecLocks"]=$10;prevRec["RecWaits"]=$11;prevRec["DB_Reads"]=$12;prevRec["DB_Writes"]=$13;prevRec["BI_Writes"]=$14;prevRec["Transactions"]=$15;prevRec["Checkpoints"]=$16;}count++;}' > $outFile