# script forces off all users of a specified database.  
#   The database name is passed in as a parameter.

if [ $# -ne 1 ]                                         
then
        echo "\n\n\n\n"
        echo "  Wrong number of parms, needs:"                 
        echo "  1 - Database name"                             
        echo "\n\n\n\n"
        exit 1                                                
fi
if [ -f /home/db2inst1/sqllib/db2profile ]; then
    . /home/db2inst1/sqllib/db2profile
fi
dbname=`echo $1 | tr 'a-z' 'A-Z'`
Connections=/home/db2inst1/out/$dbname.connections
db2 list applications | grep -i -w " $dbname" | cut -c '25-32' > $Connections
while read applid                                                             
do                                                                            
    set $applid                                                               
    db2 "force application ("$applid")"                                       
done < $Connections                                                           

RC=`db2 list applications | grep -i -w " $dbname" | wc -l`
exit $RC