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?
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
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.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 293 |
Nodes: | 16 (2 / 14) |
Uptime: | 229:45:22 |
Calls: | 6,624 |
Calls today: | 6 |
Files: | 12,171 |
Messages: | 5,319,113 |