DataStage 4/6 and Oracle 8i/9i compatability

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
nigel
Premium Member
Premium Member
Posts: 35
Joined: Tue May 07, 2002 2:48 am
Location: South Africa/UK
Contact:

DataStage 4/6 and Oracle 8i/9i compatability

Post by nigel »

Hi

Can anyone please help me with the following queries:

My o/s is solaris 2.8

For DS6: 1) does the OCI8 plugin work with oracle 8.1.7 databases?
2) Is there an OCI9 plugin for oracle 9i (oracle 9 release2)?
3) Would jobs developed on ver 4 using the oci 8 plugin to connect to oracle 8.1.7 databases still work after an upgrade to ds6/7

For DS4: 1) Would ds4 jobs be able to connect to oracle 9i databases?
2) If so, with which plugin?

Any help would be greatly appreciated.

PS: I tried the forum search engine this morning but there seems to be a problem with it

Regards

Nigel

Nigel
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Briefly -

1) Yes.
2) Yes, in V6+
3) Yes.

1) Yes.
2) OCI8 with an 8i client.

-craig [:)]
Post Reply