DSXchange

I have seen this, the oracle 'ELF' error is due to loading the 64bit oracle libraries. DataStage must use the oracle 32 bit libraries.

tonystark622 has the right answer.

Are you running the same OS and OS version on both boxes?

Does your job design contain Custom Stages?

Does your Job contain the PX Transformer Stage?

Check the stage properties (input and output) I suspect there is a Blank 'Property "key" box to fill in. I don't think the 'Key' tick box on the columns grid is used to find the key lookup columns.

As the job seems to start running and then fail, perhaps there is an item of data in the source table that is causing the problem?

I can't reproduce that with what I have tried.

What canvas/Stages are you using?
What Server platform are you connecting to?

Have you run all the setup steps in the plug-in guide?
(Setting up the Environment etc ...)
Oh and don't forget that when you add Env info to the dsenv file you need to re-start the DataStage service.

How many nodes the job will run on is dependent on the job design and the amount of data/specification of hardware. Although certain stages will only run in sequential mode however many nodes are specified on the config_file.

If you don't use Job parameters then these values will always be fixed and won't change. Have a search, I'm sure there will be a thread on writing job parameters to file ...

A PX routine is a library/object file used by DataStage not an external program. These don't use 'main', you call the function directly.

You will have to post more detail about the job, what stages you are using and what the job is trying to do.

I guess you are using a Parallel Job with a Transformer stage. One point is that SU1 and SU2 must be the same OS version. You may have to check that the Job is compiled and ready to run before export. Also check that the user who runs the job has permissions over files that are generated by the pers...

I expect you need to set the MAP that is being used to read from the database and the MAP used to write to the Text File.

where have you used UTF8 NLS ?

Try adding the oracle client info into your environment as per the PX Oracle docs

check the docs ... You will have to have given the oracle client install directory when installing DataStage on the Unix box. Then there are a few things you need to set in you environment about the oracle clients you have installed on the server i.e Add ORACLE_HOME/lib to SHLIB_PATH Add ORACLE_HOME...

Windows 2003 Server uses different security policies to other Windows platforms. In order to allow access to a DataStage server on this platform, additional setup steps are required. This is taken from a newer version than 6.0, Perhaps these will be the same ... Could you could ask you Ascential co...