Using a DB2 Enterprise and a Xfm in the same Job.

srikanthd1978 · Post by **srikanthd1978** » Thu Jul 21, 2005 1:51 pm

people,

I have a job that uses DB2 enterprise to pull data from a table and then i have a transformer that does some manipulation of this data.

When i run the JOb the Job completes successfully but i get the follwoing warnings:

Warning: The following libraries failed to load "V0S145_testXfmCheckFree_Transformer_145": Could not load "V0S145_testXfmCheckFree_Transformer_145": No such file or directory; for class "APT_TransformOperatorImplV0S145_testXfmCheckFree_Transformer_145"
Can anyone throw more light on these and explain.

Thanks

Kirtikumar · Post by **Kirtikumar** » Fri Jul 22, 2005 7:44 am

I am also getting similar kind of error!!!

Check this post.

The cause of this error may be the same as mentioned in the post.

Mat01 · Post by **Mat01** » Mon Mar 10, 2008 1:14 pm

Sorry... double posting

Mat01 · Post by **Mat01** » Mon Mar 10, 2008 1:16 pm

Hi guys,

After months of searching someone here found the solution to this problem. If you are on a MPP system you need to set the following env variable to true.

Code: Select all

$APT_COPY_TRANSFORM_OPERATOR = TRUE

To quote the manual:

Transform Library
If you are working on a non-NFS MPP system you need to set the
APT_COPY_TRANSFORM_OPERATOR to true in order to enable
Transformer stages to work in this environment. DataStage users must
have the appropriate privileges to create project directory paths on all the
remote nodes at runtime. APT_COPY_TRANSFORM_OPERATOR is set
false by default.

Regards,

Mat

ray.wurlod · Post by **ray.wurlod** » Mon Mar 10, 2008 4:05 pm

Time to mark the thread as Resolved, then?