IWA to connect to Informix on Solarix x86
Nitin wanted to use the Informix Warehouse Accelerator (IWA) with production servers on Solaris x86_64, and had tried installing IWA plus IDS 11.70 on CentOS, accessing the Solaris data via synonyms; he blamed the onsoctcp/ontlitcp difference. Responders explained TLI vs sockets was a red herring, that IWA (Linux-only) can connect directly to the source instance and doesn't need an intermediate IDS, that IWA can't pull data through synonyms, and that Solaris x86 as a source is only supported from 11.70.FC5 (on both IDS and IWA). Nitin, on FC4, planned to upgrade to FC5.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, All of our Production servers are on Solaris x86_64 and I was looking to use IWA, so please let me know if thats possible? Is there a work around? I have installed IWA on Centos and also installed IDS 11.70 on Centos (VM) and created a Accelerator. But when I try to access my production servers from IDS on centos (I wanted to create synonyms of big tables of my prod env), it is failing probably due to different NETTYPE, linux uses onsoctcp while Solaris is using ontlitcp. regards, Nitin
I trust you understand the Warehouse Accelerator binary is completely = separate from the base Informix 11.7 binary, correct? You don't need to = have the source instance or the binary on the same machine or O/S as the = accelerator binary. You can have your source Informix 11.7 instance on 64 bit Solaris and = use the accelerator on a Linux host starting with the FC5 release of the = accelerator. Solaris is not supported as a source instance on the FC4 or = earlier releases. I would encourage you to read through the manual for the accelerator. In = doing so, you'll realize that there are no "regular" SQLHOSTS entries = you need to configure. The linkage between the source instance and an = accelerator uses a proprietary protocol that is generated when you = execute the ondwa getpin command then use the output to create an = accelerator. You can use the graphical tool or Java method to create the = accelerator. As part of this process, the proper SQLHOSTS entries will = be created and the accelerator will be linked to the source instance. If you are in North America, I would also encourage you to come to the = Summer Informix Roadshow. The first day of the roadshow is dedicated to = the warehouse accelerator with instruction and hands-on labs. For more = information: = https://www.ibm.com/developerworks/mydeveloperworks/wikis/home?lang=3Den#/= wiki/North%20America%20Informix%20Events Carlton ------------------------------------------------- Carlton Doe Flower Mound, TX No trees were killed in the transmission of this email, however a large = number of electrons were temporarily inconvenienced.=20 On Jul 20, 2012, at 3:52 PM, NITIN MATHUR wrote: > Hi,=20 >=20 > All of our Production servers are on Solaris x86_64 and I was looking = to use=20 > IWA, so please let me know if thats possible? Is there a work around? = I have=20 > installed IWA on Centos and also installed IDS 11.70 on Centos (VM) = and=20 > created a Accelerator. But when I try to access my production servers = from IDS=20 > on centos (I wanted to create synonyms of big tables of my prod env), = it is=20 > failing probably due to different NETTYPE, linux uses onsoctcp while = Solaris=20 > is using ontlitcp.=20 >=20 > regards,=20 >=20 > Nitin=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20 --Apple-Mail-1--560831758 Content-Transfer-Encoding: quoted-printable
TLI -vs- Sockets is not the problem, the underlying network protocols are identical, only the library interface that is used in the source code is different. That said, I don't know about Solaris for x86, but Solaris for Sparc can use either TLI or Sockets (Solaris is only platform that can) and performance is nearly identical. Check the release notes if you feel a need to test whether this is really a red herring. Note that if IWA is running on Linux it CAN access your production database on Solaris directly (IWA ONLY runs on Linux) you do not need a copy of IDS running on Linux to interface to IWA. 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 Fri, Jul 20, 2012 at 4:52 PM, NITIN MATHUR <nitin_maths@rediffmail.com>wrote: > Hi, > > All of our Production servers are on Solaris x86_64 and I was looking to > use > IWA, so please let me know if thats possible? Is there a work around? I > have > installed IWA on Centos and also installed IDS 11.70 on Centos (VM) and > created a Accelerator. But when I try to access my production servers from > IDS > on centos (I wanted to create synonyms of big tables of my prod env), it is > failing probably due to different NETTYPE, linux uses onsoctcp while > Solaris > is using ontlitcp. > > regards, > > Nitin > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae9340a990ea2a304c5495217
Not sure if I understand the problem... IWA can work with IDS on Solaris x64 only on 11.70.FC5. Regards On Fri, Jul 20, 2012 at 9:52 PM, NITIN MATHUR <nitin_maths@rediffmail.com>wrote: > Hi, > > All of our Production servers are on Solaris x86_64 and I was looking to > use > IWA, so please let me know if thats possible? Is there a work around? I > have > installed IWA on Centos and also installed IDS 11.70 on Centos (VM) and > created a Accelerator. But when I try to access my production servers from > IDS > on centos (I wanted to create synonyms of big tables of my prod env), it is > failing probably due to different NETTYPE, linux uses onsoctcp while > Solaris > is using ontlitcp. > > regards, > > Nitin > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --00248c70fddd9fe43904c54a3793
That is correct. Solaris Sparc was supported from day one but Solaris = x86 was only supported from the FC5 release which came out a couple of = weeks ago. Carlton ------------------------------------------------- Carlton Doe Flower Mound, TX No trees were killed in the transmission of this email, however a large = number of electrons were temporarily inconvenienced.=20 On Jul 20, 2012, at 5:14 PM, Fernando Nunes wrote: > Not sure if I understand the problem...=20 > IWA can work with IDS on Solaris x64 only on 11.70.FC5.=20 >=20 > Regards=20 >=20 > On Fri, Jul 20, 2012 at 9:52 PM, NITIN MATHUR=20 > <nitin_maths@rediffmail.com>wrote:=20 >=20 >> Hi,=20 >>=20 >> All of our Production servers are on Solaris x86_64 and I was looking = to=20 >> use=20 >> IWA, so please let me know if thats possible? Is there a work around? = I=20 >> have=20 >> installed IWA on Centos and also installed IDS 11.70 on Centos (VM) = and=20 >> created a Accelerator. But when I try to access my production servers = from=20 >> IDS=20 >> on centos (I wanted to create synonyms of big tables of my prod env), = it is=20 >> failing probably due to different NETTYPE, linux uses onsoctcp while=20= >> Solaris=20 >> is using ontlitcp.=20 >>=20 >> regards,=20 >>=20 >> Nitin=20 >>=20 >>=20 >>=20 >>=20 > = **************************************************************************= *****=20 >> Forum Note: Use "Reply" to post a response in the discussion forum.=20= >>=20 >>=20 >=20 > --=20 > Fernando Nunes=20 > Portugal=20 >=20 > http://informix-technology.blogspot.com=20 > My email works... but I don't check it frequently...=20 >=20 > --00248c70fddd9fe43904c54a3793=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20 --Apple-Mail-2--507060727 Content-Transfer-Encoding: quoted-printable
Ahh, so thats the problem. We are using IDS Version 11.70.FC4 on Solaris x86, probably we should upgrade to FC5 if we want to use IWA. Thanks for your responses. regards, Nitin
Thanks Art and Carlton for the replies. Frankly, this was the first time I was trying to use IWA (had lot of trouble installing and briging up) as I had not given much time to read about it and was depending heavily on a presntation on IWA setup by Scott Pickett (spickett@us.ibm.com). I will definitely give a try to attend this conference as I am a fan of Informix tech since last 12-13 years and now my organisation is looking to a product for WAREHOUSE and I have been trying to convince them for IWA instead of VERTICA (HP product)! Any help on this matter will be appreciated. regards, Nitin
On both sides. The base instance and IWA Carlton Doe cdoe@us.ibm.com Sent from my iPhone, typos and all On Jul 21, 2012, at 11:35 AM, "NITIN MATHUR" <nitin_maths@rediffmail.com> wr= ote: > Ahh, so thats the problem. We are using IDS Version 11.70.FC4 on Solaris x= 86,=20 > probably we should upgrade to FC5 if we want to use IWA.=20 >=20 > Thanks for your responses.=20 >=20 > regards,=20 >=20 > Nitin=20 >=20 >=20 > **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20
The problem is: IWA CentOS ---> IDS CentOS --> IDS Solaris IDS tables on CentOS are synonyms of real IDS tables on Solaris. This doesn't works on IWA. IWA cannot get data from synonyms. This could be a great new feature, but doesn't works at the moment. You should connect IWA CentOS directly to IDS Solaris. Note that IDS on solaris should be a 11.70.XXX version
Thanks Vincent. Since my OS Solaris x86 is supported only after FC5, I am now downloading this version and install on dev box and see how best can I use it. regards, Nitin