DSXchange

Partition your data by ID using a key-based partitioning algorithm (Hash).

Take some time to learn about partitioning.

What's the bet that this file was created on a Windows system and lines are terminated with CRLF? Try changing format to use Record Delimiter String property set to "DOS style".

There is a couple of settings. You can also configure that the range of numbers is 0..6.

Yes, you can build project-related directories into the package, though there is a limitation that the directory must be a sub-directory of the project directory. Go into the Help for Information Server Manager, choose Overview of Deployment topic, choose Defining the Deployment Package, scroll down...

Of course that query will initialize the ID sequence to 1, not to 0. But otherwise it should be OK. You need to query (via the routine) to get the next value even after initialization.

Is it now working? If so please mark the thread as resolved.

Certainly. One workaround is to run on more powerful hardware. Simply adding more processing nodes (on other machines) may suffice.

I can not get my car to start. Please help out get this resolved. Clearly you have not provided nearly enough information, and no-one here is going to waste time guessing what you might have done. Specify how you have configured DB2 connectivity, and how you have set the properties in the stage. Usu...

A PL/SQL script.

... and what does "doesn't work" mean in this context? For example, if $DSHOME was not set you might get a "command not found" error.

Is your job monitor running?

I did wonder. XRP is the output format (well, file name suffix) for RationalPlan. I was wondering why you'd want to be processing project planning diagrams using an ETL tool.

Make sure your data are partitioned by id using a key-based partitioning algorithm (modulus or hash).

Is Transaction Size set the same in both environments? Transaction Size = 0 in TEST may cause the symptom you describe. What is the Array Size in each environment?

Same answer as in 8.5. In the SCD stage some columns can be identified for Type 1 changes and other columns can be identified for Type 2 changes, even in the same data set.

Code 11 (signal 11) is a SIGSEGV, or segmentation violation. Looks like you've had a memory issue.