ISA connecting to a not very certain informix installation

[chaio]

ISA with a not very certain informix installation

Please help me,
I cant connect ISA to my IDS (probably the IDS is installed poorly)

My ISA config is

INFORMIXSERVER instance2
INFORMIXDIR /usr/informix
ONCONFIG onconfig
END

INFORMIXSERVER instance1
INFORMIXDIR /usr/informix
ONCONFIG onconfig
END

Then ISA reports
Server Host Status Up Time Memory Version
instance1 local Off-Line IBM Informix Dynamic Server Version 10.00.UC3R1TL Software Serial Number AAA#B000000
instance2 local Off-Line IBM Informix Dynamic Server Version 10.00.UC3R1TL Software Serial Number AAA#B000000

Please help me?


History:
I’ve downloaded from IBM.com and installed for the first time IDS 10.0 with its 90 days trial period (that proves to be 180 days for I cant explain why).

I’ve initialized a cocked file as ‘echo > /usr/data/root_chunk’ and give Informix:Informix ownerships 660.
# ls /usr/data/ -l
total 30029
drw-rw---- 2 informix informix 80 Jan 11 17:09 .
drwxr-xr-x 14 root root 456 Jan 10 20:01 ..
-rw-rw---- 1 informix informix 30720000 Jan 11 17:12 root_chunk

I’ve run through the onmonitor -> Initialize lots of times with messages “Cannot initialize shared memory” and at some point of wondering through onconfig and sqlhosts and changing misc data the Initialization process accepted it in the end. Thus I’m not certain if the current one will do me any good.

Configurations that are now and are probably wrong now are:

####ONCONFIG
ROOTNAME root_chunk # Root dbspace name
ROOTPATH /usr/data/root_chunk # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 30000 # Size of root dbspace (Kbytes)
……
SERVERNUM 0 # Unique id corresponding to a OnLine instance
DBSERVERNAME instance1 # Name of default database server
DBSERVERALIASES instance2 # List of alternate dbservernames
NETTYPE soctcp,1,150,NET
….

####SQLHOSTS
instance1 onipcshm 127.0.0.1 dummy # For shared mem conn.
instance2 onsoctcp 127.0.0.1 informix_lop # For network conn.

Server at the beginning run as Quiescent mode and I gave onmode –m
Now the following might give a clue:

informix1:/usr/informix/etc # onstat
Your evaluation license will expire on 2006-07-09 00:00:00
IBM Informix Dynamic Server Version 10.00.UC3R1TL -- On-Line -- Up 00:06:42 -- 20036 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads nwrites
444fa018 ---P--D 1 root - 0 0 0 3 7019
444fa544 ---P--F 0 root - 0 0 0 0 21
444faa70 ---P--- 9 root - 0 0 0 0 0
444faf9c ---P--D 10 root - 0 0 0 0 0
444fb4c8 Y--P--D 12 root - 4407c130 0 0 0 0
444fb9f4 ---P--B 13 root - 0 0 0 0 0
444fbf20 ---P--- 14 root - 0 0 0 0 0
7 active, 128 total, 6 maximum concurrent
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
3 3 63 95.24 49 7040 36 0.00
isamtot open start read write rewrite delete commit rollbk
8 2 2 0 0 0 0 1 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 0.03 0.05 2 7
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
0 0 2 0 0 0 2 0
ixda-RA idx-RA da-RA RA-pgsused lchwaits
0 0 0 0 0

I Can create a database / table and execute queries from “dbaccess” tool. Cant tell if I can access it with perl/cpp/etc for I'm still waiting for trial approval on ESQL/C libs and havent installed them.


Regards,
Steven

 

[vpshriyan]

IDS configuration seems to be OK for a test box. Post outputs of commands below:

1. onstat -g dis
2. grep informix_lop /etc/services

 

[chaio]

vpshriyan 10x for the time taken. Really I appreciate any help that I can find.

There is an entry that I entered before by hand along with a lot of others as for I was wondering around a lot of not helping literature and topics of forums including this one.
--------------
grep informix_lop /etc/services
informix_lop 1545/tcp # vistium-share
---------------------
server is on SLES9
-------------------
informix1:~ # onstat -g dis
Your evaluation license will expire on 2006-07-09 00:00:00

IBM Informix Dynamic Server Version 10.00.UC3R1TL -- On-Line -- Up 00:06:08 -- 20036 Kbytes
There are 2 servers found
Server : instance1
Server Number : 0
Server Type : IDS
Server Status : Up
Server Version: IBM Informix Dynamic Server Version 10.00.UC3R1TL
Shared Memory : 0x44000000
INFORMIXDIR : /opt/IBM/informix
ONCONFIG : /opt/IBM/informix/etc/onconfig
SQLHOSTS : /opt/IBM/informix/etc/sqlhosts
Host : informix1

Server : informix1
Server Number : 0
Server Type : IDS
Server Status : Up
Server Version: IBM Informix Dynamic Server Version 10.00.UC3R1TL
Shared Memory : 0x44000000
INFORMIXDIR : /opt/IBM/informix
ONCONFIG : /opt/IBM/informix/etc/onconfig
SQLHOSTS : /opt/IBM/informix/etc/sqlhosts
Host : informix1
------------------------------
informix1:~ # oninit
Your evaluation license will expire on 2006-07-09 00:00:00
oninit: Fatal error in shared memory creation
-------------
With this oninit I get confused also.
-------------
ISA still gives me OFFLINE

What can I do now?

 

[vpshriyan]

slightly on off-subject:
"oninit: Fatal error in shared memory creation" message is due to execution of oninit command while dbserver instance is already initilized in the shared memory.

To ascertain if shared memory initialization has any issues, first do a complete shutdown by onmode -uky and start the instance by oninit -v and lookout for any verbose mode errors.

 

[chaio]

vpshriyan 10x for the time taken again. Really I appreciate your help.

The error with oninit command ("oninit: Fatal error in shared memory creation") already is not present.When I initilized dbserver in verbose mode it looks like everything is allright.....I don't see any mode errors:

------------------------
informix1:~ # oninit -v
Your evaluation license will expire on 2006-07-09 00:00:00
Checking group membership to determine server run mode...succeeded
Reading configuration file '/opt/IBM/informix/etc/onconfig'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/opt/IBM/informix/etc/.infos.instance1"...succeeded
Linking conf file "/opt/IBM/informix/etc/.conf.instance1"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 866 kbytes...succeeded
Allocating 18384 kbytes for buffer pool of 2K page size...succeeded
Initializing rhead structure...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'ipcshm' listener threads...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded
Initializing log/checkpoint information...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Initializing dbspaces...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Forking btree cleaner...succeeded
Initializing DBSPACETEMP list...succeeded
Checking database partition index...succeeded
Checking location of physical log...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Forking onmode_mon thread...succeeded
Verbose output complete: mode = 5
-------------------------------------

ISA still gives me OFFLINE

Where am I wrong ?

The problem really confused me...

Have you any ideas ?

 

[vpshriyan]

The ISA installation program adds environment variables (INFORMIXSERVER, INFORMIXDIR, ONCONFIG ) to the isadir/etc/isacfg file. Review it for its correctness.

One more point - You must start the ISA Apache HTTP server before you can access ISA. To start the server manually as user informix, run the isadir/sbin/isactl start command.