Enabling DRDA

Posted in 2009

Topics: Server Administration, Networking & sqlhosts Configuration

Adam Tauno Williams — Thu, 16 Apr 2009 16:07:30 — source: IIUG Forums & Mailing Lists

I'm trying, without success, to enable DRDA on Informix 11.10.UC1 running on SuSE LINUX. In sqlhosts I have a line for it: BARDRDA drsoctcp 192.168.1.60 9502 In onconfig I have both a NETTYPE and an ALIAS: ... DBSERVERNAME BARNET # Name of default database server DBSERVERALIASES BARIPC BARDRDA # List of alternate dbservernames ... NETTYPE drsoctcp,3,2,CPU # Configure poll thread(s) for nettype ... But the server is NOT listening on port 9502 (confirmed via "netstat --listen --tcp -n --program"). According to what I see in the admin guide this seems to be all that is required to enable DRDA. <http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm. admin.doc/admin155.htm>

↪ replying to Adam Tauno Williams

Direk Phaisitwanitkul — Thu, 16 Apr 2009 17:14:42 — source: IIUG Forums & Mailing Lists

Hi Adam, Try to use "," as delimiter between server name for DBSERVERALIASES. Specify only protocol name for NETTYPE DBSERVERALIASES BARIPC,BARDRDA NETTYPE soctcp,3,2,CPU BR, Direk -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Adam Tauno Williams Sent: Thursday, April 16, 2009 23:08 To: ids@iiug.org Subject: Enabling DRDA [15540] I'm trying, without success, to enable DRDA on Informix 11.10.UC1 running on SuSE LINUX. In sqlhosts I have a line for it: BARDRDA drsoctcp 192.168.1.60 9502 In onconfig I have both a NETTYPE and an ALIAS: .... DBSERVERNAME BARNET # Name of default database server DBSERVERALIASES BARIPC BARDRDA # List of alternate dbservernames .... NETTYPE drsoctcp,3,2,CPU # Configure poll thread(s) for nettype .... But the server is NOT listening on port 9502 (confirmed via "netstat --listen --tcp -n --program"). According to what I see in the admin guide this seems to be all that is required to enable DRDA. <http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com. ibm.admin.doc/admin155.htm> **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Adam Tauno Williams

Alberto Pessonio — Thu, 16 Apr 2009 18:19:22 — source: IIUG Forums & Mailing Lists

Adam: Did you add a DRDA vp class in your Instance? onmode -p +1 drda ? If you r trying to go from DB2 to informix, it's just fine. If you r trying to go from informix to DB2 Mainframe (or DB2 for LUW, as well), you must use Informix Enterprise Gatrway with DRDA. Regards, T*** Systems do Brasil Ltda Alberto Romeu Pessonio Filho IBM Informix Certified System Administrator V7 IBM Certified Managing and Optimizing Informix Databases V7 DBA Informix/DB2 UDB/SQLServer/Oracle F: 55+11-4347-5475 / 2184-2751 email: alberto.pessonio@ts3.com.br Internet: www.t-systems.com.br -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Adam Tauno Williams Enviada em: quinta-feira, 16 de Abril de 2009 13:08 Para: ids@iiug.org Assunto: Enabling DRDA [15540] I'm trying, without success, to enable DRDA on Informix 11.10.UC1 running on SuSE LINUX. In sqlhosts I have a line for it: BARDRDA drsoctcp 192.168.1.60 9502 In onconfig I have both a NETTYPE and an ALIAS: .... DBSERVERNAME BARNET # Name of default database server DBSERVERALIASESBARIPC BARDRDA # List of alternate dbservernames .... NETTYPE drsoctcp,3,2,CPU # Configure poll thread(s) for nettype .... But the server is NOT listening on port 9502 (confirmed via "netstat --listen --tcp -n --program"). According to what I see in the admin guide this seems to be all that is required to enable DRDA. <http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/ com.ibm.admin.doc/admin155.htm> ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Adam Tauno Williams

Guy . — Fri, 17 Apr 2009 00:02:39 — source: IIUG Forums & Mailing Lists

Can you try commenting out the NETTYPE setting in onconfig and starting IDS again? Since you have the IP address in your SQLHOSTS file, are you connect by IP address as well? Did the server start at all? Guy ________________________________ From: Adam Tauno Williams <adam@morrison-ind.com> To: ids@iiug.org Sent: Thursday, April 16, 2009 9:07:31 AM Subject: Enabling DRDA [15540] I'm trying, without success, to enable DRDA on Informix 11.10.UC1 running on SuSE LINUX. In sqlhosts I have a line for it: BARDRDA drsoctcp 192.168.1.60 9502 In onconfig I have both a NETTYPE and an ALIAS: .... DBSERVERNAME BARNET # Name of default database server DBSERVERALIASES BARIPC BARDRDA # List of alternate dbservernames .... NETTYPE drsoctcp,3,2,CPU # Configure poll thread(s) for nettype .... But the server is NOT listening on port 9502 (confirmed via "netstat --listen --tcp -n --program"). According to what I see in the admin guide this seems to be all that is required to enable DRDA. <http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm. admin.doc/admin155.htm> ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Adam Tauno Williams

Art Kagel — Fri, 17 Apr 2009 14:45:38 — source: IIUG Forums & Mailing Lists

First, tcp listeners should NEVER be configured in CPU VPs, so your NETTYPE below should be specifying NET not CPU. Second, IB that the protocol setting should just be soctcp - OK the 'dr' is optional according to the manual, but I've never used it and seem to remember sometimes having trouble because it was there. Last, IB that the But your big problem IB are the upper case servernames. According to the Administrator's Guide: The dbservername field can include any printable character other than an uppercase character, a field delimiter, a new line character, or a comment character. This field is limited to 128 bytes. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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 Thu, Apr 16, 2009 at 12:07 PM, Adam Tauno Williams <adam@morrison-ind.com > wrote: > I'm trying, without success, to enable DRDA on Informix 11.10.UC1 > running on SuSE LINUX. > > In sqlhosts I have a line for it: > BARDRDA drsoctcp 192.168.1.60 9502> > In onconfig I have both a NETTYPE and an ALIAS: > .... > DBSERVERNAME BARNET # Name of default database server > DBSERVERALIASES BARIPC BARDRDA # List of alternate dbservernames > .... > NETTYPE drsoctcp,3,2,CPU # Configure poll thread(s) for nettype > ....> > But the server is NOT listening on port 9502 (confirmed via "netstat > --listen --tcp -n --program"). According to what I see in the admin > guide this seems to be all that is required to enable DRDA. > > > < > http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.a dmin.doc/admin155.htm > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e642d00cb931c10467c13bb1

Enabling DRDA

Glossary

Your privacy choices