DSXchange

"Unit Testing" is common to most software and not specific to DataStage. Recent years have seen great leaps in the methods used to ensure software quality and it is sometimes hard to keep up with trends. I use "extreme programming" as an example - for me it sounds like a TV show pitting computer pro...

One possibility is that your system is overloaded and the last one takes so long to initiate thatis causes a timeout. If you monitor your system load using your favorite monitoring tool (such as vmstat) while this sequence runs does the system begin to page or swap and what is the CPU load?

You cannot do this. The DataStage clients don't go through "sessions" as such, but use a number of ports to communicate with listeners on the other side. Perhaps if you use tunneling and open up a telnet session you can open up these ports and use DataStage.

Have you looked into "restartability" in Job Sequences yet, that would seem to be what you are looking for.

Craig - Ack, I was wrong, missed that!

The "sed" and "cxx" commands cannot be found. Have you changed your environment settings on your windows server? What do you mean with All of sudden it is not showing compiler options in Admin ? If you create a new project and look into the administrator settings do you see the appropriate compiler ...

Do you have fixed-length CHAR fields? Check to see that your metadata definitions in the job match the actual data exactly, otherwise you will get warnings or errors such as what you have already seen.

If you click this item then the greyed out "Options" button becomes active and will let you change the hashed file attributes from the default. If this option is not specified and the file doesn't exist, then you will get an error.

Are you certain that the "dsenv" file doesn't call a script? If you source this file using ". ./dsenv" from a login session what setting do you get for the ORA_NLS33 environment variable?

Jobs are not reset automatically after an abort. In Job Seuqences, when you call a job using the Job Activity you can specify that the job is "reset if required, then run".

Perhaps someone else might help; I believe that the price of membership is low copmared to the value received.

You can work with DSSetUserStatus() and DSGetUserStatus(). In PX jobs they can be set as part of the before/after job routines.

Oracle DATEs are actually timestamps, so keep the timestamp definition.

No in the job, but you can always shell out to the OS and use regular expressions and functions there.

While the approach might be correct, I am not certain that your measurements are. Did you separate these stages into their own jobs with no other links and check the timing? If not, then your results are likely skewed since timings in jobs usually depend on other stages and often you just end up mea...