Hi,
I wanted to test federation wih the current development build "DB2 v11.1.2.2", "s1705181300". It seems that only MySQL Enterprise or a Commercial version is support. That's bad for most customers I think.
Here are the steps to reproduce:
CREATE WRAPPER ODBC LIBRARY 'libdb2rcodbc.so'
OPTIONS (MODULE '/db2/db2fed01/sqllib/federation/odbc/lib/libodbc.so');
CREATE SERVER nextcloud TYPE mysql
VERSION 4.0 WRAPPER ODBC
OPTIONS (ADD NODE 'nextcloud', DBNAME 'nextcloud');
CREATE USER MAPPING FOR db2fed01 SERVER nextcloud OPTIONS (REMOTE_AUTHID 'root', REMOTE_PASSWORD '********');
CREATE NICKNAME mysql_nextcloud_db FOR nextcloud."oc_accounts";
[FluidQuery][ODBC MySQL Wire Protocol driver]Connections to MySQL Community Servers are not supported. Please contact MySQL to obtain a MySQL Enterprise or Commercial version.
The MySQL version is shipped by Debian Linux 8 (Jessie) and MySQL version is mysql Ver 14.14 Distrib 5.5.53, for debian-linux-gnu (x86_64) using readline 6.3
So please support also NON Enterprise and NON Commersion versions of MySQL!
Is there any workaround to get it running for test purposes (hidden reg variable ie)?
Thanks.
Best regards,
Gerhard Paulus