DSXchange

We don't actually know the volumes of data that U is processing. We haven't heard from U for some while and even then no details were vouchsafed as to data volumes.

step = job

There is a SIGBUS error reported in the error message, why are you claiming a SIGINT ?

SIGBUS may indicate that the reference input Data Set is too large for the Lookup stage. There are other possibilities, but that's where I'd be looking first.

Modify stage does not support job parameters. You would need to use (for example) a Column Generator stage upstream of the Modify stage to get the value onto the Modify stage's input stream.

Modify stage functions only support fields (indeed, only one field) from the input as main arguments.

Every job is an object. Every stage is an object. Every link end is an object. Every annotation is an object. Every container is an object. Every table definition is an object. Every routine is an object. And so on. Objects can contain other objects, or even collections of other objects. For example...

Senator Clinton isn't giving up - why should I?

I happen to believe it's important.

Welcome aboard. Sometimes the best optimization is not to be found within one job but in the balance of jobs that you are running at the same time. Investigate which jobs are independent of each other and run these in parallel. In combination with inter-process row buffering in jobs that have more t...

As many as you like. They have visibility in the DataStage Designer.

Probably. You would need to obtain an ODBC driver (presumably from GreenPlum themselves) that is capable of managing their parallel access functionality. You could also write text files, and have their parallel bulk loader do the heavy lifting. And you could, of course, write your own custom stage (...

What values do you have for the Admin Action and the Block Size properties of the SCD stage?

Search the forum for knowledge about what a segmentation fault is. Then extract all available information from the error messages, disabling operator combination in order to be more precise. Only then would you or anyone else have any clue as to the probably cause of the segmentation violation and c...

U (one of DSXchange's members) has not participated in this thread. Why are you giving advice to U?

The second person personal pronoun in English is spelled "you". We prefer a professional standard of written English at DSXchange.

Unless, of course, you make the increment something like the number of partitions.

And it will still not run in parallel.

Describe the failing job design. In particular are you doing anything to the data upstream of the Pivot stage?

Anyone who knows how to use the Search facility in DSXchange could answer that question, as it's been asked before.

But why not search for yourself?