Oninit cdi / Archive
Talk to an expert →

Multiple DRDA setup

Posted in 2017

Topics: Connectivity: ODBC / JDBC / .NET, Networking & sqlhosts Configuration, Platform-Specific Issues

RONALD OLAVIDEZ — — source: IIUG Forums & Mailing Lists

Hi Gurus, I'm trying to test JDBC (onsoctcp) and DRDA (drsoctcp). JDBC works fine using jdbc.url = jdbc:informix-sqli:DATABASE=DBname;INFORMIXSERVER=Instance;SQLH_TYPE=FILE;SQLH_F ILE=/opt/informix/etc/sqlhosts; Is it possible to do the same for DRDA? I can test via testconnect40 and IBM Datatools but it's just a single connection to a server. All i want is to have the SQLH_FILE parameter control the connection, whateever is specified/defined in SQLH_FILE. I'm using IDS 11.70/12.10 + Linux OS. Thanks in advance, Ronald

↪ replying to RONALD OLAVIDEZ
Andreas Legner1 — — source: IIUG Forums & Mailing Lists

I think you've got to use a DRDA enabled driver which JDBC isn't. -> you'd have to use IBM DB2 JDBC Universal Driver (JCC) ... which, again if I'm right, doesn't know about the concept of an sqlhosts file. https://www.redbooks.ibm.com/redbooks/pdfs/sg247884.pdf might be of help. From: "RONALD OLAVIDEZ" <ronald.olavidez@gmail.com> To: ids@iiug.org Date: 09/14/2017 09:01 AM Subject: Multiple DRDA setup [39852] Sent by: ids-bounces@iiug.org Hi Gurus, I'm trying to test JDBC (onsoctcp) and DRDA (drsoctcp). JDBC works fine using jdbc.url = jdbc:informix-sqli:DATABASE=DBname;INFORMIXSERVER=Instance;SQLH_TYPE=FILE;SQLH_F ILE=/opt/informix/etc/sqlhosts; Is it possible to do the same for DRDA? I can test via testconnect40 and IBM Datatools but it's just a single connection to a server. All i want is to have the SQLH_FILE parameter control the connection, whateever is specified/defined in SQLH_FILE. I'm using IDS 11.70/12.10 + Linux OS. Thanks in advance, Ronald ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary