Re: Re[2]: monitoring flow of data on the net

This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. ---1503566844-1938335291-830384142=:43606 Content-Type: TEXT/PLAIN; CHARSET=US-ASCII Content-ID: <Pine.A32.3.92.960424171652.43606F@prod1.jcdc.doleta.gov> Here it is: A copy was also sent to Neal Howard <neal@metronet.com> who want to be placed on the "www.iiug.org website for the whole Informix community" Mind you this is a simple script. Hope this helps, it has helpped me! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR kendric@gwysmtp.jcdc.doleta.gov OR cherylk@spamis.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On 24 Apr 1996 Susik_Lee@United#u#Group.CCMAIL.CompuServe.COM wrote: } Can you sent me a copy of this script too. } } Thanks. } } susik_lee@united#u#group.ccmail.compuserve.com } } } } ______________________________ Reply Separator _________________________________ } Subject: Re: monitoring flow of data on the net } Author: INTERNET:cherylk@prod1.jcdc.doleta.gov at CSERVE } Date: 4/24/96 6:41 AM } } } Sender: informix-list-owner@rmy.emory.edu } Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4]) by } arl-img-7.compuserve.com (8.6.10/5.950515) } id HAA13063; Wed, 24 Apr 1996 07:39:26 -0400 } Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id } HAA15557 for susik_lee@united#u#group.ccmail.compuserve.com; Wed, 24 Apr 1996 } 07:39:46 -0400 (EDT) } Date: Wed, 24 Apr 1996 05:49:10 -0500 (CDT) } From: Cheryl Kendricks <cherylk@prod1.jcdc.doleta.gov> } To: Marco Traini <alsiap@topnet.it> } Cc: informix-list@rmy.emory.edu } Subject: Re: monitoring flow of data on the net } In-Reply-To: <4lji24$q2a@server-b.cs.interbusiness.it> } Message-Id: <Pine.A32.3.92.960424054647.48110B-100000@prod1.jcdc.doleta.gov> } Mime-Version: 1.0 } Content-Type: TEXT/PLAIN; charset=US-ASCII } Sender: informix-list-owner@rmy.emory.edu } Reply-To: Cheryl Kendricks <cherylk@prod1.jcdc.doleta.gov> } X-Informix-List-To: susik_lee@united#u#group.ccmail.compuserve.com } X-Informix-List-Id: <list.9544> } } I have a script that looks at the SQL being exected on the Server by the } client. I will send you a copy of this script, if you like. } } } ------------------------------------------------------------------------- } Cheryl Kendricks } Internet:cherylk@prod1.jcdc.doleta.gov } OR } kendric@gwysmtp.jcdc.doleta.gov } OR } cherylk@spamis.jcdc.doleta.gov } DTSI, Inc. Voice: 1-800-598-5008 } Database Administrator - DOL Job Corps San Marcos, Texas } ------------------------------------------------------------------------ } } } On 23 Apr 1996, Marco Traini wrote: } } > Can Somebody tell me which software i can use to understand the charge of } > my net? } > I'd like to know how much data, which select ..... each PC is doing at } > each moment. I need something to find out the bottlenecks. } > I read of DBcockpit, but i don't know if it's something suitable for my } > needs. } > I'm talking about Informix Online 6.0 under Unix system V and some PC } > (win95) connected via esql. } > } > MOre. Which are the main differences between OnLine 6.x and 7.x? } > } > } } ---1503566844-1938335291-830384142=:43606 Content-Type: TEXT/PLAIN; CHARSET=US-ASCII; NAME=user_info Content-Transfer-Encoding: BASE64 Content-ID: <Pine.A32.3.92.960424171542.43606D@prod1.jcdc.doleta.gov> Content-Description: #!/bin/csh # user_info # will watch display specific user information for Informix Online 7.1 Users # If a number is suppiled at invocation then it is used as the incremental time # when to display user information else the defualt value of 300 (5 min) will # be used. # # Created 1/96 by DBA C.L. Kendricks # DOL Job Corps, San Marcos Texas 800-598-5008 # ########################################################################### set HOSTSYS = ` hostname -s` if ($1 == ) then set SLEEP_TIME = 300 echo sleep_time set to default of 5 min else set SLEEP_TIME = $1 echo sleep_time set to ${1} seconds endif while ( 1 == 1) set TODAYS_DATE = ` date` echo Looking at INFORMIX Users on ${HOSTSYS} ${TODAYS_DATE} $INFORMIXDIR/bin/onstat -g ses > /tmp/x awk '{if ($2!="informix" && $1!="session" && $2!="user" && $1!="INFORMIX-OnLine") {print $1}}' /tmp/x > /tmp/y cat /tmp/x foreach pidid (`cat /tmp/y`) $INFORMIXDIR/bin/onstat -g ses $pidid end rm /tmp/x /tmp/y echo "*************** end for this time*********" sleep ${SLEEP_TIME} end ---1503566844-1938335291-830384142=:43606--