#!/bin/ksh
#
# Scriptname  : $II_SYSTEM/ingres/scripts/abf_size.ksh
#
# Description : Checks the size of all applications
#
# Parameters  : None.
#
# Author      : M S Ramsay 26 June 1997
#
# History       Date      Name      Reason
#               ----      ----      ------
#               dd/mm/yy  xxx       xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
#
############################################################################
#
#Parameter validation
#

clear
SDS_scriptname="`basename $0`"
SDS_help=$1
if [[ $SDS_help != '' ]] && [[ $SDS_help != 'h' ]]
then echo "Error in script $SDS_scriptname - Parameter invalid"
     echo ""
     echo "Try:-"
     echo ""
     echo "h - Help"
     echo ""
     exit
fi
if [[ $SDS_help = 'h' ]]
then echo ""
     echo "Parameters:-"
     echo ""
     echo "None"    
     echo ""
     exit
fi
#
#Get a list of all databases in the ABF directory
#

SDS_abfdir=$(ingprenv1 ING_ABFDIR) #Get abf area.
SDS_dblist=$(ls -lA $SDS_abfdir |grep '^d' |awk '{print $9}')

#
#For each database get the relevant ABF apps.
#
SDS_grand_total_blocks=0
echo

for i in $SDS_dblist
do
        SDS_apps=$(ls -lA $SDS_abfdir/$i |grep '^d' |awk '{print $9}')
        SDS_total_blocks=0
	echo
	echo  "                            -----------                      "
	echo
        print "Calculating space used by ABF apps. in DB $i......."
	echo

#For each data location get the number of 512 blocks.

        for f in $SDS_apps
        do
                SDS_blocks=$(du $SDS_abfdir/$i/$f |awk '{print $1}')
                SDS_total_blocks=$(( SDS_total_blocks + SDS_blocks ))
        	SDS_kb=$(echo $SDS_blocks | awk '{printf "%10.0f",$1/2}')
        	SDS_mb=$(echo $SDS_kb     | awk '{printf "%7.2f",$1/1024}')
		printf "%-45s" "The space used by $f is "
        	print "$SDS_kb kb or $SDS_mb Mb."
        done

        SDS_kb=$(echo $SDS_total_blocks | awk '{printf "%10.0f",$1/2}')
        SDS_mb=$(echo $SDS_kb           | awk '{printf "%7.2f",$1/1024}')

        SDS_grand_total_blocks=$(( SDS_grand_total_blocks + SDS_total_blocks))
	echo
	printf "%-45s" "The total ABF space used for DB $i is "
        print "$SDS_kb kb or $SDS_mb Mb."
done

SDS_grand_total_kb=$(echo $SDS_grand_total_blocks | awk '{print $1/2}')
SDS_grand_total_mb=$(echo $SDS_grand_total_kb     | awk '{printf "%6.2f",$1/1024}')

echo
echo  "                            -----------                      "
echo
echo "\nThe grand total for ABF apps. on this installation is
$SDS_grand_total_kb kb or $SDS_grand_total_mb Mb\n"