DSXchange

Welcome aboard. DataStage acts as a client to the database server. Therefore, if the database server permits Cartesian products, then DataStage can request them. Let's see, 10 million x 23 million; that's 230 million million rows in the cross join. OF COURSE it's going to take a long time! You'll pr...

What proof can you provide that "re-indexing has not worked"?

<rant>That is really poor advice, particularly from someone from IBM. The poster seeks technical knowledge as to a cause; you are advocating suppressing a symptom. </rant> Have you (dohertys) tested the same conditions with user-defined SQL that is identical to the generated SQL? Clearly the interac...

Privileges issue in the XMETA database, perchance? I would not think so, because this is only accessed through the services, but it's worth checking.

Yes, and you have a value for PATH. That and LD_LIBRARY_PATH are fundamental to most applications, not just TX. There will be default values for both MERC_HOME_DIR and MERC_TEMP_DIR if they are not set; you can doubtless find out what they are from the manuals (I am in an airport lounge without acce...

If it's truly urgent sign up with your support provider for premium service, and learn how much "urgent" really costs. DSXchange is an all-volunteer site, people post as and when they can, and get really offended when you do things like demand a response twice within 30 minutes after you post. What...

What else are the Transformer stages doing? Do you have inter-process row buffering enabled? When you watch this job in the Monitor, how much CPU is each Transformer stage using? Are they operating in one process or in separate processes?

Welcome aboard. You appear to have answered your own question.

Whether that answer generalizes to all things that you might wish to do with TX is another question entirely.

Include "automatically handle activities that fail" in the child job sequences so that they can achieve an Aborted state. If you have explicit failure handling, either through Failure triggers or through an Exception Handler, make sure that each of these also causes the child job sequence to abort (...

Welcome aboard. Construct an expression that takes the partition number and number of partitions into account, for example initialize a counter (stage variable) to the partition number and increment it by the number of partitions. All counters begin at zero; you may wish to add one to your initializ...

Create your job as multi-instance (it's a single check box). Then you can run multiple clones at the same time, giving each a unique invocation ID. You can control for the entire 40,000 files using a loop in a job sequence. This shows three at a time but, if you have the processing power, you can sc...

Windows XP (Professional or otherwise) is not a supported platform for DataStage server.

It is not possible in a Modify stage. You need to use a Transformer stage or a Build stage.

You only have one "alternative" stated. Therefore it will perform best.

I don't know. You don't need admin rights specifically, but you do need write permission (obviously) to all objects in the Repository. So I would suspect you're OK - just be very sure you have exclusive access (no non-Administrator clients open, not even yours).