DSXchange

Cool :D

Great news. I once added some cpu time to the SETI project and thought it was a great idea, but this is more productive. The software is small and does a good job of using up the CPU, but at least it does slow down when anything else is going on. It would be nice to get a DataStage group together th...

kool_cons,

your illegal (unless your middle name is Croesius) copy is not installing because you aren't using the NTFS file system, which is a pre-requisite for DataStage. DataStageCnu has pointed this out already.

You have more rows coming out of your Transform stage than you have going in. What are you doing in this stage? Are any of the two fields you add part of the sort key/order?

Craig, thanks for that - I ended up actually doing the RTFM thing and saw what you had said; I remebered that not supplying any parameter did something, but just assumed that @NULL would equate to some value which would generate repeatable sequences. I wonder if the time unit is seconds or milliseco...

Put the job activity between your start and end and also make sure that the instance name includes the name of the file to process so that they are unique, and then make sure the job activity doesn't wait for job completion and you will have things running in parallel.

Instead of using your spare PC CPU cycles in generating 3 dimension backgrounds that wander across the screen or create some virtual fishtank, I'd like to recommend looking at the world community grid pages and perhaps installing their grid client on your PC. Several computing projects run concurren...

I responded to the other post before replying here. A random number generate is never random, it is pseudo-random. The algorithm distribute elements in the series as randomly as possible across the available range of numbers. But in order to be used for prediction purposes it needs to be repeatable ...

Using RANDOMIZE(@NULL) will not do what you expect. You should use a seed to ensure the beginning position in your random number sequence is as random as possible, and @NULL will always return the same series. I usually seed a random series with @DATE+@TIME+@USERNO and this will get a different numb...

Was that a question or an assertion? I'm not quite sure what you mean.

I would do it with either the ICONV & OCONV combination or substrings; both will work efficiently and accurately. If your input data is always correct in the format yyyymmddhhmiss+nano sec and your output is in the form dd/mm/yyy hh.mm.ss.mmmm then your derivation would start off with the date p...

Veni,

what have you tried to do so far that didn't work?

With that small number of stages and a 4-node configuration you won't have too many jobs flooding the system, even if you have partitioned DB/2 tables and are using the enterprise partitioning. A SIGSEGV after an appreciable runtime is either being triggered by a combination of data values or by som...

A segmentation violation is most often caused by bad pointer addresses in a program - either trying to write to a null pointer address or trying to read/write a protected address. You are seeing this happen sporadically, so it is either due to your data contents or to a system resource restriction. ...

ravij, there is no direct answer to some of the questions you posed, as it really does depend on your system, it's configuration and the uses you want to put the system to. The number of nodes defined in a PX configuration file does not bear any relationship to the number of physical processors that...