?? dbcheck.sh
字號:
enecho "Hello, dbcheck starting ..."env > env.txt###### onstat check ################echo "Generating onstat -V ..."onstat -V > onstat-big_v.txtisql -V >isql-big_v.txtesql -V >esql-big_v.txtcat $INFORMIXDIR/etc/ClientSDK-cr > sdk.txtecho "Generating onstat -c ..."onstat -c > onstat-c.txtecho "Generating onstat -a ..."onstat -a > onstat-a.txtecho "Generating onstat -p ..."onstat -p > onstat-p.txtecho "Generating onstat -F ..."onstat -F > onstat-big_f.txtecho "Generating onstat -g ath ..."onstat -g ath > onstat-g_ath.txtecho "Generating onstat -g glo ..."onstat -g glo > onstat-g_glo.txtecho "Generating onstat -g mem ..."onstat -g mem > onstat-g_mem.txtecho "Generating onstat -g seg ..."onstat -g seg > onstat-g_seg.txtecho "Generating onstat -d ..."onstat -d > onstat-d.txtecho "Generating onstat -k|grep wait ..."onstat -k|grep wait > onstat-k_wait.txtecho "Generating onstat -R ..."onstat -R > onstat-big_r.txt echo "Generating onstat -l ..."onstat -l > onstat-l.txtecho "Generating onstat -u ..."onstat -u > onstat-u.txtecho "Generating onstat -g ioa ..."onstat -g ioa > onstat-g_ioa.txtecho "Generating onstat -g iof ..."onstat -g iof > onstat-g_iof.txtecho "Generating onstat -ioq ..."onstat -g ioq > onstat-g_ioq.txtecho "Generating onstat -g lmx ..."onstat -g lmx > onstat-g_lmx.txtecho "Generating onstat -g wai ..."onstat -g wai > onstat-g_wai.txtecho "Generating onstat -m ..."onstat -m > onstat-m.txtecho "Generating oncheck -pe ..."# oncheck -pe > oncheck_pe.txt############## sql ############################## 1echo "Generating DB space information ..."dbaccess sysmaster - <<EOF > sql_dbspace.txtselect name[1,8] dbspace, -- name truncated to fit on one line sum(chksize) Pages_size, -- sum of all chuncks size pages sum(chksize) - sum(nfree) Pages_used, sum(nfree) Pages_free, -- sum of all chunks free pages round ((sum(nfree)) / (sum(chksize)) * 100, 2) percent_freefrom sysdbspaces d, syschunks cwhere d.dbsnum = c.dbsnumgroup by 1order by 1;EOF#### 2###### 4echo "Generating first 20 big table's information (only extends and size)..."dbaccess sysmaster - <<EOF > sql_big20_ext.txtselect first 20 dbsname[1,10], tabname[1,15], count(*) ext_nums, sum(size) sizefrom sysextents where dbsname [1,3]<>'sys'and tabname[1,3]<>'sys'group by 1,2order by 3 desc;EOF#### 5echo "Generating chunk's information..."dbaccess sysmaster - <<EOF > sql_thunks.txtselect a.name[1,10],a.nchunks,sum(b.chksize) size, sum(b.nfree) free,round(sum(b.nfree)/sum(b.chksize)*100,2) percent_freefrom sysmaster:sysdbspaces a,sysmaster:syschunks b where a.dbsnum=b.dbsnum group by 1,2;EOF#### 6echo "Generating app db's information ..."dbaccess sysmaster - <<EOF > sql_db.txtselect name[1,15], is_logging, is_buff_log,is_ansi,is_nls from sysdatabasesEOF
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -