I am trying to set up an informix database on an SGI system for benchmarking purposes only. I will be connecting from the same location where the database server is kept and the only user will be the informix user.
I cannot get the sqlhosts file settings correct so I can run oninit -iy
my settings look like this
bench_tcp onipcshm Origin3000 turbo
My onconfig.bench shows:
No matter what I do, I get an error when starting oninit that states the following:
error: Unable to locate DBSERVERNAME Origin3000 in sqlhosts file or the sqlhosts file is corrupted.
ANY help that can be offered will be greatly appreciated!!
4) Add service 'bench_tcp' to your /etc/services file
Now you have configured two connections (one local using
shared memory ipc) and one for remote clients (using tcp).
Then shared memory connection will be faster, but can only
be used for local clients.
You need also to lookup the correct protocol in your
IFMX releasenotes. (it could be 'ontlitpc' or 'onsoctcp').
This is platform dependend.
I thought that too about the environment variable..but it wasn't true. I looked and looked and could never come up with what was causing the system to think that my DBSERVERNAME was suppose to be Origin3000.
(the server name was a residual from my attempts to try to set it up with tcpip teletype)
I finally found the correct syntax at about 5pm today. I left my sqlhosts file the same but added a root path and the correct nettype in my config.bench file.
I've been workign on this all night, and as we speak I have the database finally LOADING!!
I will come back tomorrow when I have a clearer head and post the details of the settings that worked. (After I solved this issue the geodetic blade module and table spaces started choking!)