DSXchange

Seems to me the problem is clearly stated in the error message. If you don't know what the "MVS Dsname conventions" are I'd suggest you check with someone on the other end of the transfer.

You should be able to create the key change column over both keys at once since the number should be incremented if either of them change. The counter derivation becomes simpler then: Counter: If KeyChange then Counter+1 else Counter 'KeyChange' is the name of the key change column generated by the ...

It's got nothing to do with cores. It's a logical concept not a physical one. so it's not tied to the processor type or number.

What he said.

I would advise to never let a Parallel job an implicit conversion like that, especially with a flat file source. Test for validity, explicitly convert the good dates and handle the bad or missing ones.

So this is your unzipped file?

What exactly was "not proper" about the 4 node results? Would help if you showed them to us. Also, how are you partitioning the data?

As a guess (since I can't find that sqlcode online anywhere) the table either isn't partitioned in that environment or your connecting user doesn't have the permissions it needs to get the partition information.

I remember seeing that behaviour back in the 7.x world. What happens when you run the job, i.e. does it work fine? We solved the issue by always treating an Oracle DATE as a Timestamp in the job, after all that's what it is under the covers.

I am not able to fine this script on my ETL server find / -name "cleanup_abandonded_locks.sh" -print 2>/dev/null/ I didnt get any output,can you please post the location of the script. You misspelled it as "abandonded" which is one reason why you couldn't find it. The other are ...

That's what I thought... meaning it won't solve their problem.

Ray, isn't that the same as CAPITALS? If so they just the first letter of each word, not the first letter of each word capitalized. If I am mis-remembering what "MCT" does, forgive me...

Ah... the second part is where the magic happens.

Nice bit of detective work.

I've done a ton of Server jobs that dealt with XML chunks in hashed files and never once did I ever use Varbinary for it. For whatever that is worth.