DSXchange

The director refresh speed has always been the Achilles Heel in DataStage since version 0.0.0 Adding categories and putting jobs in them as well as filtering the entries displayed help refresh speeds. Cleaning up log files also helps. How many jobs (and instances of the jobs) do you have in the view...

the command "dsjob -jobinfo {project} {job}" will give several lines of output, grep for "Job Start Time"

In the transform, the column "lookup.SOURCE_DESC" should be marked as a KEY field and the value of "source.SOURCE_ID" should be in the key expression.

At version 8 the online help states Preserves Sort Order Select this if you know that the rows being input to the Transformer stage have been sorted and you want to preserve the sort order. and neither the Parallel Job Developer Guide nor the Parallel Job Advanced Developer Guide mention it.

Judy,

what are you trying to do? Do you want n-output rows or 1 output row per input row on your lookups?

Unless you are running 7.5x2 you won't be able to run PX jobs. You need to have the correct c++ compiler installed and configured on your Windows machine, which is why samsuf2002 asked about it.

No problem. In that case, perhaps you could mark this thread as resolved.

Server and Parallel might share a common graphical user front-end but they are (and will always be) separate and different products. Code written in one will not work in the other and the jop design approach is different in both products. The Server product and the underlying PICK-based "DS Engine" ...

The @DATE and @TIME mnemonics use the start time of the program or job. In oder to get the changing values, use DATE() and TIME() instead.

Hello and welcome to DSXchange, DSDV78.

Although the transform stage contains the reject link in server jobs, in PX/EE jobs this is done as an output link in the passive stage and setting the appropriate stage attribute.

Are you saying that you are getting "1" but wish to output "0001"? The generator is creating a number which never has leading spaces. There are many ways to create a string like this, one way would be to use the derivation "RIGHT('0000':DecimalToString(In.SequenceColumn),4)"

What is a multiple repository?

If your client supposes that PX sort is faster than CoSort, then using CoSort's published benchmark figures would most likely just add fuel to the fire. I would try to compare the sort and run times for as much data as your current configuration can handle; that way you can choose the complexity and...

Would you be able to get someone with root login to try logging into DataStage at your workstation and test the runtime limit? Also, could you try the following from UNIX cd $DSHOME . ./dsenv bin/dssh {This will put you into the DS shell} SH -c "ulimit -a" QUIT {This will br...

If you have root access try to run your job and see what the ulimit settings display. Also, if you execute ". $DSHOME/dsenv" as dsadm do the ulimit settings remain the same before & after the command? Known Facts ======== 1. root user has unlimited ulimit 2. dsadm user has unlimited ulimit 3. $D...