INFORMIX-SE 7.X on Linux
Posted in 2000
Topics: Installation, Setup & Upgrades, Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues
He !
I have problem to connect to informix server SE (I use dbaccess to do
this).
I got error number 908 and ISAM: Record is lock.
My configuration:
Linux Red Hat 6.1
INFORMIXSERVER=demo_sein etc/sqlhosts demo_se sesoctcp se_demo sqlexec
in /etc/hosts -> 127.0.0.1 se_demo
in /etc/services -> sqlexec 1543/tcp
I don't installed netcard (I don't want it). What should I do to connect
to Informix server ? What's wrong ?
Thank's for any help.
Jacek
Hallo,
Make no entries in /etc/services! 'sqlexec' needs
no network to communicate with a database.
Try the following entries:
- $INFORMIXDIR/etc/sqlhosts:
demo_se seipcpip se_demo sqlexec
- /etc/hosts:
127.0.0.1 se_demo
Environment:
export INFORMIXDIR=informix-install-path
export INFORMIXSERVER=demo_se
export PATH=$PATH:$INFORMIXDIR/bin
If you wish to use 'network' with your configuration, try the
following entries:
- $INFORMIXDIR/etc/sqlhosts:
demo_se sesoctcp se_demo sqlexecd
- /etc/hosts:
127.0.0.1 se_demo
- /etc/services:
sqlexecd 1543/tcp
As user root with the appropriate environment:
export INFORMIXDIR=informix-install-path
export INFORMIXSERVER=demo_se
export PATH=$PATH:$INFORMIXDIR/bin
you have to start the sqlexecd:
$INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER -l /tmp/sqlexecd.log
If the demon runs ok -you can see it in the logfile
(/tmp/sqlexecd.log)-,
you can run dbaccess to create an modify a database.
regards
JB wrote:
>
> He !
>
> I have problem to connect to informix server SE (I use dbaccess to do
> this).
> I got error number 908 and ISAM: Record is lock.
>
> My configuration:
> Linux Red Hat 6.1
>
> INFORMIXSERVER=demo_se> in etc/sqlhosts demo_se sesoctcp se_demo sqlexec
> in /etc/hosts -> 127.0.0.1 se_demo
> in /etc/services -> sqlexec 1543/tcp
>
> I don't installed netcard (I don't want it). What should I do to connect
> to Informix server ? What's wrong ?
>
> Thank's for any help.
> Jacek