IDS Forum

Re: Installed Informix for the Mac...er, now what?

Posted By: Art Kagel
Date: Monday, 13 June 2011, at 3:49 p.m.

In Response To: Re: Installed Informix for the Mac...er, now what? (Laird Nelson)

See below:

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.

On Mon, Jun 13, 2011 at 12:44 PM, Laird Nelson <ljnelson@gmail.com> wrote:

> On Mon, Jun 13, 2011 at 12:03 PM, Jonathan Leffler <
> jonathan.leffler@gmail.com> wrote:
>
> > Not stupid at all.
> >
>
> OK, but wait till you see my answers to your questions. :-)
>

;-)

>
> > (1) Which version of IDS are you using and did you create a private
> > installation if you have 11.70.FC2?
> >
>
> Well, I went here:
>
>
> https://www14.software.ibm.com/webapp/iwm/web/reg/pick.do?source=ifxids&S_TACT=109HF16W&S_CMP=rnav&lang=en_US
>
> Then I THINK I chose 11.70FC2DE from the mind-numbing list. :-) How would I
> check what version I have, assuming for the moment that I already deleted
> the installation tarball? Is there a "frob --version" command I can run to
> tell for certain?
>
> > (2) Did you ask the installer (permit the installer) to create a demo
> > instance for you?
> >
>
> I think so. (How would I check?)
>

As Jonathan said, the existence of the environment files you found are a
clear indicator that you did.

>
> > * If you did...
> >
> > Then there is an environment setting file somewhere - I think under
> > $INFORMIXDIR/demo but I don't usually use the demo server myself - that
> you
> > can source into your shell to set the environment variables.
> >
> > .. /Applications/IBM/Informix/demo/env-setting-script.sh # Bash, Korn
> > shell, etc
> > source /Applications/IBM/Informix/demo/env-setting-script.csh # Tcsh etc.
> >
> > (You can use the command 'source' in Bash too - but you specify the Bash
> > file, not the C shell file.)
> >
>
> OK, I don't see an env-setting-script.sh (I assume you were just handwaving
> here at the name); I do see some ol_informix1170.csh/.sh files here. These
> look like what you're talking about.
>

Yup.

>
> > Caveat: the server must be running.
>
> How would I tell whether the server is running or not? Via onstat in some
> manner? I say that like I know what I'm talking about, but really I just
>

You can set up the environment by executing one of the environment scripts.
If you use sh/ksh/bash then run the .sh file as a 'dot' script (or "source"
it):

. ol_informix1170.sh

Then you can run the "onstat -" command and the headline of the onstat
report will tell you the server's status. Also, if you run "ps -ef" you
will find a number off "oninit" processes running. These are the database
engine's processes.

saw "stat" in the filename and am guessing. :-) Also, it would be great to
> know what arcane bit of history is responsible for the fact that all the
> administration programs seem to start with "on" instead of, say, "ifx" (a
> few do).
>

The "on" is historical. The original Informix engine, which is now known as
Standard Engine or SE, had utilities prefixed with db* and b*. When
Informix created its first shared memory shared cache version, known as
Turbo, the utilities for it were named beginning with tb* to differentiate
them from the non-shared versions. When Turbo was expanded and improved and
the ability to archive the server while users were actively accessing the
data (ie while "online"), it became Informix OnLine and the utilities were
renamed as on*. That prefix stuck even as Informix Dynamic Server and
eXtended Parallel Server were introduced later.

>
> > If it is not running (because you've
> > rebooted since installing), you need to use 'sudo' privileges (or any
> > equivalent mechanism) to run the server as either user root or user
> > informix. Set the environment for the privileged user and then run
> "oninit"
> > or "oninit -v".
> >
>
> OK. I'll let you respond to my questions and then we'll take it from there
> if you're still (miraculously) willing. :-) Thanks for your help so far.
>

Running onstat -? will print out the list of available status report options
(over 100 IB) and the query tool is known as dbaccess. Your demo instance
will have a demonstration database named 'stores', 'stores7', or
'stores_demo' - haven't actually installed an 11.70 instance with a demo
database so I don't know the exact name. To expand your server you can use
the onspaces utility to add additional data files (known as chunks) to the
existing dbspaces (logical organizations of chunks in which tables and
databases reside) or create new ones. The details are explained in the
Administrator's Guide and the commands are detailed in the Administrator's
Reference Manual.

> Best,
> Laird
>
> --20cf3054a29df9b54404a59a9f69
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--20cf3071c696aefbbe04a59d301a

Messages In This Thread

• Installed Informix for the Mac...er, now what?
  Laird Nelson -- Monday, 13 June 2011, at 9:17 a.m.
  • Re: Installed Informix for the Mac...er, now what?
    amarini@fazenda.ms.gov.br -- Monday, 13 June 2011, at 9:29 a.m.
    • Re: Installed Informix for the Mac...er, now what?
      Laird Nelson -- Monday, 13 June 2011, at 9:43 a.m.
  • Re: Installed Informix for the Mac...er, now what?
    Jonathan Leffler -- Monday, 13 June 2011, at 12:03 p.m.
    • Re: Installed Informix for the Mac...er, now what?
      Laird Nelson -- Monday, 13 June 2011, at 12:44 p.m.
      • Re: Installed Informix for the Mac...er, now what?
        Jonathan Leffler -- Monday, 13 June 2011, at 12:57 p.m.
      • Re: Installed Informix for the Mac...er, now what?
        Art Kagel -- Monday, 13 June 2011, at 3:49 p.m.
        • Re: Installed Informix for the Mac...er, now what?
          Laird Nelson -- Monday, 13 June 2011, at 4:32 p.m.
  • Re: Installed Informix for the Mac...er, now what?
    Obnoxio The Clown -- Monday, 13 June 2011, at 5:41 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.