Hi,

I'm trying to set up a new installation of Informix, and not having
done anything much with Informix for something like 5 years, I recon
I'm a bit rusty ...

Install is on a Linux system, Informix is 9.40UC7. It seems to be
running halfway, oninit -i initialized the rootdbs it seems, onstat
shows this:

IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up
00:28:54 -- 157052 Kbytes

Userthreads
address flags sessid user tty wait tout locks nreads
nwrites
16abb018 ---P--D 1 root - 0 0 0 18
7
16abb630 ---P--F 0 root - 0 0 0 0
0
16abbc48 ---P--- 6 root - 0 0 0 0
0
16abc260 ---P--B 7 root - 0 0 0 0
0
16abd4a8 ---P--D 10 root - 0 0 0 0
0
16abdac0 Y--P--D 13 root - 1008b944 0 0 0
0
6 active, 128 total, 18 maximum concurrent

Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
21 37 28 25.00 7 7 0 0.00

isamtot open start read write rewrite delete commit
rollbk
12 4 4 0 0 0 0 0
0

gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0

ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 3.07 0.40 1 14

bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
0 0 0 0 0 0 0 0

ixda-RA idx-RA da-RA RA-pgsused lchwaits
0 0 0 0 1

I've mostly copied onconfig from the old install (Inf 9.30 though),
sqlhosts file should be OK, too ...

gekos onipcshm gekos gekos

Shared memory for communication seems to be set up right, too:

----- Gemeinsamer Speicher: Segmente -----
Schlüssel shmid Besitzer Rechte Bytes nattch
Status
0x07021999 0 root 644 1420 2
0x00000000 720897 informix 660 33554432 1 dest
0x00000000 753666 informix 660 33554432 1 dest
0x00000000 786435 informix 660 33554432 1 dest
0x00000000 819204 informix 660 9162752 1 dest
0x00000000 851973 informix 660 33554432 1 dest
0x00000000 884742 informix 660 16777216 1 dest
0x00000000 917511 informix 666 663552 1 dest
0x52574801 1048584 informix 660 109826048 12
0x52574802 1081353 informix 660 50331648 12
0x52574803 1114122 informix 666 663552 12

onmonitor complains about "Network down" - where can I check what could
be causing this?

Also, should ontape on this install be able to restore an image create
with 9.30UC2 on the old system? I get this when I try a -p or -r:

Please mount tape 1 on /tmp/a2 and press Return to continue ...
Physical restore failed - function read archive backup failed code -1
errno 0

Program over.


Thanks!!!

disposablegarry@googlemail.com wrote:
> Hi,
>
> I'm trying to set up a new installation of Informix, and not having
> done anything much with Informix for something like 5 years, I recon
> I'm a bit rusty ...
>
> Install is on a Linux system, Informix is 9.40UC7. It seems to be
> running halfway, oninit -i initialized the rootdbs it seems, onstat
> shows this:
>
> IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up
> 00:28:54 -- 157052 Kbytes

As it says in the onstat output heading, the engine is fully online. Your
problem with onmonitor could be environment var setup. It's hard to guess.

<SNIP>
> onmonitor complains about "Network down" - where can I check what could
> be causing this?

Contact support. Any new install gets installation support.

> Also, should ontape on this install be able to restore an image create
> with 9.30UC2 on the old system? I get this when I try a -p or -r:

No. Ontape will not restore an archive from a different version. You'd
have to get 9.30 to do the restore then upgrade that restored instance to
9.40 in place by starting the new software with ROOTDB pointed to the
restored root dbspace.

<SNIP>

Art S. Kagel

Hm ... I was trying to get the environment variables together that need
to be set for onmonitor to work - somehow, this does not work out, must
be missing one or more ... what variables need to be set?

Tnx!

OK, an update ...

It wasn't the environment variables, but some Online-process couldn't
access the /etc/shadow file ... once I opened it up for tests,
onmonitor started to work! I have been able to successfully create
another dbspace, changed the physical log size, etc ...

Anyway, connecting to the Online server via dbaccess does not yet work
-

25588: The appl process cannot connect to Dynamic Server gekos.

(gekos being the dbserver name)

Any idea?

After finally being kind of fed up, I changed the config to use
socket/tcp connections instead of shared memory IPC. At least this way,
I can already run dbaccess without any problems ...

Anyway, while all this seems to work, the sysmaster database seems to
be missing ... shouldn't this have been created by "oninit -i"?

Tnx

> Anyway, while all this seems to work, the sysmaster database seems to
> be missing ... shouldn't this have been created by "oninit -i"?

OK; forget that one, found the .sql-script in the etc directory ...

On 10 Jul 2006 06:28:49 -0700, "disposablegarry@googlemail.com"
<disposablegarry@googlemail.com> wrote:

>OK, an update ...
>
>It wasn't the environment variables, but some Online-process couldn't
>access the /etc/shadow file ... once I opened it up for tests,
>onmonitor started to work! I have been able to successfully create
>another dbspace, changed the physical log size, etc ...
>
>Anyway, connecting to the Online server via dbaccess does not yet work
>-
>
> 25588: The appl process cannot connect to Dynamic Server gekos.
>
>(gekos being the dbserver name)
>
>Any idea?

can you connect using shared memory?

JWC