-
编辑 删除
TWS rule of name
The rule of name definatio[@more@]Please follow our standard naming convention. The naming conventions are as follows: Schedule: ECCPP_AAA_FN Job: ECCPP_AAA_AAAAAAwhere E = Environment, C = Country Code, P = Platform, A= Application Name orAcronym, F=Frequency, N=Variations.F=Frequency are as follows:D - dailyW - weeklyM - monthlyA - adhocE.g.. Schedule PJPSU_FAL_D1 = Production Japan Falcon (FAL) Daily 1 Schedule running on SUN Platform.Job name PJPSU_FAL_FXDERMAST = Production Japan Falcon
-
编辑 删除
Monitoring DB2 SQL TEXT
how TO use sql monitor DB2[@more@]用SQL语句实现DB2主要指标的监控 --Database manager:To capture a snapshot of database manager information: SELECT * FROM TABLE( SNAPSHOT_DBM(-1)) as SNAPSHOT_DBM --To capture a snapshot of database manager information specifically regarding the fast communication manager (FCM): SELECT * FROM TABLE( SNAPSHOT_FCM(-1)) as SNAPSHOT_FCM --To capture a snapshot of database manager information for a partition specifically regarding the fast communication manager(FCM): SE
-
编辑 删除
MSSQL SQL Text
HOW to Monitoring MSSQL[@more@] 1.监控事例的等待: select event,sum(decode(wait_time,0,0,1)) prev,sum(decode(wait_time,0,1,0)) curr, count(*)from v$session_wait group by event order by 4; 2.回滚段的争用情况: select name,waits,gets,waits/gets ratio fromv$rollstat a,v$rollname b where a.usn=b.usn; 3.监控表空间的I/O比例: selectdf.tablespace_namename,df.file_name "file",f.phyrds pyr,f.phyblkrd pbr,f.phywrtspyw,f.phyblkwrtpbw fromv$filestatf,dba_d
-
编辑 删除
AIX Monitoring Script
#!/bin/sh ## 首先载入配置文件，如果配置文件不存在，则报错退出#SOURCE=$HOME/config/configcheck_source(){if [ -r $SOURCE ]; then . $SOURCEelse echo "$(basename $0): Cannot locate the default setting file." exit 1fi}## 定义报表头#report_header(){HOSTIP=$(ifconfig -a | sed -n '2p' |awk '{print $2}')HOSTNAME=$(hostname)USER=`who am i | cut -d " " -f1`cat<<!Hostname: $HOSTNAME Server: $HOSTIPUser: $USER Time: $(date +%Y'-'%m'-'%d' '%H':'%M':'%S)
