Does version 9.1 support Oracle 8 databases?

asyed · Post by **asyed** » Mon Apr 07, 2014 6:35 am

Hi All,

Does Datastage 9.1 support Oracle 8 database. Where can we find such information ? I glanced through few documents, but was not able to find the required information.

Thanks & Regards

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Mon Apr 07, 2014 2:51 pm

Here's a link that might be useful...

Prerequisites for migrating InfoSphere DataStage jobs that use Oracle 8 projects

http://pic.dhe.ibm.com/infocenter/iisin ... racle.html

The Oracle 11g client also doesn't support 8 anymore. Since that is an ancient release, probably time to upgrade...

chulett · Post by **chulett** » Mon Apr 07, 2014 2:57 pm

What about the possibility of installing an Oracle 8 client on the DataStage server and leveraging that?

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Mon Apr 07, 2014 3:29 pm

The XMETA database requirement only shows support for 11g (they dropped 10g) and usually that means the product won't support anything else as a client.

However, it can be verified by calling your service provider. Since Oracle 8 initially shipped back in 1997, I still say time to get on a database made this century...

chulett · Post by **chulett** » Mon Apr 07, 2014 3:35 pm

Hey, at least they didn't ask about Oracle 7 support.

And I was more going for "works" rather than "is supported"... agreed that this should be put in front of their support provider, see what they have to say.