Red Hat Linux IDS Installation Problems
Craig Bellusci
I'm a long time SE user, new to online.
The problem I'm having:
I initialize with oninit -i, then
onstat -m give me these errors
04:38:09 Building 'sysmaster' database ...
04:38:16 Error building 'sysmaster' database.
04:38:16 See '/tmp/buildsmi.4347'.
Our System info:
Red Hat Linux V6.0
Engine: 7.3.UC7-2
/usr/informix/sqlhosts: tin_ids sesoctcp tin.bdsn.com ids1
/etc/services: ids1 1537/tcp #Informix IDS
The problem seems to be that the scripts that build the sysmaster database
won't find the server. They only refer to the database name.
If I run 'isql cms', the system responds with 'database not found or no
system permission'.
If I run 'isql cms@tin_ids', it opens the database just fine.
Any ideas?
Thanks in advance
Art S. Kagel
servername, thus:
export INFORMIXSERVER=tin_ids
Do this in the engine's environment as well and shutdown and restart.
The sysmaster build will be attempted again. If if fails run the
$INFORMIXDIR/lib/buildsmi script by hand, it usually works that way in
the rare instance that it fails during the boot.
Art S. Kagel
Craig Bellusci
Thanks for replying.
Yes, I have the INFORMIXSERVER variable set. I can build and work with
databases through isql or dbaccess. I just have to make certain to use
dbname@tin_ids instead of just dbname. I edited the files
$INFORMIXDIR/etc/buildsmi and $INFORMIXDIR/etc/bldutil.sh to have all
references to databases add the @tin_ids, and the sysmaster database built
just fine. (Thanks for that hint Rick!)
Now that the sysmaster database is built properly, I thought the other
problem(s) I'm having would go away, but they haven't. I rcp'd a couple of
things over that work on our 7.2 SE running on an IBM AIX computer. Neither
works on the Linux IDS. The first one is a dbexport from the SE. It fails at
different points each time, but always with the same error.
create table "informix".cs_claim
(
rpt_unit_id char(5),
case_id char(10),
event_date date
);
*** put loadcur
25580 - System error occurred in network function.
*** database
404 - The cursor or statement is not available.
*** database
349 - Database not selected yet.
The other one is from an sql script run from choose--run within isql or
dbaccess run as user informix. It fails with:
CREATE PROCEDURE sp_xmit_cl(c_table CHAR(18), c_rpt_unit CHAR(5),
c_case CHAR(10), c_ser_no INTEGER,
c_old_rec_date DATE, c_new_rec_date DATE,
c_action CHAR(2))
DEFINE c_payor CHAR(10); -- We find the payor, and put in here
# ^
# 201: A syntax error has occurred.
Both the dbimport and the sql script work properly on the SE/IBM
combination.
Thanks,
Craig
Art S. Kagel <ka...@bloomberg.net> wrote in message
news:376827CD...@bloomberg.net...
Craig Bellusci
My ONCONFIG was not set. All the others were set properly. Once it was set
properly I am able to run the sql script to create a database properly. It
no longer chokes on the create stored procedure spl statement.
env returns: (I've removed most stuff)
USERNAME=root
HOSTNAME=tin.bdsn.com
LOGNAME=informix
ONCONFIG=/usr/informix/etc/onconfig
PATH=/usr/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/informix/bin
:/us
r/informix/bin
USER=informix
INFORMIXDIR=/usr/informix
INFORMIXSERVER=tin_ids
OSTYPE=Linux
It still won't dbimport however. Is this perhaps a Linux configuration
issue?
Thanks,
Craig
Murray Wood <mur...@quanta.co.nz> wrote in message
news:7k9ia1$jao$1...@news.xmission.com...
>
>
> Looks like INFORMIXSERVER environment variable is not set (tin_ids).
> Also check INFORMIXDIR, $INFORMIXDIR/bin in PATH and ONCONFIG are all set.
>
>
> Murray Wood
Murray Wood
David Kosenko
wrote:
>Our System info:
> Red Hat Linux V6.0
> Engine: 7.3.UC7-2
> /usr/informix/sqlhosts: tin_ids sesoctcp tin.bdsn.com ids1
> /etc/services: ids1 1537/tcp #Informix IDS
From other posts, it sounds like you solved your problem. However, I
did want to point out that your sqlhosts should be using a protocol of
"onsoctcp" not "sesoctcp" (which specifies an SE server).
Dave