ECIF系统巡检步骤及问题

1、ecif系统巡检计划:1、etl服务器检查:1：对目前的作业的情况进行全面检查.涉及最及报出来的问题。2：对etl服务器日志文件大小的检查2、ap应用服务检查脚本:#!/bin/bash#此脚本是为了系统巡检#auth： rain#/bin/bash system_check.sh >ecif_check_sys log &&iconv f utf8 t gbkecif_check_sysog >system.doc &&rm -rf ecif_check_sys.log cpu_01='cat /proc/cpuinfo |grep &qu

2、ot;physical id" |sort |uniq|wc -pcpu_02二、cat /proc/cpuinfo |grep "processor1'|wc -pcpu_03='cat /proc/cpuinfo |grep "cores” | uniq |awk -f: 'print $2*'cpu_04='cat /proc/cpuinfo |grep mhz |uniq |awk -f: 'print $2八cpu_05='uname -r'cpu_06='head -n 1 /et

3、c/issuexcpu_07='hostname'cpu_08='env |grep path'cpu_09='grep memfree /proc/meminfo'cpu_10='df -h'cpu_ll='uptime'pu_12=、cat /proc/loadavg'cpu_13='ifconfig |grep minet addr*11grep -v m127.0.0.r | awk -f: fprint $2* | awk sprint $1*' cpu_14=7usr/sbin/

4、dmidecode | grep -a 16 ”memory device'1 | grep e "size | locator" | grep -v bank、cpu_15='grep memtotal /proc/meminfox#需要进入到各模块下、检查日志文件空间cd /home/ecif/各模块cpu_16=、df h、cd /home/ecif/各模块cpu_17=、dfcd /home/ecif/各模块cpu_18=df -h'day01='date +%y'dayo2='date +%m'dayo3=&

5、#39;date +%d'echo -e $day01年$day02月$day03系统巡检报告echo -e 服务器 ip： "t"$cpu_13echo -e 主机名:"t"$cpu_07echo e 系统内核："t" $cpu_05echo -e操作系统版本:"t" $cpu_06echo -e 磁盘使用用情况：”t”t” $cpu_10echo -e cpu 核数：nt" $cpu_03echo -e 物理 cpu 个数：”t“ $cpu_01echo -e 逻辑 cpu 个数："

6、t" $cpu_02echo -e cpu 的主频:"t" $cpu_04echo -e系统环境变量:"t" $cpu_08echo -e内存简要信息:"t" $cpu_14echo -e 内存总大小："t" $cpu_15echo -e 内存空闲："t" $cpu_09echo -e时间/系统运行时间/当前登陆用户/系统过去1分钟/5分钟/15分钟内平均负载/“t“$cpu_llecho -e 1分钟/5分钟/15分钟平均负载/在采样时刻，运行任务的数目/系统活跃任务的个数/最大的p

7、id值线程/ ”t“ $cpu_12#增加检査ecif系统各模块文件系统下的日志文件空间echo -e某模块日志空间：”t” $cpu_16echo -e某模块日志空间："t” $cpu_17echo -e某模块日志空间："t" $cpu_183、db服务器检检査数据库系统文件系统空间df-k内存使用情况：db2mtrk -i -d -v连接情况检查db2 list application | wc -idb2 list application show detail | grep -i executing |wc -i查看表的状态db2 select tabna

8、me,colount,status from syscat.tables where tabschema not like /sys%/order by tabname表空间状态db2_all list tablespaces show detail查看系统性能db2 get snapshot for all on 数据库名 > log.txt表中是否有死锁grep -n ''deadlocks detected'' log.txt | grep-v"=o" | more以下是数据库sql语句方面的检查检查表空间使用率select ch

9、a"tbsp_name,50) as tbsp_name, tbsp_usable_pages, tbsp_used_pages, rtrim(100*tbsp_used_pages/tbsp_usable_pages) 11 '% as used_rate from sysibmadm.snaptbsppart where tbsp_usable_pages>0 order by tbsp_name,dbpartitionnum执行时间长的sqlselect average_execution_time_s , substr(stivit_textjjooo) as

10、stmttext fromsysibmadm.top_dynamic_sql order by average_execution_time_s desc fetch first 20 rows only执行频率高的sqlselect num_executions, average_execution_time_s, stmtsorts,sorts_per_execution,substr(stmt_text11000) as stmt_text fromsysibmadm.top_dynamic_sql order by num_executions desc fetch first 20

11、rows only排序最多sql：select stmt_sorts, sorts_per_execution, substr(stmt_textjj000) as stmt_text fromsysibmadm.top_dynamic_sql order by stmt_sorts desc fetch first 20 rows only全表扫描最多sql：select applp.agentjdcoalescelpercentrowsselected) as percent_rows_selected,substr(stmt_text j，500) as stmt_text from s

12、ysibmadm.appl_performance applp/ sysibmadm.snapstmt stmt where stmt.agentjd = appl.p.agentd and stmt_text is not null order by coalesce(percentows_selected,0) fetch first 20 rows only数据库表中各日志记录数统计脚本:(select t100_deposit_ac_rel： count(l) from t100_deposit_ac_rel) union all(select t100_ecif_cd_para； c

13、ount(l) from t100_ecif_cd_para) union all(select 't100_ecif_cd_para_bk； count(l) from t100_ecif_cd_para_bk) union all(select t100_sys_cd_map； count(l) from t100_sys_cd_map) union all(select t10_attr_auth； count from t10_attr_auth) union all(select ,t10_attr_auth.bak,/ count(l) from t10_attr_auth

14、_bak) union all(select t10_attr_chg_record： count(l) from t10_attr_chg_record) union all (select ,t10-attr-field-rel,/ count(l) from t10_attr_field_rel) union all(select 't10_attr_to_chn_mapping； count(l) from t10-attr_to_chnj/iapping)union all(select 't10_ (select "tio (select 't10

15、 (select 't10 (select 710 (select 't10 (select "tio (select 't10 (select 't10 (select 'tio (select *t10board_log： count(l) from t10_board_log) union allboard_msg： count from t10_board_msg) union all board_msg_back； count(l) from t10_board_msg_back) union allboard_note_reg： c

16、ount(l) from t10_board_note_reg) union allb_deal_conf： count(l) from t10_b_deal_conf) union allb_errjvisg_conf； count from t10_b_err_msg_conf) union allb_log： count(l) from t10_b_log) union allb_log.detail count(l) from t10_b_log_detail) union allidconv； count(l) from tiojd.conv) union allopr_err_re

17、cord： count(l) from t10_opr_err_record) union all packet_comm_para_conf： count(l) from t10_packet_comm_para_conf)union all(select 'tio.phonenetconf； count(l) from t10_phone_net_conf) union all(select 'tio.qu.modeconf； count(l) from t10_qu_mode_conf) union all(select t10_sys_auth_conf： count

18、from t10_sys_auth_conf) union all(select 't10_sys_conf： count(l) from t10_sys_conf) union all(select t10_tran_auth_conf： count(l) from t10_tran_auth_conf) union all(select't10_tran_auth_conf_2(h41218_fortest：count(l)fromt10 tran auth conf 20141218 fortest) union all(select ,t10_tran-board-co

19、nf,/ count(l) from t10_tran_board_conf) union all(select ,t10_tran_key_conf； count(l) from t10_tran_key_conf) union all(select t10_tran_msg： count(l) from t10_tran_msg) union all(select 't10_tran_para_reg； count(l) from t10_tran_para_reg) union all(select 't10_tran_sel_conf： count(l) from t1

20、0_tran_sel_conf) union all(select,t10-tran-sel_conf-20141218-fortest,/count(l)fromt10 tran sel conf 20141218 fortest) union all(select t10_tran_step： count(l) from t10_tran_step) union all(select't10_t_err_msg_conf： count(l) from t10_t_err_msg_conf) union all(select t10_t_log； count(l) from t10_t_log) union all(select t10_t_log_detail： count from t10_t_log_detail) union all(select ,t10_t_tran_conf count from t10_t_tran_conf) union allfrom(selectt20_t_tran_conf_2(h41228_fortest：count(l)t10 t tran conf 20141218 fortest)mmmm生产目前存在的问题：1. 相似清单：两个客户已经无效，作业仍判断是否相似。2. a客户归并到b客户，将a客户的客户