Oninit cdi / Archive
Talk to an expert →

908: Attempt to connect to database server (hdbafd

Posted in 2014

Summary

A user couldn't connect with dbaccess from a Linux CSDK 4.10 client to an 11.50.FC9 server on AIX, getting "908: Attempt to connect to database server (hdbafdba_tcp) failed" with ISAM error "record is locked"; local dbaccess on the AIX box worked fine. Suggestions included checking for a firewall, duplicate /etc/hosts entries or a port clash on 15038, verifying no database was opened exclusively (only sysadmin showed locks), and telnetting the port then checking onstat -m for error 401. The client had no telnet/nmap available, and the thread ends with no resolution recorded.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Error Codes & Troubleshooting, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Networking & sqlhosts Configuration, Licensing & Editions, Platform-Specific Issues, Java & JDBC Development, Versions, Editions & End-of-Life

GILLES — — source: IIUG Forums & Mailing Lists

Hi, When trying dbaccess connexion from a Informix CSDK 410FC4DE running on RED HAT 2.6.32-358.6.2.el6.x86_64 to IBM Informix Dynamic Server Version 11.50.FC9 running on AIX 5.3.0.0, I have the following message : informix@PBDDLX03: # dbaccess sysmaster << EOF (suite)> select name from sysdatabases; (suite)> EOF 908: Attempt to connect to database server (hdbafdba_tcp) failed. ISAM error: record is locked. The client env parameters are : informix@PBDDLX03: # env | grep informix ADMIN=/bases/informix/hdbafdba/admin BASE=/bases/informix/hdbafdba HOME=/produits/informix INFORMIXDIR=/produits/informix/client/sdk/410FC4DE INFORMIXSQLHOSTS=/produits/informix/client/sdk/410FC4DE/etc/sqlhosts.hdbafdba LD_LIBRARY_PATH=/produits/informix/client/sdk/410FC4DE/lib:/produits/informix/client/sdk/410FC4DE/lib/cli: /produits/informix/client/sdk/410FC4DE/lib/esql LOGNAME=informix MAIL=/var/spool/mail/informix PATH=/usr/local/bin:/bin:/usr/bin:/opt/VRTS/bin:/produits/informix/client/sdk/410FC4DE/bin:/usr/java5/bin: /produits/informix/client/sdk/410FC4DE/bin:/usr/java5/bin PWD=/produits/informix USER=informix onc=/produits/informix/client/sdk/410FC4DE/etc/onconfig.hdbafdba informix@PBDDLX03: # informix@PBDDLX03: # informix@PBDDLX03: # echo $INFORMIXSERVER hdbafdba_tcp The client sqlhosts contains : #*********************************************************************** *** # # Licensed Material - Property Of IBM # # "Restricted Materials of IBM" # # IBM Informix Dynamic Server # (c) Copyright IBM Corporation 1996, 2004 All rights reserved. # # Title: sqlhosts.demo # Description: # Default sqlhosts file for running demos. # #*********************************************************************** *** hdbafdba onipcshm hmba04 hdbafdba_net1 #hdbafdba_tcp onsoctcp hmba04 hdbafdba_net1 hdbafdba_tcp onsoctcp hmba04 15038 hdbafdbasrv_tcp onsoctcp hmba04 hdbaisrv_net1 where hmba04 is the AIX server box ans 15038 is the pport declared in AIX box as you can see below : informix@hmba04:hdbafdba_tcp:/produits/informix/115FC9/etc> cat /etc/services | grep hdbafdba_net1 hdbafdba_net1 15038/tcp In the dataserver size the sqlhosts file contains : #*********************************************************************** *** # # Licensed Material - Property Of IBM # # "Restricted Materials of IBM" # # IBM Informix Dynamic Server # (c) Copyright IBM Corporation 1996, 2004 All rights reserved. # # Title: sqlhosts.demo # Description: # Default sqlhosts file for running demos. # #*********************************************************************** *** hdbafdba onipcshm hmba04 hdbafdba_net1 hdbafdba_tcp onsoctcp hmba04 hdbafdba_net1 hdbafdbasrv_tcp onsoctcp hmba04 hdbaisrv_net1 and the user 'informix' on hmba04 (the uix server) has access to the databse hdbafda via dbaccess (see below) informix@hmba04:hdbafdba_tcp:/produits/informix/115FC9/etc> dbaccess sysmaster << EOF > select count(*) from sysdatabases;> EOF Database selected. (count(*)) 9 1 row(s) retrieved. Database closed. Knowing hmba04(server box) is network reachable by client host (see below) : informix@PBDDLX03: # ping hmba04 PING hmba04.dns24-1.socgen (192.85.62.2) 56(84) bytes of data. 64 bytes from hmba04.dns24.socgen (192.85.62.2): icmp_seq=1 ttl=250 time=8.86 ms .... Can someone tells me why I have this : 908: Attempt to connect to database server (hdbafdba_tcp) failed. ISAM error: record is locked Regards

↪ replying to GILLES
Khaled — — source: IIUG Forums & Mailing Lists

HI Gilles, Do you have a firewall problem ? Did you check if /etc/hosts for duplicates? Is the port15038 used for something else ? Do you get the error right away or do you have to wait before you get the error ? Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board of Directors Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 15/12/14 14:41, GILLES TCHAPPI a écrit : > Hi, > > When trying dbaccess connexion from a Informix CSDK 410FC4DE > running on RED HAT 2.6.32-358.6.2.el6.x86_64 to IBM Informix Dynamic > Server Version 11.50.FC9 running on AIX 5.3.0.0, I have the following > message : > > informix@PBDDLX03: # dbaccess sysmaster<< EOF > (suite)> select name from sysdatabases; > (suite)> EOF > > 908: Attempt to connect to database server (hdbafdba_tcp) failed.> > ISAM error: record is locked.> > The client env parameters are : > > informix@PBDDLX03: # env | grep informix > ADMIN=/bases/informix/hdbafdba/admin > BASE=/bases/informix/hdbafdba > HOME=/produits/informix > INFORMIXDIR=/produits/informix/client/sdk/410FC4DE > INFORMIXSQLHOSTS=/produits/informix/client/sdk/410FC4DE/etc/sqlhosts.> hdbafdba > LD_LIBRARY_PATH=/produits/informix/client/sdk/410FC4DE/lib:> /produits/informix/client/sdk/410FC4DE/lib/cli: > /produits/informix/client/sdk/410FC4DE/lib/esql > LOGNAME=informix > MAIL=/var/spool/mail/informix > PATH=/usr/local/bin:/bin:/usr/bin:/opt/VRTS/bin:> /produits/informix/client/sdk/410FC4DE/bin:/usr/java5/bin: > /produits/informix/client/sdk/410FC4DE/bin:/usr/java5/bin > PWD=/produits/informix > USER=informix > onc=/produits/informix/client/sdk/410FC4DE/etc/onconfig.hdbafdba > informix@PBDDLX03: # > informix@PBDDLX03: # > informix@PBDDLX03: # echo $INFORMIXSERVER > hdbafdba_tcp > > The client sqlhosts contains : > > #*********************************************************************** > *** > # > # Licensed Material - Property Of IBM > # > # "Restricted Materials of IBM" > # > # IBM Informix Dynamic Server > # (c) Copyright IBM Corporation 1996, 2004 All rights reserved. > # > # Title: sqlhosts.demo > # Description: > # Default sqlhosts file for running demos. > # > #*********************************************************************** > *** > hdbafdba onipcshm hmba04 hdbafdba_net1 > #hdbafdba_tcp onsoctcp hmba04 hdbafdba_net1 > hdbafdba_tcp onsoctcp hmba04 15038 > hdbafdbasrv_tcp onsoctcp hmba04 hdbaisrv_net1> > where hmba04 is the AIX server box ans 15038 is the pport declared in > AIX box as you can see below : > > informix@hmba04:hdbafdba_tcp:/produits/informix/115FC9/etc> cat > /etc/services | grep hdbafdba_net1 > hdbafdba_net1 15038/tcp > > In the dataserver size the sqlhosts file contains : > > #*********************************************************************** > *** > # > # Licensed Material - Property Of IBM > # > # "Restricted Materials of IBM" > # > # IBM Informix Dynamic Server > # (c) Copyright IBM Corporation 1996, 2004 All rights reserved. > # > # Title: sqlhosts.demo > # Description: > # Default sqlhosts file for running demos. > # > #*********************************************************************** > *** > hdbafdba onipcshm hmba04 hdbafdba_net1 > hdbafdba_tcp onsoctcp hmba04 hdbafdba_net1 > hdbafdbasrv_tcp onsoctcp hmba04 hdbaisrv_net1> > and the user 'informix' on hmba04 (the uix server) has access to the > databse hdbafda via dbaccess (see below) > > informix@hmba04:hdbafdba_tcp:/produits/informix/115FC9/etc> dbaccess > sysmaster<< EOF >> select count(*) from sysdatabases;>> EOF > Database selected. > > (count(*)) > > 9 > > 1 row(s) retrieved. > > Database closed. > > Knowing hmba04(server box) is network reachable by client host (see > below) : > > informix@PBDDLX03: # ping hmba04 > PING hmba04.dns24-1.socgen (192.85.62.2) 56(84) bytes of data. > 64 bytes from hmba04.dns24.socgen (192.85.62.2): icmp_seq=1 ttl=250 > time=8.86 ms > ..... > > Can someone tells me why I have this : > 908: Attempt to connect to database server (hdbafdba_tcp) failed.> > ISAM error: record is locked> > Regards > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to Khaled
GILLES — — source: IIUG Forums & Mailing Lists

Hi How are U ? Thanks for u're anwser. Here are the information you asked for : Q - Do you have a firewall problem ? A - I don't think there are firewalls problems, I'll check Q - Did you check if /etc/hosts for duplicates? A - Yes (see below) : x087823@PBDDLX03: # cat /etc/hosts | grep hmba04 Q - Is the port15038 used for something else ? A - No (see below) : x087823@PBDDLX03: #cat /etc/hosts | grep hmba04 Q - Do you get the error right away or do you have to wait before you get the error ? A - I have to wait before I get the error Regards

↪ replying to GILLES
Art Kagel — — source: IIUG Forums & Mailing Lists

Giles: The ISAM error indicates a lock out error as if someone else opened sysmaster IN EXCLUSIVE MODE. Does the probme persist at the same time that you can connect from the host locally? Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Dec 15, 2014 at 11:24 AM, GILLES TCHAPPI <giltfr@yahoo.fr> wrote: > Hi > > How are U ? > > Thanks for u're anwser. Here are the information you asked for : > > Q - Do you have a firewall problem ? > > A - I don't think there are firewalls problems, I'll check > > Q - Did you check if /etc/hosts for duplicates? > > A - Yes (see below) : > x087823@PBDDLX03: # cat /etc/hosts | grep hmba04 > > Q - Is the port15038 used for something else ? > > A - No (see below) : > x087823@PBDDLX03: #cat /etc/hosts | grep hmba04 > > Q - Do you get the error right away or do you have to > > wait before you get the error ? > > A - I have to wait before I get the error > > Regards > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c32cf489f744050a43c5d9

↪ replying to GILLES
Paul Watson — — source: IIUG Forums & Mailing Lists

Trying telnet'ing the port telnet IP <port> Connection refused: firewall or port is wrong If you get a connection hit return and it will close, then run onstat -m on the server, you will see error 401 - if you don't then you are not connecting to the engine you think you are Cheers Paul > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > GILLES TCHAPPI > Sent: Monday, December 15, 2014 10:25 AM > To: ids@iiug.org > Subject: Re: 908: Attempt to connect to database server (hd [34350] > > Hi > > How are U ? > > Thanks for u're anwser. Here are the information you asked for : > > Q - Do you have a firewall problem ? > > A - I don't think there are firewalls problems, I'll check > > Q - Did you check if /etc/hosts for duplicates? > > A - Yes (see below) : > x087823@PBDDLX03: # cat /etc/hosts | grep hmba04 > > Q - Is the port15038 used for something else ? > > A - No (see below) : > x087823@PBDDLX03: #cat /etc/hosts | grep hmba04 > > Q - Do you get the error right away or do you have to > > wait before you get the error ? > > A - I have to wait before I get the error > > Regards > > > ********************************************************** > ********************* > Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Art Kagel
GILLES — — source: IIUG Forums & Mailing Lists

Hi, The only database locked on this dataserver is 'sysadmin' database as u can see below : informix@hmba04:hdbafdba_tcp:/home/informix> onstat -k IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line -- Up 01:05:29 --1040368 Kbytes Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 7000000013ed4c0 0 70000004210d9b0 0 S 100002 204 0 70000000c4edcc0 0 70000004210e1e8 0 HDR+S 100002 204 0 70000000c4edd40 0 70000004210d178 0 S 100002 204 0 3 active, 2900000 total, 262144 hash buckets, 0 lock table overflows informix@hmba04:hdbafdba_tcp:/home/informix> dbaccess sysmaster << EOF^Jselect name from sysdatabases where hex(rowid) like '%204%';^JEOF Database selected. name sysadmin 1 row(s) retrieved. Database closed. Regards

↪ replying to Paul Watson
GILLES — — source: IIUG Forums & Mailing Lists

Hi, Unfortunately telnet command is not allowed on the client side, probably for security reasons. Is there another way to test if there are firewall problems ? Regards

↪ replying to GILLES
Paul Watson — — source: IIUG Forums & Mailing Lists

You could use nmap but if telnet is not allowed then I am sure nmap won't be It doesn't have to be telnet - any termulator will do, putty, securecrt etc Cheers Paul > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > GILLES TCHAPPI > Sent: Monday, December 15, 2014 11:05 AM > To: ids@iiug.org > Subject: Re: RE: 908: Attempt to connect to database server [34354] > > Hi, > > Unfortunately telnet command is not allowed on the client side, probably for > security reasons. > > Is there another way to test if there are firewall problems ? > > Regards > > > ********************************************************** > ********************* > Forum Note: Use "Reply" to post a response in the discussion forum.

Related threads

Glossary