#!/bin/sh
#
# This is a shell archive.  To extract its contents,
# execute this file with /bin/sh to create the file(s):
#
# README		    mon_buffer.sh
#
# This shell archive created: Fri Feb  1 18:13:09 EST 2002
#
echo "Extracting file README"
sed -e 's/^X//' <<\SHAR_EOF > README
XDear IIUG,
X
XI made a shell script for buffer monitoring, the file is attached.
X
XThanks
X
XVagner Pontes
XDatabase Admnistrator
X
XYoshitec Informatica
Xhttp:www.yoshitec.com.br
X
X----------------------[ mon_buffer output ]-------------------------------
X
XFri Jan 18 10:10:03 EDT 2002
XOSF1 pps1 V4.0 1530 alpha
X############################################################
X
X   Report - Buffer Utilization
X
X############################################################
X
XTotal Buffers: 1205200
X
X   PARTNUM TABLE/INDEX            BUFFERS USERS     % TOT
X   3157294 debitar_cartoes         174093     5     14.45
X   3146913 notasnaoemitidas         99696     0      8.27
X   3145965 estado_opcao             93447   292      7.75
X   3146044 notafiscal               63186     0      5.24
X   3146016 criar_cartoes            52549     0      4.36
X   3145923 systabauth               39880     0      3.31
X   3151008 resumobanco              39646     1      3.29
X   3146282 promoservico             36350     1      3.02
X   9437191 mimo                     29302   294      2.43
X   3146042 mimo                     28985   294      2.40
X   9437202 mimo_saldo               27922   188      2.32
X   3145777 historico_mimo           26206     0      2.17
X   9437203 ms_saldo_1               23751   188      1.97
X   3149793 eliminar_cartoes         18577     0      1.54
X   3145852 cep                      15865    24      1.32
X   3152576 numero                   10691     0      0.89
X   3162660 sibs_online              10601     1      0.88
X   3155521 ms_saldo_2                9936     1      0.82
X   3149797 pedidohabilitar           8856     0      0.73
X   9437195 i_mimo_msisdn             7986     3      0.66
X   3149795 repor_preactivados        7156     0      0.59
X
X_________________________________________________________
SHAR_EOF
if [ `wc -c < README` -ne     1818 ]
then
    echo "Lengths do not match -- Bad Copy of README"
fi
echo "Extracting file mon_buffer.sh"
sed -e 's/^X//' <<\SHAR_EOF > mon_buffer.sh
X#################################################################################
X#!/usr/bin/ksh
X#
X# Author.: Vagner Pontes - vagnerpontes@ig.com.br
X# Created: 17/Jan/2002
X# Company: Yoshitec Informatica Ltda
X#
X#################################################################################
X
XARQRES="onstat_p.tmp"
XARQSYS="systables.tmp"
XARQUSR="onstat_t.tmp"
XARQWRK="work_join.tmp"
X
Xdate
Xuname -a
X
Xecho "############################################################"
Xecho "                                                            "
Xecho "   Report - Buffer Utilization                              "
Xecho "                                                            "
Xecho "############################################################"
X
Xonstat -P | tail +4 > $ARQRES
X
Xecho "set isolation to dirty read; \
X      unload to $ARQSYS delimiter ' ' \
X       select partnum,tabname,substr(lower(hex(partnum)),5,6) \
X	 from systabnames " | dbaccess sysmaster 2> /dev/null
X
Xonstat -t | tail +6 | awk ' { print $5,$4 } ' > $ARQUSR
X
XTOTBUF=` grep Total $ARQRES | awk ' { print $2 } ' `
X
Xecho "Total Buffers: $TOTBUF\n"
X
X
Xjoin -e 0 -a 1 -j1 3 -j2 1 -o 1.1,1.2,1.3,2.2 $ARQSYS $ARQUSR > $ARQWRK
X
Xjoin -o 1.1,1.2,2.2,2.4 $ARQRES $ARQWRK | \
X       sort -n -r -k 2 | awk -v TOT=$TOTBUF \
X      ' BEGIN { \
X	       printf "%10s" "%-21s" "%10s" "%6s" "%10s\n", \
X	      "PARTNUM"," TABLE/INDEX","BUFFERS"," USERS","% TOT" \
X	      } \
X     	      { \
X	      printf "%10s" " %-20s" "%10d" "%6d" "%10.2f\n", \
X                       $1, $3, $2, $4, (($2/TOT)*100) } '
X
X
Xrm $ARQRES
Xrm $ARQSYS
Xrm $ARQUSR
Xrm $ARQWRK
X
SHAR_EOF
if [ `wc -c < mon_buffer.sh` -ne     1655 ]
then
    echo "Lengths do not match -- Bad Copy of mon_buffer.sh"
fi
echo "Done."
exit 0