1. Forum
  2. Usenet
  3. COMP.DATABASES.IBM-DB2

  • Configuring Federation to MS SQL Server

    From Luiz da Silva@21:1/5 to All on Thu Jun 22 07:12:32 2017
    Hey guys,

    I can successfully create a wrapper for SQL Server in DB2 11.1.1 AESE on Linux but not in DB2 9.7 fp10 AESE on Windows 2010:

    CREATE WRAPPER MSSQLODBC3

    The specified library "db2mssql3.dll" could not be loaded.. SQLCODE=-10013, SQLSTATE=42724

    I couldn't find the mentioned library on the <DB2PATH>\bin as stated in Knoweledge center.

    Does anyone know if that missing library in 9.7 was only available with InfoSphere Federation Server product?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From [email protected]@21:1/5 to All on Fri Jun 23 03:42:08 2017
    El jueves, 22 de junio de 2017, 16:12:34 (UTC+2), Luiz da Silva escribió:
    Hey guys,

    I can successfully create a wrapper for SQL Server in DB2 11.1.1 AESE on Linux but not in DB2 9.7 fp10 AESE on Windows 2010:

    CREATE WRAPPER MSSQLODBC3

    The specified library "db2mssql3.dll" could not be loaded.. SQLCODE=-10013, SQLSTATE=42724

    I couldn't find the mentioned library on the <DB2PATH>\bin as stated in Knoweledge center.

    Does anyone know if that missing library in 9.7 was only available with InfoSphere Federation Server product?

    Luiz, I have a document that describes the whole process when we did some tests last year. (but it's in spanish). If you want I can send it to you if it may help.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jeremy Rickard@21:1/5 to All on Fri Jun 23 15:47:15 2017
    See the line labelled Homogenous Federation at: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.licensing.doc/doc/r0053238.html

    It appears that with 9.7 AESE you can federate to DB2, Informix and Oracle. I think you are right that with 9.7 you needed the InfoSphere re-branded add-on for other data sources.

    Jeremy

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From [email protected]@21:1/5 to All on Sun Jun 25 22:41:14 2017
    El sábado, 24 de junio de 2017, 0:47:17 (UTC+2), Jeremy Rickard escribió:
    See the line labelled Homogenous Federation at: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.licensing.doc/doc/r0053238.html

    It appears that with 9.7 AESE you can federate to DB2, Informix and Oracle. I think you are right that with 9.7 you needed the InfoSphere re-branded add-on for other data sources.

    Jeremy

    yes, I confirm that. You need Infosphere Federation Server to federate against oracle or sql server.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Luiz da Silva@21:1/5 to [email protected] on Wed Jun 28 01:26:03 2017
    On Monday, June 26, 2017 at 7:41:16 AM UTC+2, [email protected] wrote:
    El sábado, 24 de junio de 2017, 0:47:17 (UTC+2), Jeremy Rickard escribió:
    See the line labelled Homogenous Federation at: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.licensing.doc/doc/r0053238.html

    It appears that with 9.7 AESE you can federate to DB2, Informix and Oracle. I think you are right that with 9.7 you needed the InfoSphere re-branded add-on for other data sources.

    Jeremy

    yes, I confirm that. You need Infosphere Federation Server to federate against oracle or sql server.

    It's clear now, thanks guys!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)