DSXchange

After the job aborts, reset it. There may then be an entry in your log with the title "From previous run..." containing additional information. There are many possible causes of abnormal termination, as a search on this Forum will reveal. Usually it's because you've tried to do something illegal, li...

Two questions. Have you tried compiling your job, or are you just asserting that it won't compile because the expression remains red? That the expression remains red is because the BitOr function does not exist in the DSParams file (on the server) from which the expression editor gets its list of fu...

Can you use a more complex SELECT statement to extract the rows in the first place? Something like: SELECT .... FROM tablename T1 WHERE T1.keycol IN (SELECT T2.keycol FROM tablename T2 WHERE T2.initialEntry = 0 AND T2.OriginalEntry > '03/20/2002' AND T1.keycol = T2.keycol)

It certainly does. Can you review the contents of your Constraints grid in the Transformer stage and post the contents of the rightmost column?

Try clicking on Help (or F1) when in the environment variables creation window. There's some useful information there. You can also try searching for APT_CONFIG in the Parallel Job Developer's Guide , the DataStage Manager Guide , and the DataStage Administrator Guide . However, the answer to your a...

This paper shows a technique for using a BAT file to determine the location of the DataStage Engine directory.

My experience has been that there's not much difference for SELECT (for most databases) between native API and ODBC, but that native API is much faster than ODBC when it comes to INSERT and UPDATE.

But, then, I even avoid the native API in this case, preferring bulk load wherever possible.

Just to clarify, Vince's point about using separate disks really means different drives (spindles). Different partitions that are slices on the same spindle don't result in any gain; indeed, they can result in contention and therefore reduced throughput. Four parallel streams all reading the same so...

openpath and openseq are undistinguishible uner the covers, notice I said openpseq and openseq. Are you sure? OpenPath can open Type 1/19 files. What does it mean if OpenSeq opens one of these? I just tested it (OpenSeq with a Type 19 file); it took the Else clause with a Status() of 0, even though...

Thanks, Johno. I was aware of the OpenSeq issues - it weren't me, guv! I used OpenPath (not OpenSeq), and opened the directory into COMMON. Others magically transmogrified my OpenPath into OpenSeq. No-one seems to have noticed. I suspect, indeed, that even that was unnecessary, since !GET.PATHNAME c...

How about a "generally accepted rule of thumb to everyone"? There's none that I know of. Theoretically the only upper limit is when the Aggregator stage runs out of allocable memory, but when that is depends on the individual operating system and on what else is happening (demanding memory) at the t...

If the incoming data are not sorted, or even if they are but you don't tell the Aggregator stage, then the Aggregator stage must keep the progressive set function results (sum, count, etc.) in little buckets in memory, one bucket for each combination of the grouping columns. The total size in memory...

You could be overloading the machine. How many CPUs are there? What is the basis for splitting the rows? Is this being done in a single Transformer stage? How complex are the business rules? Are the rows in the sequential file improbably large? There are no tunables for the Sequential File stage. Th...

The Aggregator stage doesn't sort data. It can use pre-sorted data, in order to apply a much more efficient aggregation paradigm, but does not do any sorting itself. That data sometimes appear to come out sorted is an artifact of the aggregation algorithm, and ought not to be relied upon (just like ...

Hi Can anyone give me a command to get a list of all jobs with their latest run start and end times for those jobs? I want to create a report in Excel to show the times for those jobs. Please help me. Thanks in advance. Don't need a command. Use the Director client. Choose Status view. Uncheck Show...