#!/bin/sh
# Program:      ck_ai
# Purpose:      To determine how many full ai extents there are per database
# Author:       Adam Backman
# Date:         04/29/98
#
SCRIPTS=${SCRIPTS-/u3/users/adamb/scripts}
HOSTNAME=`hostname`
PARAM1=${1-all}
export SCRIPTS HOSTNAME

case $PARAM1 in

all|ALL|All)
for i in `grep $HOSTNAME $SCRIPTS/live/db.registry | cut -s -f 1 -d "|" `
do
        if [ $i != "#DB" ]
        then
                . $SCRIPTS/live/read_registry $i

        if [ $? = "0" ] 
        then
                FULL_EXT=`rfutil $DB_DIR/$DB -C aimage extent list | grep -i full | wc -l`
        echo "There are $FULL_EXT Full extents for database $DB"
        fi
        fi
done
;;
*)
. $SCRIPTS/live/read_registry $1

case $? in
2)
echo "Database $1 is not in database registry"
exit 1
;;
3)
echo "Database $1 is on $HOST on on this host"
exit 1
;;
esac
FULL_EXT=`rfutil $DB_DIR/$DB -C aimage extent list | grep -i full | wc -l`
echo "There are $FULL_EXT Full extents for database $DB"
;;
esac