Listing 2 chrt.sh

#!/bin/ksh
#*********************************************************************
# Listing 2
# File : chrt.sh
#
# Description:
#  
# This file  shows us the date and the size of the database 
# for any full month worth of data.
#
# Author: John Ouellette
#
#*********************************************************************

if [ -z "$3" ];then
echo syntax $0 db month year
exit
fi

DB=$1
MNTH=$2
YEAR=$3
SUM=/nsr/res/sum.txt

#Parallel
cd /nsr/res/savegroups/$YEAR/$MNTH
for EACH  in  `grep -l $DB.sh *.rpt`

do
        SIZE=`grep  -i $DB  $EACH |grep -i 'level=full' | cut -d" " -f14`
        DATE=`ls $EACH | cut -d"-" -f1-3`
        echo $DATE:$SIZE
done

cd ->/dev/null
exit
#*********************************************************************

Here is chrt.sh in action:

[root@server01 /nsr/res ]./chrt.sh db_fin01 August 2004

2004-August-01:144
2004-August-02:111
2004-August-03:130
2004-August-04:155
2004-August-05:126
2004-August-06:147
2004-August-07:135
2004-August-08:137
2004-August-09:124
2004-August-10:160
2004-August-11:144
2004-August-12:150
2004-August-13:143
2004-August-14:150
2004-August-15:145
2004-August-16:123
2004-August-17:131
2004-August-18:149
2004-August-19:148
2004-August-20:155
2004-August-21:149
2004-August-22:140
2004-August-23:136
2004-August-24:132
2004-August-25:148
2004-August-26:154
2004-August-27:171
2004-August-28:154
2004-August-29:150
2004-August-30:134
2004-August-31:129