Performance Issues for Job Run.

vvsaucse · Post by **vvsaucse** » Thu Sep 09, 2010 7:35 am

Hi,

I am trying to run a job in DS 8.1 Parallel edition which extracts data from DB2 table and posts the data to a Transformer stage. The job has multiple tables as sources and is taking a very long time to execute. The job log has the below message.
Please help me out whether this has some access privilege issues or what this message actually means?

"node_huxp0202: Warning: library "V0S285_EXTRACT_I020_SP_HDW_xfm_sp_data" (for class "APT_TransformOperatorImplV0S285_EXTRACT_I020_SP_HDW_xfm_sp_data") failed to load: Could not load "V0S285_EXTRACT_I020_SP_HDW_xfm_sp_data": Permission denied."

ArndW · Post by **ArndW** » Thu Sep 09, 2010 9:18 am

Your transform stage "EXTRACT_I020_SP_HDW_xfm_sp_data" is having trouble running. Can you try to do a force-compile of your job and see if that either fixes the issue or gives you an error message?

ray.wurlod · Post by **ray.wurlod** » Thu Sep 09, 2010 4:58 pm

Was the job compiled by you or someone else? Check the permissions on the named object.

vvsaucse · Post by **vvsaucse** » Fri Sep 10, 2010 6:53 am

Hi Ray,

The job was compiled and now being executed using DSADM. I assume its having all the necessary privileges being the admin

chulett · Post by **chulett** » Fri Sep 10, 2010 6:56 am

Have you tried the suggested force compile?

vvsaucse · Post by **vvsaucse** » Fri Sep 10, 2010 6:59 am

Unfortunately, The env(Server) in which the job exists doesnt' have a C++ compiler for transformers and we dont have access privileges to import/export the job again. Is there any other alternative?

chulett · Post by **chulett** » Fri Sep 10, 2010 7:03 am

Someone must have those privledges, can you not have them take care of this for you? Also curious if you can actually check the privledges on those objects rather than assume everything is ok.