Datastage 7.5.3 and Oracle RAC

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
cquirke
Participant
Posts: 1
Joined: Fri Jan 16, 2009 5:43 am

Datastage 7.5.3 and Oracle RAC

Post by cquirke »

Hello,
I am designing an environment which will potentially have a Datastage 7.5.3 instance performing a Load operation into a Oracle 10g RAC environment using ODBC.

What I need to know is whether Datastage 7.5.3 is 'RAC aware' or RAC compatible. By this I mean, is Datastage able to take advantage of the failover capabilities of RAC in performing its ODBC load operation. Or is Datastage rigidly a Active-Standby type application?

Is this a recommended configuration for Datastage 7.5.3 and Oracle 10g (i.e. using RAC) or what is?
Chris Quirke
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Not really sure what you mean by "RAC compatible". RAC is invisible to any connecting clients, nothing about how DataStage connects into Oracle changes just because of RAC. So are you actually asking about the failover capabilities of DataStage itself? If there is a failure that takes out both Oracle and DataStage, how transparent that would be?

If so, there are several discussions here of the High Availability / failover options you have with DataStage. I haven't looked into it for quite some time, having built what you're calling an "active-standby" clustered installation many moons ago.

Probably best to approach IBM with this question.
-craig

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