DSXchange

That means Java and while there are stages for it in DataStage, you'll still need to write the code the stage will run.

You've marked your post with an O/S of UNIX - is that actually the case? If so that would make it difficult for it to use the paths you've posted. And it also helps when you say something is "giving errors" to actually post those errors so we have some idea what is going on.

william.wang_GMA wrote:The way I understand is that the Sparse Lookup causes DataStage to connect to TD to fetch rows matching above condition. This helps reduce memory usage (smaller cache)

The cache isn't smaller in that case - there is no cache.

Can't help you on the Big Data question.

Out of curiosity - what was your actual resolution?

Please be more precise - we know you have fatal errors in the log but what's important to note here is the actual status of the job shown in the Director. Ray has already noted that the job may still end up in a "Finished (see log)" status rather than "Aborted" in that case. Also...

Via the Java Stages as Ernie notes here in his blog (one example).

Not sure how much anyone can help with a permissions problem - either you aren't trying to drop the table you think you are or you don't have the permissions you think you do - an you and your team are the only ones who can determine that. Double check. Triple check. Make no assumptions. I'm curious...

Right next to MX0C in the documentation is MX0B for a Binary conversion, which I'm sure is what Ray meant to reply with.

Sorry, I missed the distinction that Ray picked up on. I meant if your job actually fails, not simply if it has fatal errors in the log. You'd think one would lead to the other but as noted that's not always the case for some reason.

Not the best place to be making assumptions, it has to be specified correctly so any conversion can be made properly. And they probably recommended UTF-8 for the XML as that's the XML standard. Rather than continue to guess, why not simply ask them? That answer will go a long way towards getting you...

Well, then... what changed? Windows update? Other software installed? Are you running anti-virus software on the server? We've seen any one of those things take out a DataStage server on Windows installation.

What's the characterset of your source DB2 instance?

You didn't answer my question.

and now only i observed the same issue is coming for all jobs in dev environment That's an important piece of information. Does it matter what DB2 instance you try to connect to? If it doesn't then I'd suspect that something has gone awry with your DB2 configuration on the ETL server and I'd involv...

As noted, you should be getting a "3" for Fatal... if you are not, contact your official support provider.