DSXchange

Both ACCOUNT_ID columns will need to be of the same data type and length. The data will need to be partitioned and sorted into the join stage (by the same key column). The framework can do pretty well when set to Auto (if keys etc... are defined properly), but it might be better to do it in the join...

John, I might have IBM support focus on the dsdlockd process. This can cause hangs like what you are experiencing. This may not be your issue, but worth the time to investigate. We had this very issue and was related to the ownership of the dsdlockd process. We are Unix, but maybe this is a Windows ...

Bill, If you would like a datastage job (template) that can be used for change data capture then please pm me and I would be happy to send it to you. There is nothing proprietary in how this is accomplished using the parallel construct. It is different than what we used to do in the server world, bu...

mike - I'm a bit chagrined by your response since the FAQ that I wrote explains exactly how to locate such orphaned files. ... I guess if I paid the premium membership I would have seen your response and not responded in the first place :lol: Sorry to trump your answer - did not mean too. And Craig...

Ray,

I get it :D

This can be a problem and I have asked one of the framework developers at IBM if there is a way to find orphaned resource data.

I will let you know what I hear.

That would likely mean the jobmonapp is not running. Check by executing the following -
If it is not running then you can start it by navigating to $PXHOME/java and executing -
This takes care of both the resource tracker and px job monitor app.

disable combination and see what operator is throwing the error. You can do some things to disable the framework from checking memory before allocating which may silence this error, but generally these things come from the player level.

I believe you are approaching this incorrectly. You should not attempt to automate the cleanup / purge by identifying the dataset header and then identifying the dataset data partitions, rather you should identify the headers and then use the tools (orchadmin) to handle the cleanup/archive/purge. Th...

That is the default behavior when going from a nullable input to a not nullable output and the input value is null.

Same in the lookup, merge etc...

Has nothing to do with your sequential stage.

"tfmProfitMeas2: Input dataset 0 has a partitioning method other than entire specified; disabling memory sharing." I think this is simply alerting you to the fact that you have not chosen Entire partitioning so memory sharing will be disabled. This is standard since with Entire memory sha...

Create a routine and use the following code - Handles numbers of any size. Snippet #include <iostream> #include <string> using namespace std; // Non-recursive method of adding commas to numbers as C++ strings ... // s is string passed in, ns is new string returned by ref. with commas inserted void a...

Within the DB2 Connector - click on the reject link to get to the properties. Next make sure that both "SQL Error" and "Row not updated" are checked. These are the two (2) options on the left. On the right choose what you want in your output - "ERRORCODE" and/or "E...

You might be able to use xml?

Have you verified in Unix that the 2 files are the same? Here are some things that I try when stuff like this happens - Change to a single node configuration (take partitioning out of the equation) Ensure that column types are the same that are being compared If using seq files and the expected resu...

In the administrator client what is the value of the environment variable APT_STRING_PADCHAR? If it is 0x0 then you can have this type of behavior. Set it to 0x20