cant access DBSERVERALIASES

Posted in 2013

Topics: High Availability & Replication, Error Codes & Troubleshooting, Server Administration, Networking & sqlhosts Configuration, Versions, Editions & End-of-Life

KARL OLIVER — Wed, 17 Apr 2013 23:50:49 — source: IIUG Forums & Mailing Lists

IBM Informix Dynamic Server Version 11.50.FC9 Linux wldbt633 2.6.32-358.2.1.el6.x86_64 #1 SMP Wed Feb 20 12:17:37 EST 2013 x86_64 x86_64 x86_64 GN U/Linux can anyone help please I have set up a DBSERVERALIASES but cant connect to it entry in $ONCONFIG DBSERVERALIASES dbt633_ecms_uat_rep in sqlhosts ec_ap_uat_wlg_l group - - i=7 dbt633_ecms_uat_rep onsoctcp wldbt633.maf.govt.nz 1531 g=ec_ap_uat_wlg_l #Linux I try to connect as a test with dbacess errors with My aim is to set up enterprise replication using the DBSERVERALIASES . is there any particular order entries have to be in sqlhosts file. e.g SERVERNAME before DBSERVERALIASES or vice versa 908: Attempt to connect to database server (dbt633_ecms_uat_rep) failed. ISAM error: record is locked. there is no file in INFORMIXTMP for the alias tried again without doing anything and it worked .why would this be ?

↪ replying to KARL OLIVER

Madison Pruet — Thu, 18 Apr 2013 00:08:43 — source: IIUG Forums & Mailing Lists

Check your net stats to see if the port is already in use. Also make = sure that the server is defined in /etc/hosts. You might need to check your= server to see if there was a problem when bringing up the server such t= hat the listener thread could not be established. Sent from my iPad On Apr 17, 2013, at 6:51 PM, "KARL OLIVER" <karl.oliver@maf.govt.nz> wr= ote: > IBM Informix Dynamic Server Version 11.50.FC9 > Linux wldbt633 2.6.32-358.2.1.el6.x86_64 #1 SMP Wed Feb 20 12:17:37 E= ST 2013 > x86_64 x86_64 x86_64 GN > U/Linux > > can anyone help please > > I have set up a DBSERVERALIASES > but cant connect to it > > entry in $ONCONFIG > DBSERVERALIASES dbt633_ecms_uat_rep > > in sqlhosts > ec_ap_uat_wlg_l group - - i=3D7 > dbt633_ecms_uat_rep onsoctcp wldbt633.maf.govt.nz 1531 g=3Dec_ap_uat_= wlg_l > #Linux > > I try to connect as a test with dbacess errors with > > My aim is to set up enterprise replication using the DBSERVERALIASES = . > > is there any particular order entries have to be in sqlhosts file. > > e.g SERVERNAME before DBSERVERALIASES or vice versa > > 908: Attempt to connect to database server (dbt633_ecms_uat_rep) fail= ed. > ISAM error: record is locked.> > there is no file in INFORMIXTMP for the alias > > tried again without doing anything and it worked .why would this be ?= > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >=

↪ replying to KARL OLIVER

Art Kagel — Thu, 18 Apr 2013 00:13:22 — source: IIUG Forums & Mailing Lists

What does the sqlhosts entry for the DBSERVERNAME entry look like? Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Wed, Apr 17, 2013 at 7:50 PM, KARL OLIVER <karl.oliver@maf.govt.nz>wrote: > IBM Informix Dynamic Server Version 11.50.FC9 > Linux wldbt633 2.6.32-358.2.1.el6.x86_64 #1 SMP Wed Feb 20 12:17:37 EST > 2013 > x86_64 x86_64 x86_64 GN > U/Linux > > can anyone help please > > I have set up a DBSERVERALIASES > but cant connect to it > > entry in $ONCONFIG > DBSERVERALIASES dbt633_ecms_uat_rep > > in sqlhosts > ec_ap_uat_wlg_l group - - i=7 > dbt633_ecms_uat_rep onsoctcp wldbt633.maf.govt.nz 1531 g=ec_ap_uat_wlg_l > #Linux > > I try to connect as a test with dbacess errors with > > My aim is to set up enterprise replication using the DBSERVERALIASES . > > is there any particular order entries have to be in sqlhosts file. > > e.g SERVERNAME before DBSERVERALIASES or vice versa > > 908: Attempt to connect to database server (dbt633_ecms_uat_rep) failed. > ISAM error: record is locked.> > there is no file in INFORMIXTMP for the alias > > tried again without doing anything and it worked .why would this be ? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c382cc9b25eb04da97777d

↪ replying to KARL OLIVER

KARL OLIVER — Thu, 18 Apr 2013 01:58:04 — source: IIUG Forums & Mailing Lists

entry as follows dbt633_ecms_uat onsoctcp wldbt633 1526 everthing seems ok now there have been some network errors

↪ replying to Madison Pruet

Paul Watson — Thu, 18 Apr 2013 12:54:31 — source: IIUG Forums & Mailing Lists

Also telnet <server> <port> then hit return, you should get a 408 error in the online.log if you get to the engine Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Madison Pruet Sent: Wednesday, April 17, 2013 7:09 PM To: ids@iiug.org Subject: Re: cant access DBSERVERALIASES [30098] Check your net stats to see if the port is already in use. Also make = sure that the server is defined in /etc/hosts. You might need to check your= server to see if there was a problem when bringing up the server such t= hat the listener thread could not be established. Sent from my iPad On Apr 17, 2013, at 6:51 PM, "KARL OLIVER" <karl.oliver@maf.govt.nz> wr= ote: > IBM Informix Dynamic Server Version 11.50.FC9 > Linux wldbt633 2.6.32-358.2.1.el6.x86_64 #1 SMP Wed Feb 20 12:17:37 E= ST 2013 > x86_64 x86_64 x86_64 GN > U/Linux > > can anyone help please > > I have set up a DBSERVERALIASES > but cant connect to it > > entry in $ONCONFIG > DBSERVERALIASES dbt633_ecms_uat_rep > > in sqlhosts > ec_ap_uat_wlg_l group - - i=3D7 > dbt633_ecms_uat_rep onsoctcp wldbt633.maf.govt.nz 1531 g=3Dec_ap_uat_= wlg_l > #Linux > > I try to connect as a test with dbacess errors with > > My aim is to set up enterprise replication using the DBSERVERALIASES = .. > > is there any particular order entries have to be in sqlhosts file. > > e.g SERVERNAME before DBSERVERALIASES or vice versa > > 908: Attempt to connect to database server (dbt633_ecms_uat_rep) fail= ed. > ISAM error: record is locked.> > there is no file in INFORMIXTMP for the alias > > tried again without doing anything and it worked .why would this be ?= > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >= **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

cant access DBSERVERALIASES

Glossary

Your privacy choices