DSXchange

If you referring to over writing the created file during other flows, you have a option to re write it after clearing and etc., If you referring to Memory overflow when loaded into Physical memory, it is again depends on your input data size and available memory size. If you are referring to running...

Dual core might take up two CPU license, watch out.

No. But you can get these information from the Report generated from GUI.

Users with operator role should be able to import and run the jobs.

Have you tried running the job using dsadm (If at all its possible)?

Try limiting the number of input rows based on ROWNUBMER from DB2 table. And check if thats by any chance due to large data stream flow into funnel stage.

How are you effectively using lookup stage. Bare in mind that the data will be lookup the reference for each record input stream. Finding max after doing all lookup wont be much effective. Isolating this functionality and passing it as parameter might cause less overhead.

If you are in the phase of defining the standards, let it be this way. All your rejected records with error code be captured and stored in Error Table. And Log table shall have the Start / End timestamp, no of records that been rejected/processed based on each stage. Now you can determine which to p...

I still doubt, whether SELECT DISTINCT FROM TABLE will give out records without any syntax error.

By the way, why you need that show up statistics? Are you using LinkRowcount of that link?
Have you tried the option that available in Copy stage to force the operator?

Btw; What is the version of your DS. Where the DS.TOOLS doesn't have Check Integrity of Job files.

Are you using dsadm for all the time. Try running the job, where your RT_BP806.O will be modified. You can have another chance. What happens if you Export and import the same file (without any rename). It should overwrite all these file, provided if it has permission.

Combination of operators are decided by DSEngine. Try to include $APT_DISABLE_COMBINATION variable in job level or in Advance tab in transformer, where you can see combinality mode with Auto, Combinable, Don't Combine option. Try selecting selecting Don't combine. But this is just to check. Its not ...

I got 18 hits for Key work SIGINT. It has been covered previously.
SIGINT is a Interrupt signal thrown during the process. It can be even due to SIGKILL (Kill Signal). It is most likely due to short fall in availability of resource.

"Heap allocation failed" will be your right context to search.
Basically its due to Temp space been occupied by the Sort or Aggregation. Whats your Job desing?