DSXchange

A Search will turn up an answer to this question.

Umm... is the Schedule service running?

Welcome aboard.

When reporting problems you must also post the exact error message. We don't want to waste time guessing.

Please confirm that all required services (AppServer, ASBNode and engine) are running.

"Not enough space" may be in the process table rather than disk, but it's usually disk. Checking afterwards does not prove anything, as the section leader or conductor processes clean up any files from scratchdisk. You need to monitor scratch disk closely while the "faulty" jobs ...

Teradata Hybrid Information System ?

No, using the Copy stage as a sink is good practice - it "eats" (discards) records from its input.

Without beng able to check today (away from DataStage installation), may I ask whether your Teradata MultiLoad stage supports "Open" or "Before" SQL and, if so, whether you've tried to execute the CREATE VOLATILE TABLE statement there? It should be the same session as the main bo...

DSXchange is not a mobile phone - there is no need to use SMS-style abbreviations. We strive for a professional standard of written English on DSXchange, to make life easier for those whose first language is not English. In particular, the second person personal pronoun is spelled "your",...

You don't, unless the logs are directed to the local DataStage repository. Currently your logs are being directed to the unified metadata respository (sometimes called XMETA). To have your logs directed to the local DataStage respository you need to edit the DSParams file in the project, and toggle ...

If the output is a Date (or Timestamp) field it ought not to matter. These are stored internally in binary form (five bytes for date, nine for timestamp). If the output is a string, then you can use a format string to specify the number of decimal places in the fractional seconds component, for exam...

First piece of advice is to learn patience. If you need a response in less than one hour, sign up with your support provider for priority service and learn how much "urgent" actually costs. Note that for severity 1 problems (site down) IBM only promises two hour turn around to first respon...

Souji wrote:I am replacing server job with Parallel job.

Why?

If it's not broken, don't fix it. Server jobs will be supported by IBM into the long term future.

If your data volume is low, then you might implement a sparse lookup using user-defined SQL of the form you posted. Otherwise create a query that returns the maximum for each prog and institution (group by these columns) and use a regular lookup. That query will be loaded into a virtual data set aga...

Presumably you're also using the supported C++ compiler for your platform. It does matter.