DSXchange

I think that this is a clear case of using a UNIX shell script. The KISS principle applies and a short script is better than a medium-sized DS job/program.

Does that mean Oracle to Oracle with no other stages?

Ray - I'm changing lawyers. No visa issued for poor lil' me yet. I'll be there in spirit, though... (going back to the Caribbean in 2 weeks, though; so only part of my spirit will be there). I can send a picture. It will probably be subtitled "Please call the police immediately if you see this man. ...

I'm not sure why the button is dimmed, but your lines all need to start on column 8 or 12 except for the comment, which need to start on column 7

Can I get an autograph?

There is more to it than a DB stage to DB stage. The "Heap" is used when sorting (or repartitioning), so perhaps you could explain a bit more about what you are doing.

you can add the -userstatus or -jobstatus to the dsjob command.

Craig - I wasn't sure until I checked it on Google, and MS marketing blurb said that you can; so it must be true.

You could do a global change of the .dsx file from UNIX or your favorite editor and replace occurrences of Readonly "1" to Readonly "0"

Can you partition your SQL server table to reduce the slowdowns as the table grows?

What sort of hardware is this running on and how complex are the PX jobs you are starting. Perhaps you have flooded the system with hundreds of processes and the pipe setup hasn't completed in time.

That is correct, unless you convert the data while reading the PX engine doesn't have builtin functionality to perform that conversion.

The authorization code looks at your OS and number of CPUs and the actual product being installed. Could you be entering the DSDES codes for the server by misteak?

The necessary SELECT priviliges are sufficient, except for the tables you are actually using.
The privileges refer to those of the userid that connects to DB2.

That should not cause the problem. It is important to go through the registry after an unintall to make sure all DataStage related entries have been removed.