#!/bin/ksh 
#
# Scriptname  : $II_SYSTEM/ingres/scripts/db_size.ksh
#
# Description : Checks the current checkpoint usage of all databases on a given installation.
#
# Parameters  : $1 = f
#
# Author      : M S Ramsay 20 October 1999
#
# History       Date      Name      Reason
#               ----      ----      ------
#               xx/xx/xx  xxx       xxxxxxxxxxxxxxxxxxxxxxxx
#
############################################################################
#
#Parameter validation.
#

SDS_scriptname="`basename $0`"
SDS_runtype=${1:-b}

if [[ $SDS_runtype != 'b' ]] && [[ $SDS_runtype != 'f' ]] && [[ $SDS_runtype != 'h' ]]
then echo "" 
     echo "ERROR in script $SDS_scriptname - Variable \$1 is invalid.  Should not be $1."
     echo ""
     echo "Try:-"
     echo ""
     echo "b - Basic output"
     echo "f - Full output"
     echo "h - Help"
     echo ""
     exit
fi

if [[ $SDS_runtype = 'h' ]] 
then echo ""
     echo "Parameters:- "
     echo ""
     echo "b - Basic output"
     echo "f - Full output"
     echo "h - Help"
     echo ""
     exit
fi

clear
echo "*********************************************************************"
echo ""
echo "Run type is set to $SDS_runtype.  Where b is Basic and F is Full".
echo ""
echo "*********************************************************************"
echo ""
echo ""
echo ""
echo "====================================================================="

#
#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 checkpoint areas.
#
SDS_grand_total_blocks=0
echo

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

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

        for f in $SDS_chkarea
        do
		if [[ -d $f ]]
                then SDS_list=$(ls -lA $f |awk '{print $5,"       ",$9}')
		     SDS_blocks=$(du $f |awk '{print $1}')
                     SDS_total_blocks=$(( SDS_total_blocks + SDS_blocks ))
		else :
		fi
        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))
	if [[ $SDS_runtype = "f" ]] 
	then echo "Information for database $i"
	     echo ""
	fi
	printf "%-40s" "Space used by Ckp's of $i is "
        print "$SDS_kb kb or $SDS_mb Mb."

	if [[ $SDS_runtype = "f" ]] && [[ $SDS_kb -eq 0 ]]
	then echo "====================================================================="
	fi
	if [[ $SDS_runtype = "f" ]] && [[ $SDS_kb -ne 0 ]]
	then echo ""
	     echo "The above space allocation consists of the following files"
	     echo ""
	     echo "Size		Filename"
	     echo "$SDS_list"
	     echo ""
	     echo "====================================================================="
	fi
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 all checkpoints on this installation is
$SDS_grand_total_kb kb or $SDS_grand_total_mb Mb\n"