Re: unexpected virtual processor termination
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-140477562-830393090=:47444
Content-Type: TEXT/PLAIN; charset=US-ASCII
It took me awhile, sorry folks: user_info has already been posted
this is a very basic monitoring script. It helps, yet you got to know
your Informix Info ..... So get Joe Lumbley's book and the Admin. Guide's
and Good-luck.
Neil you are welcome to add this to the www.iiug.org website.
-------------------------------------------------------------------------
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 Mon, 15 Apr 1996, Jim Will wrote:
> Cheryl
>
> I would appreciate a copy of your monitoring scripts.
> Thanks in advance.
>
> Jim Will <jwill@stl-17lssc.army.mil>
> USA MICOM LSSC, ATTN: AMSMI-LS-TD, 1222 Spruce St., St. Louis, MO 63103-2834
> COMMERCIAL: (314) 331-4525 DSN: 555-4525
> relay1.uu.net!stl-17lssc.army.mil!jwill
>
---1503566844-140477562-830393090=:47444
Content-Type: TEXT/PLAIN; charset=US-ASCII; name=seeuser_watchhot
Content-Transfer-Encoding: BASE64
Content-ID: <Pine.A32.3.92.960424194450.47444A@prod1.jcdc.doleta.gov>
Content-Description:
#!/bin/csh
#seeuser_and_watch_hot (modified seeuser and whatch_hot from Joe Lumbly)
# will watch all user on Online Informix at Sleep interval time specified and
# see any hot processing jobs ( watch every 15 and hot every hour) by default
# If a time is supplied it will watch in that inverval for 4 times then on the
# 5th pass is will do the Hot display.
# done by C. L. KENDRICKS, DBA, DOL JOB CORPS 800-598-5008 (DTSI)
#
###############################################################################
set HOSTSYS = ` hostname -s`
set pass_cnt = 0
if ($1 == ) then
set SLEEP_TIME = 900
echo sleep_time set to default of every 15 minutes
else
set SLEEP_TIME = $1
echo sleep_time set to ${1} seconds
endif
echo The SLEEP_TIME is ${SLEEP_TIME} seconds
while ( 1 == 1)
set target = .
set TODAYS_DATE = ` date`
echo Looking at INFORMIX jobs for ALL Users on ${HOSTSYS} ${TODAYS_DATE}
echo "\\
Users \\
address flags pid user tty wait tout locks nreads nwrites"
echo " "
$INFORMIXDIR/bin/onstat -u | grep $target | grep -v grep
echo "\\
^^^^^ ^ \\
||||| |\\
POSTION 12345 7\\
\\
1 WAITING ON: B(uffer) C(hkpt) G(log. log) L(ock) S(latch) T(Tran) X(rollback)\\
2 TRANSACTIONS: *(active during an I/O failure)\\
3 A(rch.) B(Work) P(I-Star) X(TP/XA) C(ommitting) R(ollback) H(eurist. Rollback) \\
4 P(rimay thread for a Session)\\
5 Reading (rsam call) X(in critical section)\\
7 B(tree cleaner) C(lean-up) D(daemon) F(page-cleaner) M(on-monitor)"
echo " "
echo " "
echo "----- Looking at Latches, Tablspaces, Locks, Profile and LRU -----"
echo " On ${HOSTSYS} ${TODAYS_DATE} "
$INFORMIXDIR/bin/onstat -lstkpF
echo "******** Looking at UNIX Page Swappwing Information *********"
echo "***** %Used > 50 or Percent Used > 80 need more Paging Space ******"
lsps -s
lsps -a
sleep ${SLEEP_TIME}
@ pass_cnt = ( $pass_cnt + 1)
if ( $pass_cnt == 5 ) then
set pass_cnt = 0
set TODAYS_DATE = ` date`
echo " The following is the HOT HOT and DISK Space Report for ${TODAYS_DATE} "
echo " Stats for Log Statistics will be ZEROED out"
echo " "
$INFORMIXDIR/bin/onstat -D | grep /
echo " -------------------------------------------------------------- "
echo " "
$INFORMIXDIR/bin/onstat -d | grep /d2/informix | sort -t/ +3
echo " -------------------------------------------------------------- "
echo " "
$INFORMIXDIR/bin/onstat -z
sleep ${SLEEP_TIME}
endif
end
---1503566844-140477562-830393090=:47444--