DSXchange

"Look at the index" of a backup means read the media without actually restoring to disk. uvodbc.config is unrelated to the current issue. Does uvregen exist in the bin directory? Looks like uvconfig.20060308 might be a replaced version; might be worth making a copy of that as uvconfig if you can't f...

Not necessarily. By what other means can data get in to this DB2 table?

Code point D485 refers to a character encoded (Unicode?) but not present in the character map that your ODBC driver or DB2 database server is using.

Everything's bundled with 8.0, but remain separately licensed. That is, SOA edition will cost extra.

Nothing left to say then, is there? Maybe you could stop specifying column names longer than 18 characters and mark the thread as Resolved.

Define "performance". Rows/second is meaningless, as I've noted - and proven - on a number of occasions. Enterprise stages have innate parallel capability, and so would be the stage type of preference to communicate with XPS particularly. API stages are essentially the same stages you used in server...

In the Sequential File stage, you can set Drop On Import property for those columns you don't require.

The .uvconfig file only comes into play when DataStage is started. If DataStage is running you can delete .uvconfig - but you'll never be able to start DataStage again. Can you look at the index of an earlier backup to see whether it has .uvconfig, uvconfig and the bin directory? If so, you should b...

Is it possible that some of your data fields contain newline characters?

Did you try ?

Look at the "job starting" message in the job's job log to see the parameter values with which it was actually invoked.

It is not possible legally to set/change a job parameter within a job once that job has started. But one job could receive the value and use something like UtilityRunJob to run the real job, passing the received value as a parameter value to the real job.

You get it from your support provider.

No, but for really rough guide get the hardware spec for your disk - for example 6ms average access time. Then get your memory chip speed and calculate average access time - probably sub-microsecond.

Begin with a specification. There should be no reason not to use the parallel Transformer stage. If necessary you can create parallel routines that it can invoke.