ECIF系统巡检步骤及问题

ECIF系统巡检计划：1、 ETL服务器检查：1：对目前的作业的情况进行全面检查、涉及最及报出来的问题。2：对ETL服务器日志文件大小的检查2、 AP应用服务检查脚本： #!/bin/bash #此脚本是为了系统巡检#Auth：rain #/bin/bash system_check.sh ecif_check_sys.log &iconv -f utf-8 -t gbk ecif_check_sys.log system.doc &rm -rf ecif_check_sys.log cpu_01=cat /proc/cpuinfo |grep physical id|sort |uniq|wc -l cpu_02=cat /proc/cpuinfo |grep processor|wc -l cpu_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 /etc/issue cpu_07=hostname cpu_08=env |grep PATH cpu_09=grep MemFree /proc/meminfo cpu_10=df -h cpu_11=uptime pu_12=cat /proc/loadavg cpu_13=ifconfig |grep inet addr|grep -v 127.0.0.1 |awk -F: print $2 |awk print $1 cpu_14=/usr/sbin/dmidecode | grep -A 16 Memory Device | grep -E Size|Locator | grep -v Bank cpu_15=grep MemTotal /proc/meminfo #需要进入到各模块下、检查日志文件空间cd /home/ecif/各模块cpu_16=df -h cd /home/ecif/各模块cpu_17=df -h cd /home/ecif/各模块cpu_18=df -h day01=date +%Y day02=date +%m day03=date +%d echo -e $day01 年$day02 月$day03系统巡检报告echo -e 服务器IP：t$cpu_13 echo -e 主机名：t$cpu_07 echo -e 系统内核：t $cpu_05 echo -e 操作系统版本:t $cpu_06 echo -e 磁盘使用用情况：tt $cpu_10 echo -e CPU核数：t $cpu_03 echo -e 物理CPU个数：t $cpu_01 echo -e 逻辑CPU个数：t $cpu_02 echo -e CPU的主频:t $cpu_04 echo -e 系统环境变量:t $cpu_08 echo -e 内存简要信息：t $cpu_14 echo -e 内存总大小：t $cpu_15echo -e 内存空闲：t $cpu_09 echo -e 时间/系统运行时间/当前登陆用户/系统过去1分钟/5分钟/15分钟内平均负载/t $cpu_11 echo -e 1分钟/5分钟/15分钟平均负载/在采样时刻，运行任务的数目/系统活跃任务的个数/最大的pid值线程/ t $cpu_12 #增加检查ECIF系统各模块文件系统下的日志文件空间echo -e 某模块日志空间：t $cpu_16 echo -e某模块日志空间：t $cpu_17echo -e某模块日志空间：t $cpu_183、 DB服务器检检查数据库系统文件系统空间df -k 内存使用情况： db2mtrk -i -d -v 连接情况检查 db2 list application |wc -l db2 list application show detail|grep -i Executing |wc -l 查看表的状态 db2 select tabname,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 ”=0” | more 以下是数据库sql语句方面的检查-检查表空间使用率-select char(TBSP_NAME,50) as TBSP_NAME, TBSP_USABLE_PAGES, TBSP_USED_PAGES, rtrim(100*TBSP_USED_PAGES/TBSP_USABLE_PAGES)|% as USED_RATE from sysibmadm.SNAPTBSP_PART where TBSP_USABLE_PAGES0 order by TBSP_NAME,DBPARTITIONNUM-执行时间长的SQLselect AVERAGE_EXECUTION_TIME_S , SUBSTR(STMT_TEXT,1,1000) AS STMT_TEXT from SYSIBMADM.TOP_DYNAMIC_SQL order by AVERAGE_EXECUTION_TIME_S desc fetch first 20 rows only-执行频率高的SQLselect NUM_EXECUTIONS, AVERAGE_EXECUTION_TIME_S, STMT_SORTS, SORTS_PER_EXECUTION,SUBSTR(STMT_TEXT,1, 1000) AS STMT_TEXT from SYSIBMADM.TOP_DYNAMIC_SQL ORDER BY NUM_EXECUTIONS desc fetch first 20 rows only-排序最多SQL：select STMT_SORTS, SORTS_PER_EXECUTION, substr(STMT_TEXT,1,1000) as STMT_TEXT from SYSIBMADM.TOP_DYNAMIC_SQL order by STMT_SORTS desc fetch first 20 rows only-全表扫描最多SQL：select appl_p.agent_id,COALESCE(percent_rows_selected,0) as percent_rows_selected,substr(stmt_text,1,500) as stmt_text from sysibmadm.appl_performance appl_p, sysibmadm.snapstmt stmt where stmt.agent_id = appl_p.agent_id and stmt_text is not null order by COALESCE(percent_rows_selected,0) fetch first 20 rows only数据库表中各日志记录数统计脚本： (select T100_DEPOSIT_AC_REL, count(1) from T100_DEPOSIT_AC_REL) UNION ALL(select T100_ECIF_CD_PARA, count(1) from T100_ECIF_CD_PARA) UNION ALL(select T100_ECIF_CD_PARA_BK, count(1) from T100_ECIF_CD_PARA_BK) UNION ALL(select T100_SYS_CD_MAP, count(1) from T100_SYS_CD_MAP) UNION ALL(select T10_ATTR_AUTH, count(1) from T10_ATTR_AUTH) UNION ALL(select T10_ATTR_AUTH_BAK, count(1) from T10_ATTR_AUTH_BAK) UNION ALL(select T10_ATTR_CHG_RECORD, count(1) from T10_ATTR_CHG_RECORD) UNION ALL(select T10_ATTR_FIELD_REL, count(1) from T10_ATTR_FIELD_REL) UNION ALL(select T10_ATTR_TO_CHN_MAPPING, count(1) from T10_ATTR_TO_CHN_MAPPING) UNION ALL(select T10_BOARD_LOG, count(1) from T10_BOARD_LOG) UNION ALL(select T10_BOARD_MSG, count(1) from T10_BOARD_MSG) UNION ALL(select T10_BOARD_MSG_BACK, count(1) from T10_BOARD_MSG_BACK) UNION ALL(select T10_BOARD_NOTE_REG, count(1) from T10_BOARD_NOTE_REG) UNION ALL(select T10_B_DEAL_CONF, count(1) from T10_B_DEAL_CONF) UNION ALL(select T10_B_ERR_MSG_CONF, count(1) from T10_B_ERR_MSG_CONF) UNION ALL(select T10_B_LOG, count(1) from T10_B_LOG) UNION ALL(select T10_B_LOG_DETAIL, count(1) from T10_B_LOG_DETAIL) UNION ALL(select T10_ID_CONV, count(1) from T10_ID_CONV) UNION ALL(select T10_OPR_ERR_RECORD, count(1) from T10_OPR_ERR_RECORD) UNION ALL(select T10_PACKET_COMM_PARA_CONF, count(1) from T10_PACKET_COMM_PARA_CONF) UNION ALL(select T10_PHONE_NET_CONF, count(1) from T10_PHONE_NET_CONF) UNION ALL(select T10_QU_MODE_CONF, count(1) from T10_QU_MODE_CONF) UNION ALL(select T10_SYS_AUTH_CONF, count(1) from T10_SYS_AUTH_CONF) UNION ALL(select T10_SYS_CONF, count(1) from T10_SYS_CONF) UNION ALL(select T10_TRAN_AUTH_CONF, count(1) from T10_TRAN_AUTH_CONF) UNION ALL(select T10_TRAN_AUTH_CONF_20141218_FORTEST, count(1) from T10_TRAN_AUTH_CONF_20141218_FORTEST) UNION ALL(select T10_TRAN_BOARD_CONF, count(1) from T10_TRAN_BOARD_CONF) UNION ALL(select T10_TRAN_KEY_CONF, count(1) from T10_TRAN_KEY_CONF) UNION ALL(select T10_TRAN_MSG, count(1) from T10_TRAN_MSG) UNION ALL(select T10_TRAN_PARA_REG, count(1) from T10_TRAN_PARA_REG) UNION ALL(select T10_TRAN_SEL_CONF, count(1) from T10_TRAN_SEL_CONF) UNION ALL(select T10_TRAN_SEL_CONF_20141218_FORTEST, count(1) from T10_TRAN_SEL_CONF_20141218_FORTEST) UNION ALL(select T10_TRAN_STEP, count(1) from T10_TRAN_STEP) UNION ALL(select T10_T_ERR_MSG_CONF, count(1) from T10_T_ERR_MSG_CONF) UNION ALL(select T10_T_LOG, count(1) from T10_T_LOG) UNION ALL(select T10_T_LOG_DETAIL, count(1) from T10_T_LOG_DETAIL) UNION ALL(select T10_T_TRAN_CONF, count(1) from T10_T_TRAN_CONF) UNION ALL(selectT10_T_TRAN_CONF_20141218_FORTEST, count(1) from T10_T_TRAN_CONF_20141218_FORTEST)生产目前存在的问题：1. 相似清单：两个客户已经无效，作业仍判断是否相似。2. A客户归并到B客户，将A客户的客户号更新为B客户的客户号，如果归并错了，修改很困难。是否可以将A客户存放到历史表，现有的