Re[2]: Informix Training
What we covered (in a nutshell) - keep in mind this was a Beta class
-- first time offered to non-informixers:
DBspace layout (hex dumps of the actual pages -- whats in them)
Tablespace layout (hex dumps)
index architecture (yet more hex dumps) -- lotsa oncheck usage here to
see what happens when a new row is added.
Fragmented tables (differences from above)
Blobspace details (more hex...)
Shared memory details - how its allocated, how you attach, how its
tracked...
Online communications - detailed look at how connections are made.
Logging details/recovery details -- did not have time to cover these.
but they are in the book..
To answer the question on onstat -- I can't remember even typing it
once. Lots of oncheck, but no onstat...
I would recommend the performance tuning class for the types of questions you
have.
______________________________ Reply Separator _________________________________
Subject: Re: Informix Training
Author: David Williams <djw@smooth1.demon.co.uk> at Internet
Date: 9/12/97 10:36 PM
In article <5v4e5r$7ij@cssun.mathcs.emory.edu>, James T Ford
<James_T_Ford@fleet.com> writes
I would be interested in more info about what you convered,
apart form hex dumps of disk structures did you cover anything about
how Online works internally. Onstat has a lot of undocumented
options especially on the networking side of things. And how DOES
PDQ priority > 1 REALLY affect number of scan threads allocated etc.
> I took it. Spent the first 3 days staring at hex dumps of informix
> system pages. It was interesting but not truly helpful imho. It is
> truly an internal architecture class - bits and bytes of how the
> engine works.
>
>
>______________________________ Reply Separator
_________________________________
>Subject: Informix Training
>Author: bweaver@fscorp.com at Internet
>Date: 9/9/97 1:37 PM
>
>
>Has anyone taken the Informix OnLine Dynamic Server Internal Architecture and
>Advance
>Administration class? Is it worthwhile, marginally helpful, or a complete
>waste? I've
>had the Server Administration course and I'm wondering if there is enough
>benefit in the
>Advanced course to justify the time and money. Any and all opinions welcome!
>-------------------------------------
>Name: Bill Weaver
>E-mail: bweaver@fscorp.com
>Date: 9/9/97
>Time: 1:37:20 PM
>
>This message was sent by Chameleon
>-------------------------------------
>
--
David Williams