If you compare a new installation to a previously existing one you find that <InstallDir>/fmc/lib/Workflow was not created.
When running fmczinsx -o oracle10 or fmczinsx -o db2 you see a warning similar to 'the libclntsh.sl.10.1 could not be found using the built in search paths'.
This directory path is not created by the WebSphere MQ Workflow installation in DB2 or Oracle environments.
UNIX based environments for DB2 or Oracle.
Resolving the problem
The directory path <InstallDir>/fmc/lib/workflow must be created manually and the softlinks created for whichever database system you are using.
Use the following steps to set up the appropriate softlinks.
1) Create two new directories
2) Set the permissions using the command "chmod 755 /<MQWF_install_dir>/lib/workflow*"
3) Link the 32-bit DB2 or Oracle libraries of the database product copy to be used into the directory
For example, if the DB2 copy is installed in /opt/IBM/db2/V9.x, and IBM WebSphere MQ Workflow is installed in /opt/fmc, enter:
ln /opt/IBM/db2/V9.x/lib32/lib* /opt/fmc/lib/workflow
4) Link the 64-bit DB2 or Oracle ibraries of the database product copy to be used into the directory
For example, if the DB2 copy is installed in /opt/IBM/db2/V9.x, and IBM WebSphere MQ Workflow is installed in /opt/fmc, you would enter:
ln -s /opt/IBM/db2/V9.x/lib64/lib* /opt/fmc/lib/workflow64
Note: If you are using DB2 V9.x installed in the default installation directory /opt/IBM/db2/V9.x and there are no other DB2 Version installed in the db2 default installation directory, the above steps are not necessary.
After creating the appropriate softlinks fmczinsx - o <database product> must be run again.
WMQ MQ WF fmc00dba fmc00inc fmc00cfu fmc00ora fmc00dba fmc00wf