sqlhosts setup enterprise replicatiion window - un
Posted in 2012
Karl Oliver could connect to an ER server group from UNIX but not on Windows 2008 with IDS 11.50, and wondered about sqlhosts ordering. Art Kagel pointed to an IBM document on creating connection groups under Windows. Karl found he had missed an sqlhosts entry in the Windows registry; replication then worked between Windows and UNIX. Solved.
Topics: High Availability & Replication, Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues, Versions, Editions & End-of-Life
IBM Informix Dynamic Server Version 11.50.FC9DE Software Serial Number
AAA#B000000
windows V 6.1 Build 7601 service pack1
IBM Informix Dynamic Server Version 11.50.FC6
HP-UX wuasp132 B.11.23 U 9000/800
sqlhosts setup enterprise replication window - UNIX
Does anyone know if you have to have the server group set up before the server
information in the sqlhosts file ?
I can communicate from UNIX to Windows ok when I define the server group on
windows and Unix. when choosing the server group in the connection in dbaccess
on UNIX.
However on windows server I cant even connect to the windows server using the
server group connection in dbaccess. The fact that I can connect to the server
group from UNIX must mean definition is right.
So All I can think of is the order of information in the sqlhosts
See this document:
http://www-01.ibm.com/support/docview.wss?uid=swg21447622
The title refers to the Connection Manager, but anytime you have to use
connection groups under windows (whether as a client or server, you have to
follow the procedure detailed there to create the groups.
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 Sun, Sep 9, 2012 at 6:06 PM, KARL OLIVER <karl.oliver@maf.govt.nz> wrote:
> IBM Informix Dynamic Server Version 11.50.FC9DE Software Serial Number
> AAA#B000000
> windows V 6.1 Build 7601 service pack1
>
> IBM Informix Dynamic Server Version 11.50.FC6
> HP-UX wuasp132 B.11.23 U 9000/800
>
> sqlhosts setup enterprise replication window - UNIX
>
> Does anyone know if you have to have the server group set up before the
> server
> information in the sqlhosts file ?
> I can communicate from UNIX to Windows ok when I define the server group on
> windows and Unix. when choosing the server group in the connection in
> dbaccess
> on UNIX.> However on windows server I cant even connect to the windows server using
> the
> server group connection in dbaccess. The fact that I can connect to the
> server
> group from UNIX must mean definition is right.
> So All I can think of is the order of information in the sqlhosts
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae93404af51e63404c94d2bff
thanks for that Art I had missed out an entry in sqlhosts in registry. Replication now working between windows and UNix servers. Now managemnet tell me to try Informix on Linux !
8^o Linux hint: EXT2 filesystem for chunks 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 Tue, Sep 11, 2012 at 3:51 PM, KARL OLIVER <karl.oliver@maf.govt.nz>wrote: > thanks for that Art > I had missed out an entry in sqlhosts in registry. > Replication now working between windows and UNix servers. > Now managemnet tell me to try Informix on Linux ! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f3bac1d56009b04c973596b