DSXchange

was deadlocked on lock resources with another process and has been chosen as the deadlock victim . Rerun the transaction.

What happens when you rerun? still the same error?

Hmm. Warning can be handled. But is the value getting loaded correctly. i had the same problem and direct mapping did the trick.

Dont push. People post only when they have a suggestion. Are you changing the data type to "Float" in DataStage? Did you try a direct mapping from Double to float?

You have a duplicate field name. Probably in the place where u are joining. Click on "Show Error" button on the compile dialog box to see which stage is giving this error. Or switch on the "Stage validation errors" in the menu.

See if this post helps.

viewtopic.php?t=113640

you would ahve to explain your job design before anyone can suggest a solution. Are you using a schema file to specify meta data? Doing any conversions to decimal? you have missed giving the precision for a decimal field somewhere in your job.

On the input link to your DB2/UDB stage, Hash partition the data on all key fields.

Use DecimaltoDecimal conversion. rtype I think is 'round_' something. Search the parallel job developers guide on 'rtype'.

Do a search on "Compiler "cl" not found". it is a problem with C++ compiler installation or with the environmental variables.

There are options in Oracle Enterprise stage called "Open Command" and "Close Command" for implementing this.

Changing the length from 20 to 16 might truncate the data in the field. And also logs a warning. Better option would be to change the length of your main link field to 20 from 16.

Not sure how to specify a hex character as a delimiter in the sequential file stage. But probably you can change the character to a coma or any other character using unix command in external source stage. See if this post helps.

viewtopic.php?t=113640

Do a search on "Subprocess command failed with exit status 256" and see if one of the posts help. Also looking at the error "Output from subprocess: Compiler "cl" not found" maybe the C++ compiler is not installed correctly or the environmental variables related to it a...

Are we supposed to guess the problem you are facing in parallel jobs?

Add the environment variable "APT_DISABLE_COMBINATION" and set the value to "TRUE" in your job. Run the job and copy paste the error message here.