abt db2 EE
Posted: Fri Jul 15, 2005 8:35 am
Hi,
We are using DB2 EE stage to access DB2.
We have a SMP unix called as Server1 and DB2 is installed on Server2.
Our jobs follow ETL methodology i.e. 1 extract job, 1 transform and then 1 load job.
Now the configuration file consists of 4 nodes with fastname a Server1 and one db2 node with fastname as Server2. The db2 server has no PX on it, so it is not the part of default node pool and defined as the member of DB2 pool.
While extract this works fine and dataset has one partition file from dataset on db2 server i.e. Server2 and remaining on Sever1.
Here the DB2 EE stage runs on Server2.
Now during Transform job, it gives one error as:
node_db2node1: Error loading "V194S1_GLEAMMthCMArrIPRelDervationJob_CMArrIpRel_Derivation_Tfp": Could not find "V194S1_GLEAMMthCMArrIPRelDervationJob_CMArrIpRel_Derivation_Tfp"
on the library search path defined by the environment variable LIBPATH; path:
/gcdm/dev/project/GrpCreditDM_DEV/RT_BP5642.O:/DataStageApp/Ascential/DataStage/DSCAPIOp:
/DataStageApp/Ascential/DataStage/RTIOperators:/DataStageApp/Ascential/DataStage/DSParallel:
/DataStageApp/Ascential/DataStage/PXEngine/user_lib:/DataStageApp/Ascential/DataStage/PXEngine/lib:
/gcdm/dev/project/GrpCreditDM_DEV/buildop:/DataStageApp/Ascential/DataStage/branded_odbc/lib:
/DataStageApp/Ascential/DataStage/DSEngine/lib:/DataStageApp/Ascential/DataStage/DSEngine/uvdlls:
/DataStageApp/Ascential/DataStage/DSEngine/java/jre/bin/classic:
/DataStageApp/Ascential/DataStage/DSEngine/java/jre/bin:/db2/cdwhd32/home/sqllib/lib:
/opt/sybase/OCS-12_5/lib:/usr/local/openwin/lib:/usr/lib:/lib; for class "APT_TransformOperatorImplV194S1_GLEAMMthCMArrIPRelDervationJob_CMArrIpRel_Derivation_Tfp"
node_db2bode is Server2 in config file.
It is trying to put one transformer process one Server2 which is not the part of default pool, it is in different pool called 'db2'. Why is it still trying to load one transformer process on this Server2, ideally accorirding to config, it should not put this transformer process on db2 server.
We are using DB2 EE stage to access DB2.
We have a SMP unix called as Server1 and DB2 is installed on Server2.
Our jobs follow ETL methodology i.e. 1 extract job, 1 transform and then 1 load job.
Now the configuration file consists of 4 nodes with fastname a Server1 and one db2 node with fastname as Server2. The db2 server has no PX on it, so it is not the part of default node pool and defined as the member of DB2 pool.
While extract this works fine and dataset has one partition file from dataset on db2 server i.e. Server2 and remaining on Sever1.
Here the DB2 EE stage runs on Server2.
Now during Transform job, it gives one error as:
node_db2node1: Error loading "V194S1_GLEAMMthCMArrIPRelDervationJob_CMArrIpRel_Derivation_Tfp": Could not find "V194S1_GLEAMMthCMArrIPRelDervationJob_CMArrIpRel_Derivation_Tfp"
on the library search path defined by the environment variable LIBPATH; path:
/gcdm/dev/project/GrpCreditDM_DEV/RT_BP5642.O:/DataStageApp/Ascential/DataStage/DSCAPIOp:
/DataStageApp/Ascential/DataStage/RTIOperators:/DataStageApp/Ascential/DataStage/DSParallel:
/DataStageApp/Ascential/DataStage/PXEngine/user_lib:/DataStageApp/Ascential/DataStage/PXEngine/lib:
/gcdm/dev/project/GrpCreditDM_DEV/buildop:/DataStageApp/Ascential/DataStage/branded_odbc/lib:
/DataStageApp/Ascential/DataStage/DSEngine/lib:/DataStageApp/Ascential/DataStage/DSEngine/uvdlls:
/DataStageApp/Ascential/DataStage/DSEngine/java/jre/bin/classic:
/DataStageApp/Ascential/DataStage/DSEngine/java/jre/bin:/db2/cdwhd32/home/sqllib/lib:
/opt/sybase/OCS-12_5/lib:/usr/local/openwin/lib:/usr/lib:/lib; for class "APT_TransformOperatorImplV194S1_GLEAMMthCMArrIPRelDervationJob_CMArrIpRel_Derivation_Tfp"
node_db2bode is Server2 in config file.
It is trying to put one transformer process one Server2 which is not the part of default pool, it is in different pool called 'db2'. Why is it still trying to load one transformer process on this Server2, ideally accorirding to config, it should not put this transformer process on db2 server.