Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

problems installing informix 7.31 on aix

96 views
Skip to first unread message

Ernst Meyer

unread,
May 26, 2003, 9:17:46 PM5/26/03
to
Hi all

I am experiencing difficulty in getting Informix 7.31 to work on an AIX433
system. The AIX box used to have Informix 9.3 installed. I removed it, then
installed v7.31 successfully. Then I installed ISA, then the SDK client.

When trying to configure the demo database via ISA, I receive the following
error:

>Unable to access onconfig file
/u01/app/informix-7.31/server/etc/onconfig.demo. Click Specify Local
Informix Servers... to check for >incorrect values.

I copied the missing onconfig.demo file from an operational 9.3
installation, and changed the settings about the installation directories in
that file. The I tried to configure the demo database again. This time the
database appears as 'off-line'. When trying to change the mode to on-line, I
get the following error:

>11:07:22 Event alarms enabled. ALARMPROG =
'/usr/informix/etc/log_full.sh'
>11:07:22 Dynamically allocated new virtual shared memory segment (size
8192KB)
>11:07:28 DR: DRAUTO is 0 (Off)
>11:07:28 Requested shared memory segment size rounded from 604KB to 608KB
>11:07:28 Dynamically allocated new message shared memory segment (size
608KB)
>11:07:28 Informix Dynamic Server Version 7.31.FD2 Software Serial
Number ACP#J267193
>11:07:28 Cannot Open Primary Chunk
'/u01/app/informix-7.31/server/demo/server/online_root', errno = 2
>oninit: Cannot open chunk
'/u01/app/informix-7.31/server/demo/server/online_root'. errno = 2
>oninit: Fatal error in shared memory initialization
>11:07:28 Informix Dynamic Server Stopped.
>11:07:28 mt_shm_remove: WARNING: may not have removed all/correct segments

I now manually created the missing directory (server) and the missing file
(online_root). After trying to change the mode to on-line, I now receive
this error:

>oninit: Cannot open chunk
'/u01/app/informix-7.31/server/demo/server/online_root'. errno = 2
>oninit: Fatal error in shared memory initialization

What am I doing wrong? Can someone point me in the right direction how to
install Informix Dynamic Server 7.31 on AIX?

Many thanks.

Ernst Meyer


Michael Krzepkowski

unread,
May 26, 2003, 9:27:17 PM5/26/03
to
Login as informix
set ONCONFIG and INFORMIXSERVER variables
start onmonitor
Parameters->Initialize
Go through all screens, last one will ask if you want to initialize rootdbs. I belive you do.
Then use Mode to bring it up to Online.

I think you understand that any data you had in the database under 9.3
will have to be imported into 7.3, yes?

HTH

Michael

Ernst Meyer

unread,
May 27, 2003, 2:45:18 AM5/27/03
to
Hi Michael
I tried the procedure that you suggested, but got stuck with the missing TERM environment variable. When trying to run onmonitor, I end up with the following: "tb4_main.4gl", line number 71 FORMS statement error number -170  type of your terminal is unknown to the system.
 
I do not know what terminal setting it is expecting. I know that on our terminal console ibm3151 is the correct setting, but onmonitor does not like it.
 
The Informix documentation hasn't been much help. Right now I am at a loss.
 
Ernst
"Michael Krzepkowski" <NOmicha...@sqlcanada.com> wrote in message news:3ED2BED7...@sqlcanada.com...

Nebojsa Sevo

unread,
May 27, 2003, 2:54:52 AM5/27/03
to
On Tue, 27 May 2003 01:17:46 GMT, "Ernst Meyer" <iea...@hotmail.com> wrote:

>
>I now manually created the missing directory (server) and the missing file
>(online_root). After trying to change the mode to on-line, I now receive
>this error:
>
>>oninit: Cannot open chunk
>'/u01/app/informix-7.31/server/demo/server/online_root'. errno = 2
>>oninit: Fatal error in shared memory initialization
>
>What am I doing wrong? Can someone point me in the right direction how to
>install Informix Dynamic Server 7.31 on AIX?

"missong file" is cooked file where your ROOTDBS will be.
You have to change owner and permissions:
chown informix:informix /u01/.../server/online_root
chmod 660 /u01/.../server/online_root

Nebojsa
------------------------------------
Remove spam block (DELETE) to reply

Michael Krzepkowski

unread,
May 27, 2003, 9:35:02 AM5/27/03
to
You can try TERM=ansi and in the worst case (if the screen appears garbled) hit E (for exit).
I don't run AIX here so this is a guess.

HTH

Michael

Ernst Meyer

unread,
May 27, 2003, 9:24:39 PM5/27/03
to
Hi there

Sorry, your suggestion does not address the problem that I've got. I had the
permissions set as pointed out by you already.

Thanks anyway.

Ernst

"Nebojsa Sevo" <DELET...@zg.tel.hr> wrote in message
news:9o26dv8a8ic5dn970...@4ax.com...

Ernst Meyer

unread,
May 27, 2003, 9:33:40 PM5/27/03
to
We are edging closer.
 
I put in the TERM=vt100 variable, PLUS export INFORMIXTERM=terminfo. This allowed me to start onmonitor. However, now I am stuck in onmonitor itself. 
 
When going to 'parameters', initialize', I am stuck on the line 'Primary Path' where I am supposed to put in the pathname of the root dbspace chunk. I have no idea what that means, nor do I want to ;-). I merely want to get a test database up and running.
 
Do you have any suggestions what to put in there, or if I should make any modifications to the onconfig file to work around this?
 
Many thanks for your help so far.
 
Ernst
"Michael Krzepkowski" <NOmicha...@sqlcanada.com> wrote in message news:3ED3696A...@sqlcanada.com...

Tsutomu Ogiwara

unread,
May 27, 2003, 10:40:51 PM5/27/03
to

Hi Ernst.

Try the following.

$ TERMCAP=$INFORMIXDIR/etc/termcap
$ TERM=ibm3151
$ export TERMCAP TERM
$ onmonitor

HTH.

--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592

>From: "Ernst Meyer" <iea...@hotmail.com>
>Reply-To: "Ernst Meyer" <iea...@hotmail.com>
>To: inform...@iiug.org
>Subject: Re: problems installing informix 7.31 on aix
>Date: Tue, 27 May 2003 06:45:18 GMT
>
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_001D_01C3246F.5AB27340
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Hi Michael
>I tried the procedure that you suggested, but got stuck with the missing =
>TERM environment variable. When trying to run onmonitor, I end up with =
>the following: "tb4_main.4gl", line number 71 FORMS statement error =
>number -170 type of your terminal is unknown to the system.=20
>
>I do not know what terminal setting it is expecting. I know that on our =
>terminal console ibm3151 is the correct setting, but onmonitor does not =
>like it.=20
>
>The Informix documentation hasn't been much help. Right now I am at a =
>loss.=20
>
>Ernst=20
> "Michael Krzepkowski" <NOmicha...@sqlcanada.com> wrote in message =


>news:3ED2BED7...@sqlcanada.com...
> Ernst Meyer wrote:
>
>Hi all
>

>I am experiencing difficulty in getting Informix 7.31 to work on an =
>AIX433
>system. The AIX box used to have Informix 9.3 installed. I removed it, =


>then
>installed v7.31 successfully. Then I installed ISA, then the SDK client.
>

>When trying to configure the demo database via ISA, I receive the =


>following
>error:
>
> Unable to access onconfig file
> /u01/app/informix-7.31/server/etc/onconfig.demo. Click Specify Local
>Informix Servers... to check for >incorrect values.
>
>I copied the missing onconfig.demo file from an operational 9.3

>installation, and changed the settings about the installation =
>directories in
>that file. The I tried to configure the demo database again. This time =
>the
>database appears as 'off-line'. When trying to change the mode to =


>on-line, I
>get the following error:
>

> 11:07:22 Event alarms enabled. ALARMPROG =3D
> '/usr/informix/etc/log_full.sh'
> 11:07:22 Dynamically allocated new virtual shared memory segment =


>(size
> 8192KB)
> 11:07:28 DR: DRAUTO is 0 (Off)

>11:07:28 Requested shared memory segment size rounded from 604KB to =


>608KB
>11:07:28 Dynamically allocated new message shared memory segment (size
> 608KB)
> 11:07:28 Informix Dynamic Server Version 7.31.FD2 Software Serial
> Number ACP#J267193
> 11:07:28 Cannot Open Primary Chunk

> '/u01/app/informix-7.31/server/demo/server/online_root', errno =3D 2
> oninit: Cannot open chunk
> '/u01/app/informix-7.31/server/demo/server/online_root'. errno =3D 2


> oninit: Fatal error in shared memory initialization
>11:07:28 Informix Dynamic Server Stopped.

>11:07:28 mt_shm_remove: WARNING: may not have removed all/correct =
>segments
> =20
>I now manually created the missing directory (server) and the missing =


>file
>(online_root). After trying to change the mode to on-line, I now receive
>this error:
>
> oninit: Cannot open chunk

> '/u01/app/informix-7.31/server/demo/server/online_root'. errno =3D 2


> oninit: Fatal error in shared memory initialization

> =20
>What am I doing wrong? Can someone point me in the right direction how =


>to
>install Informix Dynamic Server 7.31 on AIX?
>
>Many thanks.
>
>Ernst Meyer
>
>
> Login as informix

> set ONCONFIG and INFORMIXSERVER variables=20
> start onmonitor
> Parameters->Initialize
> Go through all screens, last one will ask if you want to initialize =


>rootdbs. I belive you do.

> Then use Mode to bring it up to Online.=20
>
> I think you understand that any data you had in the database under 9.3 =


>
> will have to be imported into 7.3, yes?
>
> HTH
>
> Michael
>
>

>------=_NextPart_000_001D_01C3246F.5AB27340
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML><HEAD><TITLE></TITLE>
><META http-equiv=3DContent-Type content=3D"text/html; =
>charset=3Diso-8859-1">
><META content=3D"MSHTML 6.00.2800.1126" name=3DGENERATOR>
><STYLE></STYLE>
></HEAD>
><BODY bgColor=3D#ffffff>
><DIV><FONT face=3DArial size=3D2>Hi Michael</FONT></DIV>
><DIV><FONT face=3DArial size=3D2>I tried the procedure that you =
>suggested, but got=20
>stuck with the missing TERM environment variable. When trying to run =
>onmonitor,=20
>I end up with the following: "tb4_main.4gl", line number 71 FORMS =
>statement=20
>error number -170&nbsp; type of your terminal is unknown to the system.=20
></FONT></DIV>
><DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
><DIV><FONT face=3DArial size=3D2>I do not know what terminal setting it =
>is=20
>expecting. I know that on our terminal console ibm3151 is the correct =
>setting,=20
>but onmonitor does not like it. </FONT></DIV>
><DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
><DIV><FONT face=3DArial size=3D2>The Informix documentation hasn't been =
>much help.=20
>Right now I am at a loss. </FONT></DIV>
><DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
><DIV><FONT face=3DArial size=3D2>Ernst </FONT></DIV>
><BLOCKQUOTE=20
>style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
>BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
> <DIV>"Michael Krzepkowski" &lt;<A=20
> =
>href=3D"mailto:NOmicha...@sqlcanada.com">NOmicha...@sqlcanada.com=
></A>&gt;=20
> wrote in message <A=20
> =
>href=3D"news:3ED2BED7...@sqlcanada.com">news:3ED2BED7.3040306@sqlcan=
>ada.com</A>...</DIV>Ernst=20
> Meyer wrote:<BR>
> <BLOCKQUOTE cite=3Dmid_0zAa.207$Ve4....@news.optus.net.au =
>type=3D"cite"><PRE wrap=3D"">Hi all
>
>I am experiencing difficulty in getting Informix 7.31 to work on an =
>AIX433
>system. The AIX box used to have Informix 9.3 installed. I removed it, =


>then
>installed v7.31 successfully. Then I installed ISA, then the SDK client.
>

>When trying to configure the demo database via ISA, I receive the =
>following
>error:
>
> </PRE>
> <BLOCKQUOTE type=3D"cite"><PRE wrap=3D"">Unable to access onconfig =
>file
> </PRE></BLOCKQUOTE><PRE =
>wrap=3D""><!---->/u01/app/informix-7.31/server/etc/onconfig.demo. Click =
>Specify Local
>Informix Servers... to check for &gt;incorrect values.


>
>I copied the missing onconfig.demo file from an operational 9.3

>installation, and changed the settings about the installation =
>directories in
>that file. The I tried to configure the demo database again. This time =
>the
>database appears as 'off-line'. When trying to change the mode to =


>on-line, I
>get the following error:
>

> </PRE>
> <BLOCKQUOTE type=3D"cite"><PRE wrap=3D"">11:07:22 Event alarms =
>enabled. ALARMPROG =3D
> </PRE></BLOCKQUOTE><PRE =
>wrap=3D""><!---->'/usr/informix/etc/log_full.sh'
> </PRE>
> <BLOCKQUOTE type=3D"cite"><PRE wrap=3D"">11:07:22 Dynamically =


>allocated new virtual shared memory segment (size

> </PRE></BLOCKQUOTE><PRE wrap=3D""><!---->8192KB)
> </PRE>
> <BLOCKQUOTE type=3D"cite"><PRE wrap=3D"">11:07:28 DR: DRAUTO is 0 =
>(Off)
>11:07:28 Requested shared memory segment size rounded from 604KB to =


>608KB
>11:07:28 Dynamically allocated new message shared memory segment (size

> </PRE></BLOCKQUOTE><PRE wrap=3D""><!---->608KB)
> </PRE>
> <BLOCKQUOTE type=3D"cite"><PRE wrap=3D"">11:07:28 Informix Dynamic =


>Server Version 7.31.FD2 Software Serial

> </PRE></BLOCKQUOTE><PRE wrap=3D""><!---->Number ACP#J267193
> </PRE>
> <BLOCKQUOTE type=3D"cite"><PRE wrap=3D"">11:07:28 Cannot Open =
>Primary Chunk
> </PRE></BLOCKQUOTE><PRE =
>wrap=3D""><!---->'/u01/app/informix-7.31/server/demo/server/online_root',=
> errno =3D 2
> </PRE>
> <BLOCKQUOTE type=3D"cite"><PRE wrap=3D"">oninit: Cannot open chunk
> </PRE></BLOCKQUOTE><PRE =
>wrap=3D""><!---->'/u01/app/informix-7.31/server/demo/server/online_root'.=
> errno =3D 2
> </PRE>
> <BLOCKQUOTE type=3D"cite"><PRE wrap=3D"">oninit: Fatal error in =


>shared memory initialization
>11:07:28 Informix Dynamic Server Stopped.

>11:07:28 mt_shm_remove: WARNING: may not have removed all/correct =
>segments
> </PRE></BLOCKQUOTE><PRE wrap=3D""><!---->
>I now manually created the missing directory (server) and the missing =


>file
>(online_root). After trying to change the mode to on-line, I now receive
>this error:
>

> </PRE>
> <BLOCKQUOTE type=3D"cite"><PRE wrap=3D"">oninit: Cannot open chunk
> </PRE></BLOCKQUOTE><PRE =
>wrap=3D""><!---->'/u01/app/informix-7.31/server/demo/server/online_root'.=
> errno =3D 2
> </PRE>
> <BLOCKQUOTE type=3D"cite"><PRE wrap=3D"">oninit: Fatal error in =
>shared memory initialization
> </PRE></BLOCKQUOTE><PRE wrap=3D""><!---->
>What am I doing wrong? Can someone point me in the right direction how =


>to
>install Informix Dynamic Server 7.31 on AIX?
>
>Many thanks.
>
>Ernst Meyer
>
>

> </PRE></BLOCKQUOTE>Login as informix<BR>set ONCONFIG and =
>INFORMIXSERVER=20
> variables <BR>start onmonitor<BR>Parameters-&gt;Initialize<BR>Go =
>through all=20
> screens, last one will ask if you want to initialize rootdbs. I belive =
>you=20
> do.<BR>Then use Mode to bring it up to Online. <BR><BR>I think you =
>understand=20
> that any data you had in the database under 9.3 <BR>will have to be =
>imported=20
> into 7.3, =
>yes?<BR><BR>HTH<BR><BR>Michael<BR><BR></BLOCKQUOTE></BODY></HTML>
>
>------=_NextPart_000_001D_01C3246F.5AB27340--
>

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail

Michael Krzepkowski

unread,
May 28, 2003, 12:58:12 AM5/28/03
to
Ernst Meyer wrote:
We are edging closer.
 
I put in the TERM=vt100 variable, PLUS export INFORMIXTERM=terminfo. This allowed me to start onmonitor. However, now I am stuck in onmonitor itself. 
 
When going to 'parameters', initialize', I am stuck on the line 'Primary Path' where I am supposed to put in the pathname of the root dbspace chunk. I have no idea what that means, nor do I want to ;-). I merely want to get a test database up and running.
It wants the name of a file (cooked - part of file system) or raw partition from your disk to put the initial
rootdbs on it. If you have the old onconfig printout it can be the same file (or partition).
Try with "ls -l" to make sure it is owned by user "informix" and group "informix" and has rw-rw-r-- (at least).



 
Do you have any suggestions what to put in there, or if I should make any modifications to the onconfig file to work around this?
I assume this is your "play" machine.... Make changes to onconfig. You can always reinstall IDS and get everything back.

 
Many thanks for your help so far.
 
Ernst
BTW Go to ibm.com/informix click on Library and find appropriate IDS docs (Installation and Server Admin).

HTH

Michael

Ernst Meyer

unread,
May 28, 2003, 1:42:40 AM5/28/03
to
Hi Michael
 
Why is this so hard? I've managed to kick off the initialisation of the database after all, after a lot of tweaking with the syntax. but now, alas, I get this: oninit: DBSERVERNAME 'aix433' not in sqlhosts file or sqlhosts file contents are damaged'.
 
I've got an aix51 machine which is running Informix 9.3. I had a look at the sqlhosts file on that machine, and it looks exactly the same as the file that I have on my problem 7.31 machine. I even copied the 9.3 file to the 7.3 install, but no luck.
 
Then I decided to put an entry for my aix433 machine into this sqlhosts file. when I looked up the syntax in the IBM documentation, I had no pleasure either. I do not know what to put into the file.
 
I'd appreciate if you could pass on any suggestions as to what the entry in the sqlhosts file is supposed to be.
 
Many thanks.
 
Ernst
"Michael Krzepkowski" <NOmicha...@sqlcanada.com> wrote in message news:3ED441C6...@sqlcanada.com...

Mark D. Stock

unread,
May 28, 2003, 5:51:49 AM5/28/03
to

Ernst Meyer wrote:
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0049_01C3250C.FA904520

> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable

Don't post mime.

> We are edging closer.=20
>
> I put in the TERM=3Dvt100 variable, PLUS export INFORMIXTERM=3Dterminfo. =
> This allowed me to start onmonitor. However, now I am stuck in onmonitor =
> itself.=20

Stuck?

> When going to 'parameters', initialize', I am stuck on the line 'Primary =
> Path' where I am supposed to put in the pathname of the root dbspace =
> chunk. I have no idea what that means, nor do I want to ;-). I merely =
> want to get a test database up and running.=20

Eeek, then I think you have the wrong product. There is more to setting
up IDS than just hitting the install button. There are several
configuration parameters to set as well as your sqlhosts file. All
documented in the fine manuals.

Have you considered using SE instead?

> Do you have any suggestions what to put in there, or if I should make =


> any modifications to the onconfig file to work around this?

That's your primary disk storage, so there's no work around. You have 3
choices; use a database server that requires less administration, get an
administrator to do it for you, become an administrator yourself.

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mds...@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+

Nebojsa Sevo

unread,
May 28, 2003, 8:31:43 AM5/28/03
to
On Tue, 27 May 2003 01:17:46 GMT, "Ernst Meyer" <iea...@hotmail.com> wrote:

>When trying to configure the demo database via ISA, I receive the following
>error:
>
>>Unable to access onconfig file
>/u01/app/informix-7.31/server/etc/onconfig.demo. Click Specify Local
>Informix Servers... to check for >incorrect values.
>

Does it mean that your INFORMIXDIR is '/u01/app/informix-7.31/server'?

>>11:07:28 Cannot Open Primary Chunk
>'/u01/app/informix-7.31/server/demo/server/online_root', errno = 2
>>oninit: Cannot open chunk
>'/u01/app/informix-7.31/server/demo/server/online_root'. errno = 2
>>oninit: Fatal error in shared memory initialization
>>11:07:28 Informix Dynamic Server Stopped.
>>11:07:28 mt_shm_remove: WARNING: may not have removed all/correct segments
>
>I now manually created the missing directory (server) and the missing file
>(online_root). After trying to change the mode to on-line, I now receive
>this error:
>
>>oninit: Cannot open chunk
>'/u01/app/informix-7.31/server/demo/server/online_root'. errno = 2
>>oninit: Fatal error in shared memory initialization

So, you did:
cd $INFORMIXDIR
mkdir demo
chmod 777 demo
cd demo
mkdir server
chmod 777 server
cd server
cat /dev/null > online_root
chown informix:informix online_root
chmod 666 online_root

If yes - I don't know what to say. Errno = 2 is:
#define ENOENT 2 /* No such file or directory */

Ernst Meyer

unread,
May 28, 2003, 8:30:31 PM5/28/03
to
thanks to all participants. I finally managed to install Informix 7.31 on
AIX433. The problems that I have been experiencing where two-fold. For
whatever reason, the Informix install did not pick up the environment
variables that I had set in AIX433. As a result, I had to figure out for
myself what path to use for tape devices etc and log files etc.

The other problem was that I failed to configure the onconfig.demo file
properly. I was under the impression that DBSERVERNAME was to point to the
hostname. Once I figured out my mistake and rectified it, all was well.

I did the same install on AIX51 afterwards, without a glitch. No problems
with environment variables at all. Don't know what was wroing with AIX433.

I have done basic installs of Informix 9.3 on AIX, SCO, Solaris, HP-UX, SGI,
and Linux. I found it fairly straightforward. However, I found 7.31 install
rather tedious.

Many thanks once again.


"Nebojsa Sevo" <DELET...@zg.tel.hr> wrote in message

news:mma9dv07fvfkniegf...@4ax.com...

0 new messages