DB2 EE v7.2 for LINUX
(no fixpack (have also tried with fixpack 7)) (Application Devlopment tools have been included)
MF Object COBOL OCDS 4.1.40 (for UNIX)
Trying to run a sample executable (compiled successfully using the MF cob compiler) but I am encountering SQL10013N - Cannot find directory or file /home/db2inst1/sqllib/function/RELSPROC. The sample executable cannot seem to load the stored procedure from the function directory - even though the Stored Procedure RELSPROC has been compiled successfully & is DEFINITELY in the function directory!! RELSPROC also seems to be defined OK in DB2 as well.
Micro Focus rts32 has been built successfully including libdb2.so sqlgmf.o
The rts32 has been copied to /opt/lib/cobol
All the environment variables (that I know about) seem to be set up & exported correctly:
BTW, I have had this running in a very similar environment where the only difference I know of is that RH v7.1 is installed instead of RH v7.2. Ive also had it working in yet another environment using RH v7.3 .... so Im guessing that RH v7.2 should be OK!!!
I located the following error message in the /sqllib/db2dump/db2diag.log file:
"liboops.so: cannot open shared object file: no such file or directory"
liboops.so (& other MF Program library files & archives) is in directory
The whole problem was resolved by creating symbolic links from /usr/lib to /opt/lib/cobol/coblib for all .a and .so files in opt/lib/cobol/coblib, but given I think I have all the correct environment variables set - to point to the correct shared libraries - what else needs to be done so that the symbolic links don't have to be created?
Environment variables that are set:
For my DB2 instance, I have exported
For my DB2 instance, I have
db2set DB2ENVLIST="PATH LD_LIBRARY_PATH COBDIR"