Informix and DRAD
Jeff Pouton asked about experiences and pitfalls using DRDA connectivity with IDS 11.70.FC6 on AIX. Art Kagel had one client using it for third-party tools with no known issues. Stefan Sammut called it brilliant with the Db2 common driver and .NET, advising adding the drsoctcp threads in config, and said PAM needs a special fix on 11.70 FC8 or 12.1 xC5. Jeff thanked them.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Just wondering if any-one out there has much experience with Informix connectivity using DRDA. Our company is considering using this protocol. Are there any performance issues or gotchas that people might have experienced? We are running IDS 11.70.FC6 on AIX Servers. Thanks in advance.
I have one client using DRDA to connect some third party tools. No issues of which I am aware. 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 Fri, May 22, 2015 at 2:22 AM, JEFF POUTON <jeff.poulton@reece.com.au> wrote: > Just wondering if any-one out there has much experience with Informix > connectivity using DRDA. Our company is considering using this protocol. > > Are there any performance issues or gotchas that people might have > experienced? > > We are running IDS 11.70.FC6 on AIX Servers. > > Thanks in advance. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113321ee7473660516a9130e
We have used it over 2 years It's brilliant. Especially if use it from Db2 common driver + .net . Gives much better interoperability with .NET eg Data Entity Services Projects. Make sure you add the relative threads in config drsoctcp And if you want to use PAM - there is a special fix on top of 11.7 FC8 (requested by us) Or using 12.1 xc5 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JEFF POUTON Sent: 22 May 2015 08:22 To: ids@iiug.org Subject: Informix and DRAD [35168] Just wondering if any-one out there has much experience with Informix connectivity using DRDA. Our company is considering using this protocol. Are there any performance issues or gotcha's that people might have experienced? We are running IDS 11.70.FC6 on AIX Servers. Thanks in advance. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. Stefan Sammut Manager - Solutions & Innovation [PTL Ltd] Nineteen Twenty Three, Valletta Road Marsa, MRS 3000, MT T +35621445566 +356 99405444 stefan.sammut@ptl.com.mt | www.ptl.com.mt<http://www.ptl.com.mt>; [Facebook]<https://www.facebook.com/PTLMalta/app_349313058487732>; [LinkedIn] <https://www.linkedin.com/company/ptl-ltd?trk=tyah&trkInfo=tarId%3A1401716999276 %2Ctas%3APTL%2Cidx%3A2-3-8> [Twitter] <https://twitter.com/PTL_Malta>; [Youtube] <https://www.youtube.com/channel/UCuXrJBO_54kd9HttG8S89iQ/feed?view_as =public> [Google Plus] <https://plus.google.com/+PTLMalta>;
Thanks for the feedback.