Hi to all.
I need help with this problem...

I need help to access a database server from other server. Both servers have Linux Red Hat 7.3, ncurses for library compatibility and the IDS 7.31 RPM. The Database can be accessed by local console, but not from other server.

I think that all the configuration is ready, but when I want to connect from other machine, the dbaccess crash and send the next message later of 20 seconds:

908: Attemp to connect to database server (albatros) failed.
ISAM error: record is locked

This is the configuration...

Enviroment variables on the dolphin server

PWD=/opt/informix/etc
HOSTNAME=dolphin.cycsa.com.mx
LD_LIBRARY_PATH=/opt/informix/lib/tools
QTDIR=/usr/lib/qt3-gcc2.96
LESSOPEN=|/usr/bin/lesspipe.sh %s
USER=informix
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36i=40;33:s o=01;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi= 01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com =01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01 ;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;3 1:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz =01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01; 31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;3 5:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
MAIL=/var/spool/mail/root
INPUTRC=/etc/inputrc
BASH_ENV=/root/.bashrc
LANG=en_US.iso885915
INFORMIXDIR=/opt/informix
SSH_CLIENT=10.174.65.230 4440 22
INFORMIXSERVER=dolphin
LOGNAME=informix
SHLVL=2
ONCONFIG=onconfig
SHELL=/bin/bash
USERNAME=root
HISTSIZE=1000
HOME=/home/informix
TERM=xterm
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/opt/informix/bin:/root/bin
SSH_TTY=/dev/pts/1
DBDATE=DMY4
_=/usr/bin/env


Enviroment variables on the albatros server

PWD=/opt/informix/etc
HOSTNAME=albatros.cycsa.com.mx
LD_LIBRARY_PATH=/opt/informix/lib/tools
QTDIR=/usr/lib/qt3-gcc2.96
LESSOPEN=|/usr/bin/lesspipe.sh %s
USER=informix
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36i=40;33:s o=01;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi= 01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com =01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01 ;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;3 1:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz =01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01; 31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;3 5:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
MAIL=/var/spool/mail/root
INPUTRC=/etc/inputrc
BASH_ENV=/root/.bashrc
LANG=en_US.iso885915
INFORMIXDIR=/opt/informix
SSH_CLIENT=10.174.65.230 4469 22
INFORMIXSERVER=albatros
LOGNAME=informix
SHLVL=2
ONCONFIG=onconfig
SHELL=/bin/bash
USERNAME=root
HISTSIZE=1000
HOME=/opt/informix
TERM=xterm
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/opt/informix/bin:/root/bin
SSH_TTY=/dev/pts/0
DBDATE=DMY4
_=/usr/bin/env


The sqlhost file on the dolphin server

demo_on onipcshm on_hostname on_servername
demo_se seipcpip se_hostname sqlexec
dolphin onipcshm dolphin dolphintcp
shmdolphin onsoctcp dolphin sqlexec
dolphin ontlitcp dolphin dolphintcp
albatros ontlitcp albatros dolphintcp
seawolf ontlitcp seawolf dolphintcp
blackhawk ontlitcp blackhawk dolphintcp


The sqlhost file on the albatros server

demo_on onipcshm on_hostname on_servername
demo_se seipcpip se_hostname sqlexec
albatros onipcshm albatros albatrostcp
shmalbatros onsoctcp albatros sqlexec
dolphin ontlitcp dolphin albatrostcp
albatros ontlitcp albatros albatrostcp
seawolf ontlitcp seawolf albatrostcp
blackhawk ontlitcp blackhawk albatrostcp


The file onconfig on dophin server

# System Configuration

SERVERNUM 9 # Unique id corresponding to a Dynamic Server instance
DBSERVERNAME dolphin # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE ipcshm,1,20,CPU # Configure poll thread(s) for nettype
NETTYPE soctcp,1,20,NET # Configure poll thread(s) for nettype
NETTYPE tlitcp,1,20,NET # Configure poll thread(s) for nettype


The file onconfig on albatros server

# System Configuration

SERVERNUM 9 # Unique id corresponding to a Dynamic Server instance
DBSERVERNAME albatros # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE ipcshm,1,20,CPU # Configure poll thread(s) for nettype
NETTYPE soctcp,1,20,NET # Configure poll thread(s) for nettype
NETTYPE tlitcp,1,20,NET # Configure poll thread(s) for nettype


The file services on albatros server

sqlexec 1524/tcp
albatrostcp 1523/tcp

The file services on dolphin server

sqlexec 1524/tcp
dolphintcp 1523/tcp


Anyone can help me?
Regards

HI,

I think that you would to review sqlhosts file, since the name of the
service must be unique for all the instances.
The parameter DBSERVERALIAS must be defined. By this the connection is made.
Por example "albatros ontlitcp albatros albatrostcp"
DBSERVERALIAS=albatros and the service file, albatrostcp nnnn/tcp
And both servers must see themselves.
For example: Server1 rsh "server2 ls -l", if this run ok, then continue.

Gustavo.