1) I am using the InfoSphere Fed Server, with DB2, both releases 10.5. I am trying to create some wrappers for a federated database. The source databases are MySQL and PostGres. I am getting various errors when attempting to create a wrapper like:
CREATE WRAPPER ODBC LIBRARY 'libdb2rcodbc.s o' OPTIONS (MODULE '/opt/IBM/WSII/V10.5/lib64/libdb2rcodbc.so ');
The SQL statement or command failed because of a database system error. (Reason "Unable to load the fencible wrapper library".). SQLCODE=-901, SQLSTATE=58004, DRIVER=4.17.30
CREATE WRAPPER jdbc2 LIBRARY 'libdb2rjdbc.so ' OPTIONS (MODULE '/opt/IBM/WSII/V10.5/lib64/libdb2jdbc.so') ;
The specified library "libdb2rjdbc.so " could not be loaded.. SQLCODE=-10013, SQLSTATE=42724, DRIVER=4.17.30
Please let me know what I am missing.
2) Are there built-in wrappers for JDBC and ODBC for the databases I am trying to connect? Also, if there is any quick start walk-through tutorial for command-line based federation for release 10.5, I would appreciate a pointer.
CREATE WRAPPER ODBC LIBRARY 'libdb2rcodbc.s o' OPTIONS (MODULE '/opt/IBM/WSII/V10.5/lib64/libdb2rcodbc.so ');
The SQL statement or command failed because of a database system error. (Reason "Unable to load the fencible wrapper library".). SQLCODE=-901, SQLSTATE=58004, DRIVER=4.17.30
CREATE WRAPPER jdbc2 LIBRARY 'libdb2rjdbc.so ' OPTIONS (MODULE '/opt/IBM/WSII/V10.5/lib64/libdb2jdbc.so') ;
The specified library "libdb2rjdbc.so " could not be loaded.. SQLCODE=-10013, SQLSTATE=42724, DRIVER=4.17.30
Please let me know what I am missing.
2) Are there built-in wrappers for JDBC and ODBC for the databases I am trying to connect? Also, if there is any quick start walk-through tutorial for command-line based federation for release 10.5, I would appreciate a pointer.