使用腳本進行 db2 force application

轉自于http://www.db2china.net/home/space.php?uid=3126&do=blog&id=14286

下面一個腳本永遠斷開目前Cognos對于某一個DB2資料庫的連接配接

#!/usr/bin/ksh

# 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"| grep -i -w "BIBusTKServerM" | 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