DSXchange

Larger data volumes? That it "ran OK on the four CPU box" suggests that, if nothing else has changed, then either a larger data volume is the cause, or that other things were occurring at the same time on the eight CPU box. You need to check both. Unfortunately, you have destroyed all the evidence (...

DSGetLinkInfo() returns accurate counts, totalled over all partitions if the DSJ.LINKROWCOUNT argument is used, or individually (as a comma-delimited list) if the DSJ.INSTROWCOUNT argument is used. (These from memory, please check.) The latter is useful to determine the effects of re-partitioning.

The crux of the problem is in this event.

Notice: The Early Access serial number will expire in -7 days.
In order to purchase the product, visit http://www.sun.com/forte/buy.html
or contact your Forte Tools reseller.

Your compiler licence "free period" appears to have expired. Contact Sun for a replacement.

Not necessarily. The pseudo-map NONE may work better.

Surely you mean

That means that there's something wrong with either the connection information or the authentication information, the way the database client software is configured, or possibly that the database server is not accessible or unavailable. You will need to do the detective work. It is not possible from...

Do you have Enterprise Edition? There are better tools in parallel jobs. In a server job, you're up for a lot of stage variables and hand-coding.

I posted an answer (a job design) to this very question earlier today.

Error code: 2 2 usually means that you have not licensed the product or that your licence has expired. Under these conditions the engine will still start, but will not be useable. A good way to verify that this is the case is to attempt to establish a telnet connection and enter the DataStage envir...

Look in the log, to see whether there are 89 warnings. Check the Transformer stage, to ensure that there is no constraint expression preventing rows from being forwarded to the target. 0 rows/sec means that the stage finished in less than 0.5 seconds. Seconds are rounded to integer, and divide-by-ze...

Could the hang be occurring in your email software (SMTP client) rather than in DataStage? Can you try to send mail from the DOS command line, to see whether the same problem occurs?

Enable write cache when (re-)populating your hashed file. It makes a notable difference.

Syntactic validation (which can be done) is not the same thing as certification (which, as far as I am aware, can only be done by trial and error, and still requires the destination mail server to be up). There is nothing in DataStage or QualityStage for performing email address certification. Does ...

The following design will help. HashedFileStage1 and HashedFileStage2 refer to the same hashed file. HashedFileStage1 HashedFileStage2 | ^ | |(not found) V | -----> TransformerStage ------------> SequentialFile (found) The hashed file will contain the first occurrence of each key val...

Invent a name for the sequence of unique numbers, and use one of the key management (get next value) routines from a Routine activity in the controlling job sequence.