ITPub博客

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

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

#!/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)

TSM 相关概念[@more@]1.tsm client command line interface #dsmc 显示TSM server和TSM client的version and release号 运行client端的备份 图形接口命令：#dsm2.administrative client command line interface #dsmadmc 显示TSM server和TSM client的version and release号 web管理界面：http://server address:15803.tape defragmentation or reclamation 当磁带上的数据过期后，该数据会被标识为空，但空间并不能被释放，因为磁带是顺序写设备，不可能重写磁带上空的空间。4.security concepts tsm server 和client之间的通讯采用mutua

[@more@][原创]1.批量改名或拷贝文件比如将 start*.sh文件改为stop*.sh拷贝先查看ls -l start*.sh|awk '{m=$9; gsub(/start/,"stop",$9);print "cp "m " "$9}'再运行ls -l start*.sh|awk '{m=$9; gsub(/start/,"stop",$9);print "cp "m " "$9}'|sh改名先查看ls -l start*.sh|awk '{m=$9; gsub(/start/,"stop",$9);print "mv "m " "$9}'再运行ls -l start*.sh|awk '{m=$9; gsub(/start/,"stop",$9);print "mv "m " &