Re: Shared Mem FAQ's, was malloc...
Joe books works good in many instances for 7 as well. I have both and for
those of you who are waiting on a copy of my scripts, let me tell you how
good his scripts are. I first combined the seeuser and watchhot scripts
for my 5 engine on AIX 3.2. When my 7 engine came along 5 months later, I
ported that script to my New machine with Informix 7 and AIX 4.1 changed
the tbstat to onstat, added some parameters to look out for as explained in
Suto's book and it ran like a champ!
I later created a script to look at the onstat -g ses
(for those new DBAs this looks at each user's session, down to SQL they
are running).
So if you are a NEW DBA get these two books!!!!!, once you get my scripts
you will need them to understand the data you are looking at.
And YES these two scripts and of course those books helped me resolve
and identify some problems with my 7.x engine. It even caught an Informix
bug the Informix Tech could not resolve, but via those script I was able
to find the problem!
-------------------------------------------------------------------------
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, Clem Akins wrote:
> > well, from reading this group it seems that a lot of us cry for help
> > when *shared memory* is the word.
> >
> > Anyone know of some FAQs on the subject ?
>
> Of course, see Kerri's c.d.i. FAQ. If you think of additions to be made,
> perhaps he'll add them.
>
> In addition to the standard docs (RTFM!) and o/s knowledge, there are
> a couple of good books out:
>
> "Informix-OnLine Performance Tuning" by Elizabeth Suto
> ISBN 0-13-124322-5, Informix Press 1995
> She has a whole chapter on managing shared memory, and
> covers a little about v5 and 6+ both.
>
> "Informix Database Administrator's Survival Guide"
> by Joe Lumbley ISBN 0-13-124314-4, Informix Press 1995
> Joe's book is written in a more friendly, less FM-like
> manner that makes it a good choice for those just
> starting to wear the DBA hat. He has most of a chapter
> on memory. The version I have works for v5, but I think(?)
> there's a new release promised.
>
> I'm going to start demanding kickbacks for these books...
>
> Clem
> __________________________________________________________________
> | Clem Akins clema@informix.com |
> | International Support formerly |
> | Informix Software, Inc cwakins@leia.alloys.rmc.com |
> | Menlo Park, California, USA Standard Disclaimers Apply |
> |________________________________________________________________|
>