DSXchange

How long does the tar command take by itself?

How long does it take to load a Data Set with a comparable number of generated rows?

Sequences NEVER run in parallel; indeed a sequence is a special case of a server job. Why is there a Sequencer in your sequence? Does removing it make any difference? Execute Command is synchronous (the sequence waits till the command finishes). The way around this is to start background processes u...

Why this insistence on "without using Transformer stage"?

Not only that, but a question that has been asked at least once in the past. Clearly dr.murthy's Search button doesn't work! Of course, meaningful subject likes like "logic required" don't really help future searchers. May as well be brutally honest, and just specify "Gimme" as t...

Let's wait for Ashok before leaping to any conclusions.

Ashok, what previous DataStage experience do you have, and in what sector?

qt_ky wrote:"Throwing up" is an unusual verb to use with an error message.

It's a Texan thang.

No.

You'll need a licence for the SAP R3 PACK.

I don't think there is one in parallel jobs. In the Data Rules stage you can employ a "matches regex" rule, but it doesn't effect a replacement. It might be possible in a BASIC Transformer stage using some combination of Matches and nested Convert() functions, but I have not given that a g...

Search for "vertical pivot" and adapt one of the techniques.

Get the partitioning right and it WILL work properly in parallel. A sequential stage in a parallel job will always be a bottleneck.

Bulk loading is non-transactional, so that COMMIT is not relevant. But the ODBC Enterprise stage also allows you to use Upsert method. Then transactions are relevant, and the number of rows per transaction can be controlled either by an environment variable or by a stage property that becomes enable...

What's wrong with the descriptions in the manuals?

Do you mean "environment variables"?

See reply to your other post. Lesson 3 is that we expect a professional standard of written English on DSXchange. In particular, we use "please" not "plz" and "you" rather than "u". We prefer the capital "I" for the first person personal pronoun. DSX...

Patch JR41793 applies. It allows what IBM is choosing to call "fine grained workflow publishing", which is described in this tech note.

It will be a little while (bureaucratic hurdles) before I can get this patch installed, but I have high hopes of it.