DSXchange

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?

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.