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