DSXchange

Range lookups in transform stages don't exist in server, which is why Ray suggested you implement it in SQL.

Did this change happen after re-compilation of the job and does it still work correctly or incorrectly? What are your input columns (:2 would mean 2nd input column, perhaps that no longer exists).

In the upper left hand picture, click on the stage and not the link, then you can choose sequential execution mode.

I'm not sure if the OP stated that the file is actually present there or elsewhere on their system.

You can use the SEQ() or UNISEQ() function to get the numeric equivalent of a single character, that might help you debug your problem.

Add a reject output to your DB2 stage and you will see the rejected rows as well as their SQL error codes.

It is very hard to generalize performance impact. If your system were IO bound then adding complexity to transform or modify stages would make no difference in throughput. In this case the system was CPU bound and thus adding NullToValue() did make an impact. Perhaps reducing the number of processin...

You can declare your MQ stage to run sequentially, that way the APT_CONFIG_FILE setting doesn't apply. Downstream you can then repartation to your heart's content.

Is this a server or a parallel job and, if it is a parallel job, can it be made into a server job or use a BASIC transform stage - in which case the EREPLACE(YourString,"'","''") function would work for you. If the number of single quotes is limited to one or two, then you can us...

Normally jobs will abort because their startup time is too long and this is due to the system becoming overloaded by too many concurrent process. If all of your jobs are sequential then you have some other issue. You should post the exact error message once you reproduce the problem.

I would start at the "other" end - instead of trying to run all these jobs as quickly as possible with as much parallelism as possible, I would ask "how much time will I have to do this processing?". The answer to that question might mean that you can design your top-level master...

I would concur with support - don't touch this setting unless you need to, and you have other options such as setting job-level NLS attributes.

What does "dsjob -jobstatus DMDev RECON_STG1_2_STG2" return?

This is rather confusing. Did using TRIM() work or did it not? If it did, then as Sainath has stated, you have or have had a CHAR() somewhere along the line and the conversion from Char to VarChar does not trim fields but leaves trailing blanks.

The NLS_LANG only applies to Oracle and did you do a uvregen after making the changes to your uvconfig file? You can check the date/time modified of the hidden ".uvconfig" file in the same directory to see if the uvregen was done. Why don't you specify a job-level locale definition for the...