【DB2】db2生产应用监控

idata

1. #!/bin/ksh
   
2. #monitor db2 -----------------------------------------------------
   
3. v_dbname=spshis
   
4. 
   
5. mo_run(){
   
6. # run db2pd
   
7. start_or_not=`db2 -x "select count(*) from sysibmadm.SNAPAPPL where uow_stop_time is null and current timestamp- uow_start_time >5 with ur"`
   
8. start_or_not1=`uptime|awk -F"," '{print $6}'`
   
9. start_or_not2=`db2pd -d sample -lock wait|wc -l`
   
10. 
    
11. date >> monitor_log
    
12. 
    
13. if [ $start_or_not -gt 0 ];then
    
14. v_f=`date +%y%m%H%M%S`
    
15. 
    
16. start_or_not4=`db2 -x "select count(*) from sysibmadm.SNAPAPPL where uow_stop_time is null and current timestamp- uow_start_time >200 with ur"`
    
17. 
    
18. if [ $start_or_not4 -gt 0 ];then
    
19. db2pd -d $v_dbname -tran -dyn -lock wait -app >monitor_log"$v_f"
    
20. fi
    
21. 
    
22. db2 -x "select a.agent_id ,c.tpmon_client_wkstn ,b.stmt_text, current timestamp- a.uow_start_time used_time
    
23. from sysibmadm.SNAPAPPL a ,sysibmadm.SNAPSTMT b,sysibmadm.SNAPAPPL_INFO c
    
24. where a.agent_id=b.agent_id
    
25. and a.agent_id=c.agent_id
    
26. and a.uow_stop_time is null
    
27. and current timestamp- a.uow_start_time >5 with ur" >> monitor_log"$v_f"
    
28. 
    
29. #rmove wuxiao---
    
30. sh hj_file
    
31. 
    
32. sleep 20
    
33. return
    
34. fi
    
35. 
    
36. if [[ $start_or_not1 > 30 ]];then
    
37. v_f=`date +%d%m%H%M%S`
    
38. db2pd -d $v_dbname -tran -dyn -lock wait -app -latch>>monitor_log"$v_f"
    
39. 
    
40. sleep 20
    
41. return
    
42. fi
    
43. 
    
44. if [ $start_or_not2 -gt 5 ];then
    
45. v_f=`date +%d%m%H%M%S`
    
46. db2pd -d $v_dbname -tran -dyn -lock wait -app >>monitor_log"$v_f"
    
47. sleep 20
    
48. return
    
49. fi
    
50. 
    
51. }
    
52. 
    
53. db2 connect to $v_dbname > /dev/null
    
54. 
    
55. # run ever 20 second
    
56. second=0
    
57. while true
    
58. do
    
59. echo 'start-------------------'
    
60. mo_run
    
61. sleep 5
    
62. let second=${second}+5
    
63. if [ ${second} -gt 7200 ];then
    
64. break
    
65. fi
    
66. done
    
67. db2 terminate

复制代码

----如果发现新的功能 会更新该文件