#!/bin/ksh
#
# Scriptname  : $II_SYSTEM/ingres/scripts/db_size.ksh
#
# Description : Checks the size of all databases on a given installation.
#
# Parameters  : None.
#
# Author      : M S Ramsay 26 June 1997
#
# History       Date      Name      Reason
#               ----      ----      ------
#               19/05/98  MSR       -s flag no longer required (OpenIngres)
#               10/11/98  MSR       Amended to use awk for the arithmetic
#
############################################################################
#
#Parameter validation
#

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 on the current installation.
#

SDS_dblist=$(sql  iidbdb <<EOT | awk -F\| '{ print $2 }' | sed -e '/name/d;/^$/d'
select (name)
from iidatabase
where dbservice !=1
order by name ; \g
EOT)

#
#For each database get the locations for the data areas.
#
SDS_grand_total_blocks=0
echo

for i in $SDS_dblist
do
        SDS_dataarea=$(infodb $i -s |grep DATA |awk '{print $3}')  # 6.4
       #SDS_dataarea=$(infodb $i    |grep DATA |awk '{print $3}')  # OI
        SDS_total_blocks=0

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

        for f in $SDS_dataarea
        do
                SDS_blocks=$(du $f |awk '{print $1}')
                SDS_total_blocks=$(( SDS_total_blocks + SDS_blocks ))
        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))
	printf "%-40s" "The space used by $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 "\nThe grand total for databases on this installation is
$SDS_grand_total_kb kb or $SDS_grand_total_mb Mb\n"