DSXchange

What 'update action' exactly?

Silly things like life and my work got in the way. You need to find out what changed. Obviously something did. Talk to your DBA and see if any Oracle changes were made. You said "even I did the View Data option" but did say what the result was - an error? It works? What? You also said you ...

Sorry, but there's no such thing as a 'standard configuration' and no way to tell you what hardware is needed to load X rows in Y hours. There's far too many variables in 'loading' data for that.

Can you confirm for us that you did not enable the 'Do not checkpoint' option in the Job Activity stage?

There's no built-in function for this that I am aware of. You'd need to query the repository directly for that, I assume. Not sure if Kim has posted anything like that already.

That sounds familiar, as in a known bug with MI jobs. Let us know!

Did the Sequence show a status of 'Aborted/Restartable'? (it must) Did you just Run it or did you Reset it first? You want to do the former as the latter will remove all of the checkpoints.

As asked - how many nodes? If you run on a single node, is all ok?

That's true... I'm thinking of $DSHOME/include/dsapi.h which has the same information.

Server job.

Both have been discussed here, do an exact search for "floating point decimal is not fully supported" and "must match field's fixed width" for your answers.

Any idea where one would find this, Vincent? All I've found (so far) in the 8.1 docs is DB2 support and it requires MQ.

FYI, it's a DataStage 'tool' not anything generic UNIX. Many discussions here, for example this one recently.

More than likely, yes. Do you have the 'deadlock daemon' enabled on the server? If not, you should, it would help as well as one of the functions it performs is to clean up disconnected sessions like that.

Them having their own local copies of DataStage is a bad idea, you really need to look into setting up a shared Citrix-type server locally and have them connect thru that. Would go a long ways towards solving the speed issue on their end and the disconnects.