DSXchange

Yes, but the error message is now precise about where the error is occurring. Can you post the detail of the first and second error or warning messages?

Provided the numbers are at least as large as those in the documentation you received with the software, and provided that there are no other significant consumers of shared memory, semaphore or message queues (that is, DataStage server is the principal application on the machine), then the numbers ...

It's just something I've noticed over the years. Decimal[N,N] should be able to represent numbers between zero and less than 1.0, theoretically, but it seems that some implementations need to be able to specify that there is a digit to the left of the decimal place holder.

That looks OK. The error message did specify " temporarily unavailable" - it is likely that some system-wide limit was encountered, rather than a user-specific limit set by ulimit. You need to get your UNIX System Administrator involved if it happens again. Ideally, you need to be able to reproduce ...

Startup time is substantially greater for parallel jobs than for server jobs. Therefore to do a small run, a server job is probably going to start, and therefore finish, faster. And to process a single row (such as obtaining the next surrogate key value), a parallel job is definitely disadvantageous...

Where are the lists once you've retrieved them from Oracle? If you write the lists of keys into two files in the &SAVEDLISTS& directory (using Sequential File stage), then you can use the LIST.DIFF command to ascertain the difference.

Umm... you don't use ODBC stage type to access hashed files. You can use UV stage if you want to use SQL, or you can use a Hashed File stage. The easiest mechanism to clear the hashed file is to use a before-stage subroutine in the Transformer stage (this is executed prior to any inputs being opened...

The assertion "performance wise parallel will be faster" is not necessarily true, particularly for small jobs.

Why not enrol on the Server to Parallel Transition Lab offered by DCS (the company that hosts this site)? This class spends three days examining the differences.

How precisely have you specified your Trim() function?

Awaiting YOUR answer to my question that will guide my answer.

No but you can. Add a call to DSExecute() to invoke ulimit -a and write the result into an informational log entry. This will let you see all the resource limits to which the DataStage process is subject.

Of course, if you have DataStage 7.5 or later, you can have Director on your PDA.

You can not easily move a project. But you CAN easily create a new project in the new location. So you can export the old project, delete the old project, create the new project and import into the new project from the export file. If you don't need exactly the same project names, you can import the...

Just to back up what Arnd said, there is no point using benchmark information other than for your own ETL jobs. No-one else does precisely what you do with your data. Using an IBM test center, or borrowing a machine on which to conduct some benchmarks, is a good plan.

And if that doesn't work try reverting to the 9i client.