DSXchange

Display is for Server jobs to control the length of the field while suing view data. As I asked you earliar, could you let me know whether its Multiple reader per node.

I might be hijacking the thread now. But Iam designing one such job with Database lookup. Large volume with 4 keys. For lookup purpose, Iam going to unload only the new created artificial key. I felt its saving space as well as more efficient. Hence going for synthetic key. Would you recommend that.

That post was for OP. And I was referring to this.

Hope the value of Start = 1.
You can try to execute $DSHOME/bin/dsdlockd -p with super user to kill the dead locks.
You can as well reduce the timer. Else you can find the left out process and kill using Kill command or from DS.TOOLS.

Wont it be simple to find the file name and row num directly using RowNumberColumn in addition to FileNameColumn rather than, Pre processing all the files and find the file names back with the help of running nubmer.

Craig, though its not the right use of CRC32, wont it be efficient to follow that approach. Do you suspect the chance of repeatable value would cause some error.

Again for setting up the $ORACLE_HOME/lib, you should go up with the suggestion given by Ray in your other post.

When I read the file in parallel

Are you referring this to multiple readers per node? If so its not recommended for variable length delimited file. Its for fixed width files.

Smart way to start the diagnosis.

If Iam not wrong, the initial compile should be same as forced compile. And it will affect only the compiled codes.

Now I got what Ray mean to say. Hi point is on max number of concurrent process limit. But what I could guess is, what ever you see is from the log, that job B is waiting for the other to finish. May I know what makes to conclude that its waiting till the others getting finishes? Perhaps why can you...

DSguru2B - Should there be any configuration required in dsenv regarding the individual database home directory. When I look into Install and Upgrade Guide for odbc Configuration, the sample oracle configuration is given as # Oracle 8i ORACLE_HOME=/space/oracle8i ORAHOME=/space/oracle8i LD_LIBRARY_P...

The first 4 jobs start at the same time, and after each jobs has finished it will start the next job, each job have only one dependence it was the previous job, but we verify that the second line of jobs ( B, F, J and O) only start when the first jobs (A, E, I, N) has all finished. Not sure how Ray...

Its nothing wrong in searching again though.

But I have seen in some places, for some reason the shell scripts are called again in Datastage Job Sequence. I guess oacvb is part of that victim.