Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: Remote database connection failed

Posted By: medkba
Date: Wednesday, 9 October 2013, at 11:26 a.m.

In Response To: Re: Remote database connection failed (Paul Watson)

Yes, I have added already

Informix Server
> informix@pmhx001$ more hosts.equiv
> NHX003 +
> WHX003-NEW +
> whxd003madcs-new +

On Wed, Oct 9, 2013 at 11:11 PM, Paul Watson <paul@oninit.com> wrote:

> Add
>
> whxd003madcs-new.sing.micron.com
>
> to the hosts.equiv file
>
> Cheers
> Paul
>
> > Dear All,
> >
> > Error:
> > 18:54:06 listener-thread: err = -956: oserr = 0: errstr =
> > cm172895@whxd003madcs-new.sing.micron.com[whx003n]: Client host or user
> > cm172895@whxd003madcs-new[whx003n] is not trusted by the server.
> >
> > Informix Client
> > root@whx003n# more hosts.equiv
> > whd003
> > whd003.amk.st.com
> > MHX003
> > MHD003
> > MHXD002
> > PMHX001
> >
> > Informix Server
> > informix@pmhx001$ more hosts.equiv
> > NHX003 +
> > WHX003-NEW +
> > whxd003madcs-new +
> >
> > informix@pmhx001$ more .rhosts
> > #testing
> > whx003-new informix
> > whd003-new informix
> > whxd003-new informix
> > whxd003ifx-new informix
> > whxd003app-new informix
> > whxd003madcs-new informix
> > whxd003tpm-new informix
> > whxd003qt-new informix
> >
> > On Wed, Oct 9, 2013 at 10:54 PM, Art Kagel <art.kagel@gmail.com> wrote:
> >
> >> You need to add the client to the hosts.equiv on the server!
> >>
> >> Art
> >>
> >> Art S. Kagel, Principal Consultant
> >>
> >> 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, Oct 9, 2013 at 9:18 AM, medkba <medkba@gmail.com> wrote:
> >>
> >> > Yes, I have added earlier but still this error occurs. This is
> >> (MHX001)
> >> > informix server host name.
> >> >
> >> > whx003n - This is the client server host name
> >> >
> >> > root@whx003n# more hosts.equiv
> >> > MHX001
> >> >
> >> > On Wed, Oct 9, 2013 at 9:11 PM, Alexandre Marini <alexandre@briug.org
> >> > >wrote:
> >> >
> >> > > Ok.
> >> > > The description of this error suggests that the client computer or
> >> client
> >> > > user
> >> > > is not trusted by the Informix server.
> >> > >
> >> > > Check if your /etc/hosts.equiv file has an entry for the Informix
> >> server,
> >> > > in
> >> > > you client machine. That should fix your issue.
> >> > >
> >> > > Hope it helps.
> >> > > Regards.
> >> > >
> >> > > Alexandre Marini
> >> > > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> >> > >
> >> > > IBM Information Management Informix Technical Professional
> >> > >
> >> > > IBM Infosphere DataStage Technical Professional
> >> > > Informix Senior DBA - Orizon Brasil
> >> > > BRIUG website administrator
> >> > > Informix independent consultant
> >> > >
> >> > > > To: ids@iiug.org
> >> > > > From: medkba@gmail.com
> >> > > > Subject: Re: Remote database connection failed [31662]
> >> > > > Date: Wed, 9 Oct 2013 08:16:59 -0400
> >> > > >
> >> > > > Thank you Alexandre Marini
> >> > > >
> >> > > > I have managed to find the issue and fix it. But, I have another
> >> error.
> >> > > If
> >> > > > you could give me some clue may be able to fix this issue. version
> >> > > 11.50FC9
> >> > > >
> >> > > > 18:54:06 listener-thread: err = -956: oserr = 0: errstr =
> >> > > > cm172895@whxd003madcs-new.sing.micron.com[whx003n]: Client host
> or
> >> > user
> >> > > > cm172895@whxd003madcs-new.
> >> > > >
> >> > > > On Wed, Oct 9, 2013 at 6:46 PM, Alexandre Marini <
> >> alexandre@briug.org
> >> > > >wrote:
> >> > > >
> >> > > > > Hello.
> >> > > > > Could you specify your Informix version, and architecture?
> >> > > > >
> >> > > > > 1) What specific changes have you made in your sqlhosts file?
> >> > > > > 2) If you rollback your changes, does it works fine?
> >> > > > > Please post your changes, in old/new format of sqlhosts file, so
> >> that
> >> > > we
> >> > > > > could
> >> > > > > try to help.
> >> > > > >
> >> > > > > Regards.
> >> > > > >
> >> > > > > Alexandre Marini
> >> > > > > IBM Informix Certified Professional v10 / v11.50 / v11.70 /
> >> v12.10
> >> > > > >
> >> > > > > IBM Information Management Informix Technical Professional
> >> > > > >
> >> > > > > IBM Infosphere DataStage Technical Professional
> >> > > > > Informix Senior DBA - Orizon Brasil
> >> > > > > BRIUG website administrator
> >> > > > > Informix independent consultant
> >> > > > >
> >> > > > > > To: ids@iiug.org
> >> > > > > > From: medkba@gmail.com
> >> > > > > > Subject: Remote database connection failed [31658]
> >> > > > > > Date: Wed, 9 Oct 2013 04:19:22 -0400
> >> > > > > >
> >> > > > > > Hi All,
> >> > > > > >
> >> > > > > > I have modified /etc/services and /etc/sqlhost file pointing
> >> to
> >> the
> >> > > > > > instance and try to access through application but gives error
> >> to
> >> > > > > connect.
> >> > > > > > Any suggestion or advise on this
> >> > > > > >
> >> > > > > > cat
> >> /users/wksogrp/cm172895/cmt001_err_17150_cm172895_whx003n.log
> >> > > > > > The following diagnostic information has been written by Image
> >> > cmt001
> >> > > > > > under Unix Username cm172895, Host whx003n, Process ID 17150
> >> > > > > > at Wed Oct 9 15:00:13 SST 2013.
> >> > > > > >
> >> > > > > > CMT005 FATAL ERROR: MSG CODE = CMT001
> >> > > > > > THE CURRENT FACILITY NAME IS
> >> > > > > > THE CURRENT USER NAME IS
> >> > > > > > THE CURRENT FUNCTION NAME IS
> >> > > > > > THE CURRENT FORM NAME IS
> >> > > > > > PROGRAM TERMINATED DUE TO DATABASE ERROR
> >> > > > > > ******************************
> >> > > > > > * LAST TXN RELATED SQL STATEMENTS *
> >> > > > > > ******************************
> >> > > > > > SUBROUTINE = CMT001
> >> > > > > > PARAGRAPH = B001-2
> >> > > > > > TXN TYPE PRIOR TO EXECUTION OF SQL... NA
> >> > > > > > CONNECT TO :DB-NAME AS 'LOCAL' WITH CONC TRANS
> >> > > > > > CMT001-TXN-REQUEST-STATUS............ 0
> >> > > > > > CMT001-DB-STATUS..................... 97
> >> > > > > > SUBROUTINE =
> >> > > > > > PARAGRAPH =
> >> > > > > > TXN TYPE PRIOR TO EXECUTION OF SQL...
> >> > > > > >
> >> > > > > > CMT001-TXN-REQUEST-STATUS............ 0
> >> > > > > > CMT001-DB-STATUS..................... 0
> >> > > > > > SUBROUTINE =
> >> > > > > > PARAGRAPH =
> >> > > > > > TXN TYPE PRIOR TO EXECUTION OF SQL...
> >> > > > > >
> >> > > > > > CMT001-TXN-REQUEST-STATUS............ 0
> >> > > > > > CMT001-DB-STATUS..................... 0
> >> > > > > > SUBROUTINE =
> >> > > > > > PARAGRAPH =
> >> > > > > > TXN TYPE PRIOR TO EXECUTION OF SQL...
> >> > > > > >
> >> > > > > > CMT001-TXN-REQUEST-STATUS............ 0
> >> > > > > > CMT001-DB-STATUS..................... 0
> >> > > > > > SUBROUTINE =
> >> > > > > > PARAGRAPH =
> >> > > > > > TXN TYPE PRIOR TO EXECUTION OF SQL...
> >> > > > > >
> >> > > > > > CMT001-TXN-REQUEST-STATUS............ 0
> >> > > > > > CMT001-DB-STATUS..................... 0
> >> > > > > > ******************************
> >> > > > > > * DML CALL HISTORY FOLLOWS *
> >> > > > > > ******************************
> >> > > > > > SUBROUTINE = CMT001
> >> > > > > > PARAGRAPH = B001-2
> >> > > > > > CONNECT TO :DB-NAME AS 'LOCAL' WITH CONC TRANS
> >> > > > > > SUBROUTINE =
> >> > > > > > PARAGRAPH =
> >> > > > > >
> >> > > > > > SUBROUTINE =
> >> > > > > > PARAGRAPH =
> >> > > > > >
> >> > > > > > SUBROUTINE =
> >> > > > > > PARAGRAPH =
> >> > > > > >
> >> > > > > > SUBROUTINE =
> >> > > > > > PARAGRAPH =
> >> > > > > >
> >> > > > > > ERROR CODE = -908
> >> > > > > > SQLCODE: -908
> >> > > > > >
> >> > > > > > -908 Attempt to connect to database server (servername,
> >> > > > > > conerr=connection-error-number, oserr=system-error-number)
> >> failed.
> >> > > > > >
> >> > > > > > The program or application is trying to access another
> >> database
> >> > > server
> >> > > > > > but has failed. Note the server name in the current statement.
> >> Note
> >> > > > > > also the connection error number and/or system error number
> >> that
> >> is
> >> > > > > > shown in the message.
> >> > > > > >
> >> > > > > > The desired database server is unavailable, or the network is
> >> down
> >> > or
> >> > > > > > is congested. Ask your DBA and system administrator to verify
> >> that
> >> > > the
> >> > > > > > server and network are operational. If the network is
> >> congested,
> >> > use
> >> > > > > > the environment variables INFORMIXCONTIME and INFORMIXCONRETRY
> >> to
> >> > > tune
> >> > > > > > connection timing. See Chapter 4 in the Informix Guide to SQL:
> >> > > > > > Reference for information on setting these environment
> >> variables.
> >> > > > > >
> >> > > > > > This message appears in Version 6.0 and later.
> >> > > > > >
> >> > > > > > environment variables.
> >> > > > > >
> >> > > > > > This message appears starting with Version 6.0.
> >> > > > > >
> >> > > > > > -908 Attempt to connect to remote system failed.
> >> > > > > >
> >> > > > > > INFORMIX-STAR or INFORMIX-NET is trying to access another
> >> computer
> >> > > > > > system but has failed. Note the site name in the current
> >> statement.
> >> > > > > > Start your daemon with a log file, and check for
> >> operating-system
> >> > > > > > errors in the log file. If this action is inconclusive,
> >> contact
> >> > your
> >> > > > > > system administrator, and ask for a check that the network is
> >> > > > > > operational and that the particular site is active.
> >> > > > > >
> >> > > > > > This message appears in database servers prior to Version 6.0.
> >> > > > > >
> >> > > > > > cmt001 terminated at Wed Oct 9 15:01:45 SST 2013
> >> > > > > >
> >> > > > > > --001a11336460585e9704e84a8af0
> >> > > > > >
> >> > > > > >
> >> > > > > >
> >> > > > >
> >> > > > >
> >> > > >
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> > > > > > Forum Note: Use "Reply" to post a response in the discussion
> >> forum.
> >> > > > > >
> >> > > > >
> >> > > > >
> >> > > > >
> >> > > > >
> >> > > >
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> > > > > Forum Note: Use "Reply" to post a response in the discussion
> >> forum.
> >> > > > >
> >> > > > >
> >> > > >
> >> > > > --047d7b343cd23b47e204e84ddc0c
> >> > > >
> >> > > >
> >> > > >
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> > > > Forum Note: Use "Reply" to post a response in the discussion
> >> forum.
> >> > > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> >> > >
> >> > >
> >> >
> >> > --001a11c3db7415110604e84eb8fa
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >> >
> >> >
> >>
> >> --089e0158b8663bfdc304e8500d6e
> >>
> >>
> >>
> >>
> >
>
> *******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> >
> > --001a11c373e439a60804e8503631
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> --
> Paul Watson
> Tel: +1 913-674-0360
> Mob: +1 913-387-7529
> Web: www.oninit.com
>
> www.advancedatatools.com
>
> Failure is not as frightening as regret.
> If you want to improve, be content to be thought foolish and stupid.
> What this country needs are more unemployed politicians
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--089e0160bb043bfdc104e8508249

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.