Datastage v4.2 and Oracle 10g

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
chrisderks
Premium Member
Premium Member
Posts: 1
Joined: Thu Aug 10, 2006 7:42 pm

Datastage v4.2 and Oracle 10g

Post by chrisderks »

Hi,

We currently have a Datastage v4.2 Server environment, which connects to an Oracle 9i Database, using OCI 8i client.

We wish to upgrade the database to version 10g, retaining the version 4.2 of datastage server. Oracle 10g requires OCI 9i client as a minimum.

Question is whether v4.2 is compatible with an OCI 9i client or higher, and/or whether a patch is available to do this.

Regards
Chris
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard.

Technically no. However, stages are written to a common API so, if you were to get the OCI stage that is compatible with version 9i (from your support provider) and install Oracle 9i client, then you may be able to get it to work. It is worth testing. Of course the OCI stage for 9i may depend on some feature that is not in DataStage 4x - I have no way of knowing, as I have never encountered this combination.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Wow, still running 4.2 eh? You really should be asking your official support provider this question, I seriously doubt many here would have any direct experience with something like this. Well, except perhaps for ICE. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply