#!/bin/ksh
# Program:      db_status
# Purpose:      This script acts as a wrapper for the chk_db_status 
#               script.  Allowing one or all databases to be checked 
#               at the same time.
# Syntax:       db_status < all | dbname >
# Author:       Adam Backman
# Date:         04/28/98
#
SCRIPTS=/u3/users/adamb/scripts
HOSTNAME=`hostname`
export SCRIPTS HOSTNAME

case $1 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
                        echo "" >/dev/null
                else
                        $SCRIPTS/live/chk_db_status $i
                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 not on this host"
                exit 1
        ;;
        esac
        $SCRIPTS/live/chk_db_status $1
;;
esac