Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Do I need DB2 Connect to connect my Linux, Unix, or Windows clients to DB2 for i?

April 26, 2017clients Connect db2 linux Unix Windows

0

Posted

Do I need DB2 Connect to connect my Linux, Unix, or Windows clients to DB2 for i?

1 Answer

0

Posted

The answer is that DB2 Connect can be used, but it is not necessarily a requirement. DB2 Connect can be used to connect applications from those environments to any DB2 server via ODBC, .NET, JDBC, or using CLI/DRDA interfaces. So if the only connectivity required is from Windows or Linux, to DB2 for i (no other DB2 family member), you might consider the IBM i Access for Windows middleware (ODBC, OLE DB, .NET) or Java Toolbox JDBC drivers available at no charge with the IBM i operating system. However, DB2 Connect also includes additional programmer productivity features through .NET (Visual Studio) or PHP (Zend Studio) plug-ins for DB2. DB2 Connect can also be used for DB2 data “federation”, such as the ability to join data from two DB2 (or Informix) databases with a single SQL statement. DB2 Connect’s mobility on demand feature includes a synchronization server to replicate (and synchronize) data from DB2 Servers with DB2 products running in a mobile device.