使用脚本进行 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