在知识库中专注阅读，并随时返回相关工具与课程
大家好，这里是公众号 DBA学习之路，分享一些学习国产数据库路上的知识和经验。 最近在测试 GBase 8s 国产数据库，翻阅官方网站，发现一个 Gbase 8s 数据库的巡检脚本以及巡检报告的模板，分享出来给大家，本文仅为转载，原文地址：GBase 8s数据库巡检报告及巡检脚本https://www.gbase.cn/community/post/3356 "GBase 8s数据库巡检报告及巡检
大家好，这里是公众号 DBA学习之路，分享一些学习国产数据库路上的知识和经验。
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
最近在测试 GBase 8s 国产数据库，翻阅官方网站，发现一个 Gbase 8s 数据库的巡检脚本以及巡检报告的模板，分享出来给大家，本文仅为转载，原文地址：GBase 8s数据库巡检报告及巡检脚本。
1#!/bin/bash2###################################################################################3# filename: GBase8schk.sh4# Last modified by: L3 2023-12-265# support OS: Linux6# support database version: GBase 8s V8.x7# useage: sh GBase8schk.sh8###################################################################################9echo ""10echo "Begin to collect data for GBASEDBTSERVER:"${GBASEDBTSERVER}11echo ""12mytime=`date '+%Y%m%d%H%M%S'`13outpath="GBase8schk_${GBASEDBTSERVER}_${mytime}"14if [ ! -d ${outpath} ]; then15mkdir ${outpath}16fi17###################################################################################18## Machine19###################################################################################20echo "collect machine info using sql ......"21dbaccess sysmaster - << EOF22unload to ./${outpath}/machine.unl delimiter '|'23select24os_name,os_release,os_nodename,os_version,os_machine,os_num_procs,os_num_olprocs,25os_pagesize,os_mem_total,os_mem_free,os_open_file_lim,os_shmmax26from sysmachineinfo;27EOF28###################################################################################29## Instance30###################################################################################31echo "collect instance info using sql ......"32dbaccess sysmaster - << EOF33unload to ./${outpath}/instance.unl delimiter '|'34select35dbinfo('UTC_TO_DATETIME',sh_boottime)||' T' start_time,36(current year to second - dbinfo('UTC_TO_DATETIME',sh_boottime))||' T' run_time,37sh_maxchunks as maxchunks,38sh_maxdbspaces maxdbspaces,39sh_maxuserthreads maxuserthreads,40sh_maxtrans maxtrans,41sh_maxlocks locks,42sh_longtx longtxs,43dbinfo('UTC_TO_DATETIME',sh_pfclrtime)||' T' onstat_z_running_time44from sysshmvals;45EOF46###################################################################################47## CPUVP48###################################################################################49echo "collect cpuvp info using sql ......"50dbaccess sysmaster - << EOF51unload to ./${outpath}/cpuvp.unl delimiter '|'52select vpid,classname class,pid,round(usecs_user,2) user_cpu,round(usecs_sys,2) sys_cpu,num_ready,53total_semops,total_busy_wts,total_yields,total_spins,vp_cache_size,vp_cache_allocs54from sysvplst ;55EOF56###################################################################################57## Memory58###################################################################################59echo "collect instance memory info using sql ......"60dbaccess sysmaster - << EOF61unload to ./${outpath}/memory.unl delimiter '|'62select63indx,bufsize pagesize,64nbuffs buffers,65round(nbuffs*bufsize/1024/1024/1024,2)||'GB' buffsize,66nlrus,mindirty,maxdirty,67(bufwaits / (bufwrites + pagreads)) * 100.00 buff_wait_rate,68100 * (bufreads-dskreads)/ bufreads buff_read_rate,69100 * (bufwrites-dskwrites)/ bufwrites buff_write_rate,70fgwrites,lruwrites ,chunkwrites71from sysbufpool;72EOF73###################################################################################74## Network75###################################################################################76echo "collect sqlhosts info using sql ......"77dbaccess sysmaster - << EOF78unload to ./${outpath}/sqlhosts.unl delimiter '|'79select dbsvrnm,nettype,hostname,svcname,options,80svrsecurity,netbuf_size,svrgroup81from syssqlhosts;82EOF83###################################################################################84## Session time85###################################################################################86echo "collect session runtime info using sql ......"87dbaccess sysmaster - << EOF88unload to ./${outpath}/sessiontime.unl delimiter '|'89SELECT first 500 s.sid, s.username, s.hostname, q.odb_dbname database,90dbinfo('UTC_TO_DATETIME',s.connected) conection_time,91dbinfo('UTC_TO_DATETIME',t.last_run_time) last_run_time,92current - dbinfo('UTC_TO_DATETIME',s.connected) connected_since,93current - dbinfo('UTC_TO_DATETIME',t.last_run_time) idle_time94FROM syssessions s, systcblst t, sysrstcb r, sysopendb q95WHERE t.tid = r.tid AND s.sid = r.sid AND s.sid = q.odb_sessionid96ORDER BY 8 DESC;97EOF98###################################################################################99## Session wait100###################################################################################101echo "collect session waits info using sql ......"102dbaccess sysmaster - << EOF103unload to ./${outpath}/sessionwait.unl delimiter '|'104select first 20 sid,pid, username, hostname,105is_wlatch, -- blocked waiting on a latch106is_wlock, -- blocked waiting on a locked record or table107is_wbuff, -- blocked waiting on a buffer108is_wckpt, -- blocked waiting on a checkpoint109is_incrit -- session is in a critical section of transaction-- (e.g writting to disk)110from syssessions111order by is_wlatch+is_wlock+is_wbuff+is_wckpt+is_incrit desc;112EOF113###################################################################################114## Session IO115###################################################################################116echo "collect session IO info using sql ......"117dbaccess sysmaster - << EOF118unload to ./${outpath}/sessionio.unl delimiter '|'119select first 100 syssesprof.sid,isreads,iswrites,isrewrites,120isdeletes,bufreads,bufwrites,seqscans ,121pagreads ,pagwrites,total_sorts ,dsksorts ,122max_sortdiskspace,logspused123from syssesprof, syssessions124where syssesprof.sid = syssessions.sid125order by bufreads+bufwrites desc126;127EOF128###################################################################################129## Checkpoint130###################################################################################131echo "collect checkpoint info using sql ......"132dbaccess sysmaster - << EOF133unload to ./${outpath}/checkpoint.unl delimiter '|'134select135intvl,type,caller,dbinfo('UTC_TO_DATETIME',clock_time)||' T' clock_time,136round(crit_time,4),round(flush_time,4),round(cp_time,4),n_dirty_buffs,137plogs_per_sec,llogs_per_sec,dskflush_per_sec,ckpt_logid,ckpt_logpos,physused,logused,138n_crit_waits,tot_crit_wait,longest_crit_wait,block_time139from syscheckpoint order by intvl;140EOF141###################################################################################142## Database143###################################################################################144echo "collect database info using sql ......"145dbaccess sysmaster - << EOF146unload to ./${outpath}/database.unl delimiter '|'147SELECT trim(name) dbname,trim(owner) owner, created||' T' created_time,148TRIM(DBINFO('dbspace',partnum)) AS dbspace,149CASE WHEN is_logging+is_buff_log=1 THEN "Unbuffered logging"150 WHEN is_logging+is_buff_log=2 THEN "Buffered logging"151 WHEN is_logging+is_buff_log=0 THEN "No logging"152ELSE "" END Logging_mode153FROM sysdatabases154where trim(name) not like 'sys%';155EOF156###################################################################################157## DBspace158###################################################################################159echo "collect dbspaces info using sql ......"160dbaccess sysmaster - << EOF161unload to ./${outpath}/dbspace.unl delimiter '|'162SELECT A.dbsnum as No, trim(B.name) as name,163CASE WHEN (bitval(B.flags,'0x10')>0 AND bitval(B.flags,'0x2')>0)164 THEN 'MirroredBlobspace'165 WHEN bitval(B.flags,'0x10')>0 THEN 'Blobspace'166 WHEN bitval(B.flags,'0x2000')>0 AND bitval(B.flags,'0x8000')>0167 THEN 'TempSbspace'168 WHEN bitval(B.flags,'0x2000')>0 THEN 'TempDbspace'169 WHEN (bitval(B.flags,'0x8000')>0 AND bitval(B.flags,'0x2')>0)170 THEN 'MirroredSbspace'171 WHEN bitval(B.flags,'0x8000')>0 THEN 'SmartBlobspace'172 WHEN bitval(B.flags,'0x2')>0 THEN 'MirroredDbspace'173 ELSE 'Dbspace'174END as dbstype,175round(sum(chksize)*2/1024/1024,2)||'GB' as DBS_SIZE ,176round(sum(decode(mdsize,-1,nfree,udfree))*2/1024/1024,2)||'GB' as free_size,177case when sum(decode(mdsize,-1,nfree,udfree))*100/sum(decode(mdsize,-1,chksize,udsize))178 >sum(decode(mdsize,-1,nfree,nfree))*100/sum(decode(mdsize,-1,chksize,mdsize))179then TRUNC(100-sum(decode(mdsize,-1,nfree,nfree))*100/sum(decode(mdsize,-1,chksize,mdsize)),2)||"%"180else TRUNC(100-sum(decode(mdsize,-1,nfree,udfree))*100/sum(decode(mdsize,-1,chksize,udsize)),2)||"%"181 end as used,182 TRUNC(MAX(A.pagesize/1024))||"KB" as pgsize,183 MAX(B.nchunks) as nchunks184FROM syschktab A, sysdbstab B185WHERE A.dbsnum = B.dbsnum186GROUP BY A.dbsnum,name, 3187ORDER BY A.dbsnum;188EOF189###################################################################################190## Chunks191###################################################################################192echo "collect chunk info using sql ......"193dbaccess sysmaster - << EOF194unload to ./${outpath}/chunks.unl delimiter '|'195SELECT A.chknum as num, B.name as spacename,196TRUNC((A.pagesize/1024)) as pgsize,197A.offset offset,198round( A.chksize*2/1024/1024,2)||'GB' as size,199round(decode(A.mdsize,-1,A.nfree,A.udfree)*2/1024/1024,2)||'GB' as free,200TRUNC(100 - decode(A.mdsize,-1,A.nfree,A.udfree)*100/A.chksize,2 ) as used,201A.fname202FROM syschktab A, sysdbstab B203WHERE A.dbsnum = B.dbsnum204order by B.dbsnum;205EOF206###################################################################################207## Chunk IO208###################################################################################209echo "collect chunk IO using sql ......"210dbaccess sysmaster - << EOF211unload to ./${outpath}/chunk_io.unl delimiter '|'212select d.name dbspace, fname[1,125] chunk_name,reads read_count,writes write_count,213reads+writes total_count,pagesread,pageswritten,214pagesread+pageswritten total_pg215from sysmaster:syschkio c, sysmaster:syschunks k, sysmaster:sysdbspaces d216where d.dbsnum = k.dbsnum and k.chknum = c.chunknum217order by 8 desc;218EOF219###################################################################################220## Logical Log221###################################################################################222echo "collect logical log using sql ......"223dbaccess sysmaster - << EOF224unload to ./${outpath}/logicallog.unl delimiter '|'225SELECT A.number as num, A.uniqid as uid, round(A.size*2/1024,2)||'MB' as size,226TRIM( TRUNC(A.used*100/A.size,0)||'%') as used,227d.name as spacename,228TRIM( A.chunk||'_'||A.offset ) as location,229decode(A.filltime,0,'NotFull',230dbinfo('UTC_TO_DATETIME', A.filltime)::varchar(50))||' T' as filltime,231CASE WHEN bitval(A.flags,'0x1') > 0 AND bitval(A.flags,'0x4')>0232 THEN 'UsedBackedUp'233 WHEN bitval(A.flags,'0x1') > 0 AND bitval(A.flags,'0x2')>0234 THEN 'UsedCurrent'235 WHEN bitval(A.flags,'0x1') > 0 THEN 'Used'236 ELSE hex(A.flags)::varchar(50)237END as flags,238CASE WHEN A.filltime-B.filltime > 0 THEN239 round(CAST(TRUNC(A.size/(A.filltime-B.filltime),4)240 as varchar(20))*2/1024,2)||'MB/S'241 ELSE ' N/A ' END as pps242FROM syslogfil A, syslogfil B,syschktab c, sysdbstab d243WHERE A.uniqid-1 = B.uniqid244and c.dbsnum = d.dbsnum245and a.chunk=c.chknum246UNION247SELECT A.number as num, A.uniqid as uid, round(A.size*2/1024,2)||'MB' as size,248TRIM( TRUNC(A.used*100/A.size,0)||'%') as used,249d.name as spacename,250TRIM( A.chunk||'_'||A.offset ) as location,251decode(A.filltime,0,'NotFull',252dbinfo('UTC_TO_DATETIME', A.filltime)::varchar(50))||' T' as filltime,253CASE WHEN bitval(A.flags,'0x1') > 0 AND bitval(A.flags,'0x4')>0254 THEN 'UsedBackedUp'255 WHEN bitval(A.flags,'0x1') > 0 AND bitval(A.flags,'0x2')>0256 THEN 'UsedCurrent'257 WHEN bitval(A.flags,'0x1') > 0 THEN 'Used'258 WHEN bitval(A.flags,'0x8') > 0 THEN 'NewAdd'259 ELSE hex(A.flags)::varchar(50) END as flags,260 'N/A' as pps261FROM syslogfil A ,syschktab c, sysdbstab d262WHERE ( A.uniqid = (SELECT min(uniqid) FROM syslogfil WHERE uniqid > 0)263 OR A.uniqid = 0 )264and c.dbsnum = d.dbsnum265and a.chunk=c.chknum266ORDER BY A.uniqid ;267EOF268###################################################################################269## Locks on Table270###################################################################################271echo "collect table locks using sql ......"272dbaccess sysmaster - << EOF273unload to ./${outpath}/tab_actlock.unl delimiter '|'274select dbsname,tabname,275sum(pf_rqlock) as locks,276sum(pf_wtlock) as lockwaits,277sum(pf_deadlk) as deadlocks278from sysactptnhdr,systabnames279where systabnames.partnum = sysactptnhdr.partnum280group by dbsname,tabname281order by lockwaits,locks desc;282EOF283dbaccess sysmaster - << EOF284unload to ./${outpath}/tab_lock.unl delimiter '|'285select dbsname,tabname,286sum(lockreqs) as lockreqs,287sum(lockwts) as lockwaits,288sum(deadlks) as deadlocks289from sysptprof290group by dbsname,tabname291order by deadlocks,lockwaits,lockreqs desc;292EOF293###################################################################################294## Databaes Used Space295###################################################################################296echo "collect database used space using sql ......"297dbaccess sysmaster - << EOF298unload to ./${outpath}/database_space.unl delimiter '|'299select t1.dbsname, 300round(sum(ti_nptotal)*max(ti_pagesize)/1024/1024/1024,2)||'GB' allocated_size,301round(sum(ti_npused)*max(ti_pagesize)/1024/1024/1024,2)||'GB' used_size302from systabnames t1, systabinfo t2,sysdatabases t3303where t1.partnum = t2.ti_partnum304and trim(t3.name)=trim(t1.dbsname)305group by dbsname 306order by sum(ti_nptotal) desc;307EOF308###################################################################################309## Tables Space310###################################################################################311echo "collect table and index used space using sql ......"312dbaccess sysmaster - << EOF313unload to ./${outpath}/tab_space.unl delimiter '|'314SELECT st.dbsname databasename, st.tabname,315 MAX(dbinfo('UTC_TO_DATETIME',sin.ti_created)) createdtime,316 SUM( sin.ti_nextns ) extents,317 SUM( sin.ti_nrows ) nrows,318 MAX( sin.ti_nkeys ) nkeys,319 MAX( sin.ti_pagesize ) pagesize,320 SUM( sin.ti_nptotal ) nptotal,321 round(SUM( sin.ti_nptotal*sd.pagesize )/1024/1024,2)||'MB' total_size,322 SUM( sin.ti_npused ) npused,323 round(SUM( sin.ti_npused*sd.pagesize )/1024/1024,2)||'MB' used_size,324 SUM( sin.ti_npdata ) npdata,325 round(SUM( sin.ti_npdata*sd.pagesize )/1024/1024,2)||'MB' data_size326FROM327 sysmaster:systabnames st,328 sysmaster:sysdbspaces sd,329 sysmaster:systabinfo sin330WHERE331 sd.dbsnum = trunc(st.partnum / 1048576)332 AND st.partnum = sin.ti_partnum333 AND st.dbsname NOT IN ('sysmaster','sysuser','sysadmin','sysutils','sysha','syscdr','syscdcv1')334 AND st.tabname[1,3] NOT IN ('sys','TBL')335GROUP BY 1, 2336ORDER BY 9 DESC;337EOF338###################################################################################339## Tables Space By Partition340###################################################################################341echo "collect table and index partition used space using sql ......"342dbaccess sysmaster - << EOF343unload to ./${outpath}/tab_space_frag.unl delimiter '|'344SELECT st.dbsname databasename, st.tabname,st.partnum partnum,345 dbinfo('UTC_TO_DATETIME',sin.ti_created) createdtime,346 sin.ti_nextns extents,347 sin.ti_nrows nrows,348 sin.ti_nkeys nkeys,349 sin.ti_pagesize pagesize,350 sin.ti_nptotal nptotal,351 round(( sin.ti_nptotal*sd.pagesize )/1024/1024,2)||'MB' total_size,352 ( sin.ti_npused ) npused,353 round(( sin.ti_npused*sd.pagesize )/1024/1024,2)||'MB' used_size,354 ( sin.ti_npdata ) npdata,355 round(( sin.ti_npdata*sd.pagesize )/1024/1024,2)||'MB' data_size356FROM357 sysmaster:systabnames st,358 sysmaster:sysdbspaces sd,359 sysmaster:systabinfo sin360WHERE361 sd.dbsnum = trunc(st.partnum / 1048576)362 AND st.partnum = sin.ti_partnum363 AND st.dbsname NOT IN ('sysmaster','sysuser','sysadmin','sysutils','sysha','syscdr','syscdcv1')364 AND st.tabname[1,3] NOT IN ('sys','TBL')365ORDER BY 9 DESC;366EOF367###################################################################################368## Tables and index IO and seqscans369###################################################################################370echo "collect table and index io and seqscans using sql ......"371dbaccess sysmaster - << EOF372unload to ./${outpath}/tab_io.unl delimiter '|'373SELECT374 st.dbsname,p.tabname,SUM( sin.ti_nrows ) nrows,375 round(SUM( sin.ti_nptotal*sd.pagesize )/1024/1024,2)||'MB' total_size,376 round(SUM( sin.ti_npused*sd.pagesize )/1024/1024,2)||'MB' used_size,377 SUM( seqscans ) AS seqscans,378 SUM( pagreads ) diskreads,379 SUM( bufreads ) bufreads,380 SUM( bufwrites ) bufwrites,381 SUM( pagwrites ) diskwrites,382 SUM( pagreads )+ SUM( pagwrites ) disk_rsws,383 trunc(decode(SUM( bufreads ),0,0,(100 -((SUM( pagreads )* 100)/ SUM( bufreads + pagreads )))),2) AS rbufhits,384 trunc(decode(SUM( bufwrites ),0,0,(100 -((SUM( pagwrites )* 100)/ SUM( bufwrites + pagwrites )))),2) AS wbufhits385FROM386 sysmaster:sysptprof p,387 sysmaster:systabinfo sin,388 sysmaster:sysdbspaces sd,389 sysmaster:systabnames st390WHERE391 sd.dbsnum = trunc(st.partnum / 1048576)392 AND p.partnum = st.partnum393 AND st.partnum = sin.ti_partnum394 AND st.dbsname NOT IN ('sysmaster','sysuser','sysadmin','sysutils','sysha','syscdr','syscdcv1')395 AND st.tabname[1,3] NOT IN ('sys','TBL')396GROUP BY 1, 2397ORDER BY 11 DESC;398EOF399###################################################################################400## Current slowest sql401###################################################################################402echo "collect current slowest sql using sql ......"403dbaccess sysmaster - << EOF404unload to ./${outpath}/slowsql.unl delimiter '|'405Select first 100 sqx_estcost,sqx_estrows,sqx_sqlstatement406FROM sysmaster:syssqexplain407order by sqx_estcost desc;408EOF409###################################################################################410## Table statistics,lockmode,index keys411###################################################################################412echo "collect tables statistics,lockmode,index keys using sql ......"413dbaccess sysmaster - << EOF414unload to ./${outpath}/tabstat.sql delimiter ";"415select 416"unload to ./${outpath}/"||trim(name)||"_stat.unl Select t.tabname,t.created as tabcreated,t.nrows,tmpt.nrows as realrows,t.locklevel,t.ustlowts,i.idxname,"||417"trim(case when i.part1>0 then (select colname from "||trim(name)||":syscolumns where colno=i.part1 and tabid=i.tabid) else '' end)||"||418"trim(case when i.part2>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part2 and tabid=i.tabid) else '' end)||"||419"trim(case when i.part3>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part3 and tabid=i.tabid) else '' end)||"||420"trim(case when i.part4>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part4 and tabid=i.tabid) else '' end)||"||421"trim(case when i.part5>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part5 and tabid=i.tabid) else '' end)||"||422"trim(case when i.part6>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part6 and tabid=i.tabid) else '' end)||"||423"trim(case when i.part7>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part7 and tabid=i.tabid) else '' end)||"||424"trim(case when i.part8>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part8 and tabid=i.tabid) else '' end)||"||425"trim(case when i.part9>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part9 and tabid=i.tabid) else '' end)||"||426"trim(case when i.part10>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part10 and tabid=i.tabid) else '' end)||"||427"trim(case when i.part11>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part11 and tabid=i.tabid) else '' end)||"||428"trim(case when i.part12>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part12 and tabid=i.tabid) else '' end)||"||429"trim(case when i.part13>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part13 and tabid=i.tabid) else '' end)||"||430"trim(case when i.part14>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part14 and tabid=i.tabid) else '' end)||"||431"trim(case when i.part15>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part15 and tabid=i.tabid) else '' end)||"||432"trim(case when i.part16>0 then (select ','||colname from "||trim(name)||":syscolumns where colno=i.part16 and tabid=i.tabid) else '' end ) index_cols"||433",i.nunique "||434"from "||trim(name)||":systables t left join "||trim(name)||":sysindexes i on t.tabid=i.tabid "||435"join (select tabname,sum(ti_nrows) as nrows from systabnames tn join systabinfo ti on ti.ti_partnum=tn.partnum where dbsname='"||trim(name)||"' "||436"group by tabname) as tmpt "||437"on t.tabname=tmpt.tabname "||438"where t.tabid>99 "||439"and t.tabtype='T' "||440"order by 4 desc,1"441from sysdatabases442where name NOT IN ('sysmaster','sysuser','sysadmin','sysutils','sysha','syscdr','syscdcv1')443and is_logging=1;444EOF445dbaccess sysmaster ${outpath}/tabstat.sql446###################################################################################447## onstat cmd448###################################################################################449echo "collect instance running status using onstat commands ......"450onstat -b > ./${outpath}/onstat_b.unl451onstat -C all > ./${outpath}/onstat_C_all.unl452onstat -C > ./${outpath}/onstat_bigc.unl453onstat -c > ./${outpath}/onstat_c.unl454onstat -D > ./${outpath}/onstat_bigd.unl455onstat -d > ./${outpath}/onstat_d.unl456onstat -F > ./${outpath}/onstat_F.unl457onstat -g act > ./${outpath}/onstat_g_act.unl458onstat -g arc > ./${outpath}/onstat_g_arc.unl459onstat -g ath > ./${outpath}/onstat_g_ath.unl460onstat -g buf > ./${outpath}/onstat_g_buf.unl461onstat -g cluster > ./${outpath}/onstat_g_cluster.unl462onstat -g cmsm > ./${outpath}/onstat_g_cmsm.unl463onstat -g cfg > ./${outpath}/onstat_g_cfg.unl464onstat -g cfg diff > ./${outpath}/onstat_g_cfg_diff.unl465onstat -g ckp > ./${outpath}/onstat_g_ckp.unl466onstat -g con > ./${outpath}/onstat_g_con.unl467onstat -g cpu > ./${outpath}/onstat_g_cpu.unl468onstat -g dic > ./${outpath}/onstat_g_dic.unl469onstat -g dis > ./${outpath}/onstat_g_dis.unl470onstat -g dsc > ./${outpath}/onstat_g_dsc.unl471onstat -g env > ./${outpath}/onstat_g_env.unl472onstat -g glo > ./${outpath}/onstat_g_glo.unl473onstat -g iof > ./${outpath}/onstat_g_iof.unl474onstat -g iog > ./${outpath}/onstat_g_iog.unl475onstat -g ioq > ./${outpath}/onstat_g_ioq.unl476onstat -g iov > ./${outpath}/onstat_g_iov.unl477onstat -g lmx > ./${outpath}/onstat_g_lmx.unl478#onstat -g mem > ./${outpath}/onstat_g_mem.unl479onstat -g mgm > ./${outpath}/onstat_g_mgm.unl480onstat -g ntd > ./${outpath}/onstat_g_ntd.unl481onstat -g ntt > ./${outpath}/onstat_g_ntt.unl482onstat -g ntu > ./${outpath}/onstat_g_ntu.unl483onstat -g osi > ./${outpath}/onstat_g_osi.unl484onstat -g rea > ./${outpath}/onstat_g_rea.unl485onstat -g seg > ./${outpath}/onstat_g_seg.unl486onstat -g ses 0 > ./${outpath}/onstat_g_ses_0.unl487onstat -g ses > ./${outpath}/onstat_g_ses.unl488onstat -g smb s > ./${outpath}/onstat_g_smb_s.unl489#onstat -g spi | sort -n -k 2 | tail -200 > ./${outpath}/onstat_g_spi.unl490onstat -g sql > ./${outpath}/onstat_g_sql.unl491onstat -g sql 0 > ./${outpath}/onstat_g_sql_0.unl492#onstat -g ssc > ./${outpath}/onstat_g_ssc.unl493#onstat -g stk >onstat_g_stk.unl494#onstat -g sts >onstat_g_sts.unl495onstat -g wai > ./${outpath}/onstat_g_wai.unl496onstat -L > ./${outpath}/onstat_bigl.unl497onstat -l > ./${outpath}/onstat_l.unl498onstat -p > ./${outpath}/onstat_p.unl499onstat -R > ./${outpath}/onstat_R.unl500onstat -u > ./${outpath}/onstat_u.unl501onstat -V > ./${outpath}/onstat_V.unl502onstat -x > ./${outpath}/onstat_x.unl503onstat -X > ./${outpath}/onstat_bigx.unl504###################################################################################505## system cmd506###################################################################################507echo ""508echo "collect instance running status using system command ......"509echo ""510echo "collect cm memory ......"511ps -aux |grep cmsm > ./${outpath}/cm_mem.unl512echo ""513echo "collect online.log last 50000 rows......"514onlinefile=`onstat -m |grep 'Message Log File' | awk '{print $4}'`515tail -50000 ${onlinefile} > ./${outpath}/online.log516echo ""517echo "collect current user env ......"518env > ./${outpath}/env.unl519echo ""520echo "collect system cpu and memory using vmstat ......"521vmstat 1 5 > ./${outpath}/vmstat.unl522echo ""523echo "##################################################################"524echo "GBase 8s Database Health Check Finshed"525echo "tar all of the output files in path: ${outpath}"526echo "tar -cvf ${outpath}.tar ${outpath} "527echo "##################################################################"528###################################################################################529## end of all530###################################################################################执行方式：
1chmod +x GBase8schk.sh2sh GBase8schk.sh生成的巡检文件为一个 tar 包。