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...
Failed to load Transformer library file (on DB2 server)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: