106: ISAM error: non-exclusive access的处理办法脚本

gu14

1. if [ $# != 2 ]
   
2. then
   
3. echo Usage: $0 dbname tbname
   
4. exit
   
5. fi
   
6. 
   
7. TMPFILE=$$.fifo
   
8. dbaccess $1 <<! 1>null
   
9.        unload to "$TMPFILE"
   
10.        Select hex(partnum) from systables where tabname = "$2";
    
11. !
    
12. str=`cat $TMPFILE|awk -F "|" '{print $1}'|sed -e 's/0x//g'`
    
13. #echo $str
    
14. onstat -g opn|grep -i "$str"|head -1
    
15. str=`onstat -g opn|grep -i "$str"|head -1|awk '{print $2}'|sed -e 's/^0x//g'|sed
    
16. -e 's/^0//g'`
    
17. #echo $str
    
18. ses=`onstat -u |grep "$str"|awk '{print $3}'`
    
19. onstat -g ses $ses>$TMPFILE
    
20. pid=`cat $TMPFILE|sed -n '6,6p'|awk '{print $5}'`
    
21. echo "查表信息:"
    
22. cat $TMPFILE
    
23. echo "进程信息:"
    
24. ps -ef|grep $pid
    
25. echo "\n\n锁表进程PID:$pid 数据库sid: $ses"
    
26. echo "可使用onstat -g ses <sid> 或 kill <pid> 终止进程\n"
    
27. rm -rf $TMPFILE
    

复制代码

wolfop

informix杀线程要小心，呵呵。