Re: SE, Online and ESQL/C Info

"Linda D. Cornell" <ldc@eskimo.com> wrote: :I am trying to get registered in some training classes since Informix is :new on our site. I've been web-surfing at their training site, but I'm :not sure what I need in what order. : :We're running a large turn-key application and I want to have a good :handle on managing it. I have licenses for SE, Online and ESQL/C and I :was wondering if anyone could tell me what exactly the difference is :between them and how they relate (or don't relate) to each other! : :I've been doing relational "stuff" for several years and I can get to my :data with sql but I feel the need to learn more about how we are set up :and how to manage the environment! : :Any words of wisdom or class recommendations would be greatly appreciated! I can't recomend what classes you should go to (I haven't ever gone to any myself, and hardly think I ever will), but can tell you a little about the engines: SE (Standard Engine) is a small database where each table is stored as an OS file with indexes in a separate OS file. There is no engine running other than whan you start an application. The engine is than automatically started and stops again as soon as you terminate the application. Tuning and other issues for SE are rather simple. OnLine stores data in it's own datastructure usually on a raw device. It can also use a file in the filesystem, but all tables, indexes and so on are stored within this file. OnLine can manages multiple such devices or files with data. OnLine has an engine that's started separately from the application. There are different versions of this engine. From 7.x they are called DSA and OWS (Online Workgroup Server). There is also the Universal Server of course, with version numbers starting on 9.x and XPS which is for large datawarehouses on MPP machines - version numbers on 8.x. With OnLine the tuning issues are significant, and a course on these might be very usefull. ESQL/C is the tool you use when you write C programs to be run against either SE or OnLine. It contains a C library and a preprocessor that converts embeded SQL into calls to the library. : :Linda :ldc@eskimo.com or lcornell@pmcprov.org : :-- :Linda :ldc@eskimo.com Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org