I have my DB2 Client installed. I have my catalog and database directory setup. I have a user that I can use to connect to our remote DB2 database. The /home/db2inst1/sqllib/include directory appears to have all the necessary files - the header files, etc.
I don't understand the "you will have to create a symbolic link from libclntsh.so to the actual shared library file yourself"; I can find out how to create a sym link but I'm not sure how to create this because I'm not exactly sure what is meant by the 'actual shared library'. Can you point me in the correct direction?
I have a PostgreSQL 10.6 database running on Ubuntu 18.04. I installed postgresql-server-dev-10 package.
I see the /usr/lib/postgresql/10/lib with all the *.so files and the pgxs directory with the config and src directories. Do I extract the db2_fdw to the src directory?
pg_config --pgxs works fine
Not sure where to put all the files before I CREATE EXTENSION.
Any help would be greatly appreciated. Being able to access our old DB2 database through postgres will be fantastic.
Thanks
I have my DB2 Client installed. I have my catalog and database directory setup. I have a user that I can use to connect to our remote DB2 database. The /home/db2inst1/sqllib/include directory appears to have all the necessary files - the header files, etc.
env | grep DB2 DB2INSTANCE=db2inst1 DB2_HOME=/home/db2inst1/sqllib DB2LIB=/home/db2inst1/sqllib/lib
env | grep PG returns nothing
I don't understand the "you will have to create a symbolic link from libclntsh.so to the actual shared library file yourself"; I can find out how to create a sym link but I'm not sure how to create this because I'm not exactly sure what is meant by the 'actual shared library'. Can you point me in the correct direction?
I have a PostgreSQL 10.6 database running on Ubuntu 18.04. I installed postgresql-server-dev-10 package.
I see the /usr/lib/postgresql/10/lib with all the *.so files and the pgxs directory with the config and src directories. Do I extract the db2_fdw to the src directory?
pg_config --pgxs works fine
Not sure where to put all the files before I CREATE EXTENSION.
Any help would be greatly appreciated. Being able to access our old DB2 database through postgres will be fantastic. Thanks