DSXchange

See also:

viewtopic.php?t=142670

See also:

Does Oracle connector support the Oracle 12c client?
http://www-01.ibm.com/support/docview.w ... wg21683476

Yes, I already confirmed that, up above...

Has your company considered bringing in someone to review your job designs and ETL methodologies? Seems like it might be a prudent investment before spending time and money on an alternate plan when you already have an investment in a tool more than capable of doing the job. I would second Craig's ...

Try searching by author.

Added APT_DISABLE_COMBINE=True Job was successful. I think it's actually APT_DISABLE_COMBINATION but... :idea: This clue alone rings a bell. I ran into this same behavior on 11.3 due to using a newer compiler than what was supported. Even the same compiler with newer PTF levels applied caused this ...

How many jobs are running at once when these errors show up? And how many processes are running at once?

In the Oracle Connector stage, if you do not enable partitioned reads, then it will run in sequential mode.

How long is too long?

Are you sure it never finishes? (Never hasn't arrived yet.) So, how long did you wait for the job to finish?

Delimited or fixed width files?

What else happens in your job design besides reading files?

Providing a different path for the install location is always good too. I was referring renaming the old Info Server Windows folder name before installing a new client (under Windows Start Menu, All Programs). If you didn't do that, then you may have lost the old program icons. That has happened to ...

Multi Client Manager is only for DataStage clients. Before installing a second client, rename the Information Server folder, otherwise some of the program icons may get overwritten.

Thanks for sharing. That's the same method I've used and can confirm I have not encountered any further issues.

IBM has another suggestion too!

http://www-01.ibm.com/support/docview.w ... wg21903090

Even more amazing, he seems to have all the topics and posts memorized, like a human computer!

Try contacting Support.

That sounds slow. As a test, you could break a copy of the job into 2 parts and measure each part separately: 1) CFF to Data Set and 2) Data Set to Teradata. My guess would be part 1 is really fast and part 2 is really slow, then talking with a DBA may be in order.