Failed to load Transformer library file (on DB2 server)

pras · Post by **pras** » Mon Oct 31, 2011 10:22 am

We are getting the following warning message in all our jobs which is using Transformer stage. We have IBM InfoServer 8.0 in our application server which is a SMP system and configured DB2 cluster server to make use of DS "Enterprise DB2 stage". We have 4 config file for 1x, 2x and 4x parallelism and also all the DB2 nodes with a tag "db2". So whenever we use transformer we get a warning message tell us that the transform library could not be found in DB2 nodes.

Please let us know if we have any APT setting to suppress this warning message.

Warning message:
node_db2_server: Warning: library "V0S12_processcode_stage_to_prod_3_TFM_TO_IU_Recs" (for class "APT_TransformOperatorImplV0S12_processcode_stage_to_prod_3_TFM_TO_IU_Recs") failed to load: Could not find "V0S12_processcode_stage_to_prod_3_TFM_TO_IU_Recs" on the library search path defined by the environment variable LD_LIBRARY_PATH; path: /<appln root>/sit/dsadm/batch/uscrm/ds_proj/DSAPP_SIT/RT_BP2206.O:/<appln root>/IBM/sit/InformationServer/Server/DSComponents/lib:/<appln root>/IBM/sit/InformationServer/Server/DSComponents/bin:/<appln root>/IBM/sit/InformationServer/Server/DSParallel:/<appln root>/IBM/sit/InformationServer/Server/PXEngine/user_lib:/<appln root>/IBM/sit/InformationServer/Server/PXEngine/lib:/<appln root>/sit/dsadm/batch/uscrm/ds_proj/DSAPP_SIT/buildop:/<appln root>/home/dsadm/sqllib/lib32:/<appln root>/pkgs/linux/intel/db2/V9.1/FP3/lib32:/<appln root>/IBM/sit/InformationServer/Server/branded_odbc/lib:/<appln root>/IBM/sit/InformationServer/Server/DSEngine/lib:/<appln root>/IBM/sit/InformationServer/Server/DSEngine/uvdlls:/<appln root>/IBM/sit/InformationServer/ASBNode/apps/jre/bin:/<appln root>/IBM/sit/InformationServer/ASBNode/apps/jre/bin/classic:/<appln root>/IBM/sit/InformationServer/ASBNode/lib/cpp:/<appln root>/IBM/sit/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86:/<appln root>/pkgs/linux/intel/oracle/9.2.client32/lib:/<appln root>/pkgs/linux/intel/oracle/9.2.client32/rdbms/lib:/<appln root>/home/dsadm/sqllib/lib32:/<appln root>/pkgs/linux/intel/db2/V9.1/FP3/lib32:/<appln root>/IBM/sit/InformationServer/Server/branded_odbc/lib:/<appln root>/IBM/sit/InformationServer/Server/DSEngine/lib:/<appln root>/IBM/sit/InformationServer/Server/DSEngine/uvdlls:/<appln root>/IBM/sit/InformationServer/ASBNode/apps/jre/bin:/<appln root>/IBM/sit/InformationServer/ASBNode/apps/jre/bin/classic:/<appln root>/IBM/sit/InformationServer/ASBNode/lib/cpp:/<appln root>/IBM/sit/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86:/<appln root>/pkgs/linux/intel/oracle/9.2.client32/lib:/<appln root>/pkgs/linux/intel/oracle/9.2.client32/rdbms/lib:/<appln root>/home/dsadm/sqllib/lib32:/<appln root>/pkgs/linux/intel/db2/V9.1/FP3/lib32:/<appln root>/IBM/sit/InformationServer/Server/branded_odbc/lib:/<appln root>/IBM/sit/InformationServer/Server/DSEngine/lib:/<appln root>/IBM/sit/InformationServer/Server/DSEngine/uvdlls:/<appln root>/IBM/sit/InformationServer/ASBNode/apps/jre/bin:/<appln root>/IBM/sit/InformationServer/ASBNode/apps/jre/bin/classic:/<appln root>/IBM/sit/InformationServer/ASBNode/lib/cpp:/<appln root>/IBM/sit/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86:/<appln root>/pkgs/linux/intel/oracle/9.2.client32/lib:/<appln root>/pkgs/linux/intel/oracle/9.2.client32/rdbms/lib:/<appln root>/home/dsadm/sqllib/lib32:/<appln root>/pkgs/linux/intel/db2/V9.1/FP3/lib32:/<appln root>/IBM/sit/InformationServer/Server/branded_odbc/lib:/<appln root>/IBM/sit/InformationServer/Server/DSEngine/lib:/<appln root>/IBM/sit/InformationServer/Server/DSEngine/uvdlls:/<appln root>/IBM/sit/InformationServer/ASBNode/apps/jre/bin:/<appln root>/IBM/sit/InformationServer/ASBNode/apps/jre/bin/classic:/<appln root>/IBM/sit/InformationServer/ASBNode/lib/cpp:/<appln root>/IBM/sit/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86:/<appln root>/pkgs/linux/intel/oracle/9.2.client32/lib:/<appln root>/pkgs/linux/intel/oracle/9.2.client32/rdbms/lib:/<appln root>/pkgs/linux/intel/perl/5.8.0/lib:/<appln root>/sit/controlm/agt/ctmagent/ctm/exe:/<appln root>/pkgs/linux/intel/postgresql/7.4.6/lib:/<appln root>/pkgs/linux/intel/mysql/4.0.12/lib/mysql:/<appln root>/pkgs/linux/intel/mysql/4.0.12/lib:/<appln root>/pkgs/linux/intel/openssl/0.9.7d.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/etsvc_core/2.3.9.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/curl/7.12.3p.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/log4c/1.0.10.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/libxml2/2.6.10.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/bfw_core/2.8.7.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/bfw/4.0.0.rc4/lib:/<appln root>/pkgs/linux/intel/syboc/12.5_ESD14/OCS/lib:/<appln root>/pkgs/linux/intel/syboc/12.5_ESD14/lib:/<appln root>/pkgs/linux/intel/syboc/12.5_ESD14/FTS/lib:/<appln root>/pkgs/linux/intel/syboc/12.5_ESD14//lib:/<appln root>/pkgs/linux/intel/syboc/12.5_ESD14//lib:/usr/X11R6/lib:/<appln root>/pkgs/linux/intel/opensrc/1.0/lib:/<appln root>/pkgs/linux/intel/opensrc/1.0/ssl/lib:/<appln root>/pkgs/linux/intel/adm/1.1/lib:/<appln root>/pkgs/linux/intel/tuxedo/8.1p062/lib:/<appln root>/pkgs/linux/intel/svcdet/ssr20111028.lxt8.0.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/bridgetoken/1.0.1.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/svcdet/ssr20111028.lxt8.0.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/svcclt/ssr20040621.7.0/lib:/<appln root>/pkgs/linux/intel/xerces/c2.6.0.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/xalan/c1.8icu.P.rhas3.x86:/<appln root>/pkgs/linux/intel/xalan/c1.8icu.P.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/xalan/c1.8icu.P.rhas3.x86/xml-xalan/c/lib:/<appln root>/pkgs/linux/intel/icu/2.6.2.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/apr/0.9.7.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/apr_util/0.9.7.rhas3.x86/lib:/<appln root>/pkgs/linux/intel/subversion/1.4.6.rhas3.x86/usr/local/lib:/<appln root>/pkgs/linux/intel/subversion/1.4.6.rhas3.x86/usr/local/apache2/lib:/<appln root>/pkgs/linux/intel/subversion/1.4.6.rhas3.x86/usr/local/ssl/lib:/<appln root>/pkgs/linux/intel/subversion/1.4.6.rhas3.x86/usr/local/BerkeleyDB.4.2/lib:/<appln root>/pkgs/linux/intel/subversion/1.4.6.rhas3.x86/usr/local/apr/lib:/<appln root>/pkgs/linux/intel/sunjava2/1.6.0r14/jre/lib/i386:/<appln root>/pkgs/linux/intel/sunjava2/1.6.0r14/jre/lib/i386/server:/<appln root>/pkgs/linux/intel/sunjava2/1.6.0r14/jre/bin:/<appln root>/pkgs/linux/intel/sunjava2/1.6.0r14/jre/lib/i386/native_threads:/<appln root>/pkgs/linux/intel/gcc/4.1.1/lib:/<appln root>/pkgs/linux/intel/adm/1.1/lib:/<appln root>/pkgs/linux/intel/tuxedo/8.1p062/lib:/<appln root>/home/dsadm/sqllib/lib32:/<appln root>/pkgs/linux/intel/oracle/9.2.client32/lib:/<appln root>/pkgs/linux/intel/syboc/12.5_ESD14/OCS/lib:/<appln root>/pkgs/linux/intel/syboc/12.5_ESD14/OCS/lib:/<appln root>/pkgs/linux/intel/syboc/12.5_ESD14/OCS/lib:/<appln root>/pkgs/linux/intel/syboc/12.5_ESD14/OCS/lib:.:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$APT_ORCHHOME/lib:/<appln root>/pkgs/linux/intel/db2/V9.1.0.8/lib32:/usr/lib:/lib.

Thanks...

ray.wurlod · Post by **ray.wurlod** » Mon Oct 31, 2011 11:52 am

You need to make sure that LD_LIBRARY_PATH includes the parent directory of the library referred to in the error message.

pras · Post by **pras** » Mon Oct 31, 2011 12:08 pm

Hi ray, to my understanding the PX engine is searching for the Transformer generated object file in DS project directory (and on the LD_LIBRARY_PATH directories) on DB2 server. But the transformer object files is present (and generated) only in project directory on the application server. So it should not search the transformer object file in DB2 cluster server location, do we have a APT or DS variable to exclude it or any special TAG to be given in APT_CONFIG_FILE?

ray.wurlod · Post by **ray.wurlod** » Mon Oct 31, 2011 9:01 pm

Nothing special. LD_LIBRARY_PATH should automatically be adjusted for the process that executes the transform operator.