DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
peep



Group memberships:
Premium Members

Joined: 20 Aug 2012
Posts: 162

Points: 1298

Post Posted: Fri Apr 13, 2018 11:49 pm Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Two questions:
(Information Server 9.1.2 on AIX)

1) Does Oracle ODBC driver have an alternative server mechanism?
We have two Oracle databases and (A and B) and we want to connect to Oracle database B when Oracle database A fails, using ODBC driver.

2) Does CDC transaction stage uses only ODBC driver to connect to databases?
Is there any other way to connect?
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42748
Location: Denver, CO
Points: 220287

Post Posted: Sat Apr 14, 2018 9:41 am Reply with quote    Back to top    

1) In your shoes I would ask someplace more official, like Oracle forums or support. From what I recall, that's controlled by your tnsnames.ora / sqlnet.ora configuration, not the drivers themselves. And if you're thinking about anything like TAF you'll need the JDBC drivers.

2) Yes. No.

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
peep



Group memberships:
Premium Members

Joined: 20 Aug 2012
Posts: 162

Points: 1298

Post Posted: Sat Apr 14, 2018 11:51 am Reply with quote    Back to top    

Thanks for responding.

We are using odbc.ini to connect to oracle . Since CDC uses only odbc driver.

I think its time to contact official support.
Rate this response:  
Not yet rated
asorrell
Site Admin

Group memberships:
Premium Members, DSXchange Team, Inner Circle, Server to Parallel Transition Group

Joined: 04 Apr 2003
Posts: 1681
Location: Colleyville, Texas
Points: 22831

Post Posted: Mon Apr 16, 2018 12:15 am Reply with quote    Back to top    

What you are describing is only done automatically (and transparently) if your Oracle database is using Oracle Real Application Cluster (RAC) software that is separately purchasable.

If you have an Oracle RAC, here is how it can be done...

How to define Data Source for ODBC to Oracle RAC in IBM InfoSphere Information Server
http://www-01.ibm.com/support/docview.wss?uid=swg21404446

Personally I've never tried the Oracle RAC with ODBC, we always used the Oracle connector since it was so much faster and uses the Oracle tnsnames.ora definitions to connect. That gives the Oracle DBA's a lot of flexibility in configuring RAC connections.

Without Oracle RAC, you'd have to swap manually using two different definitions in the ODBC file. You'd have to use an environment variable in your jobs so you can change it when appropriate. However, the swap wouldn't be transparent since any active jobs would fail when "A" died and you had to point to "B".

_________________
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2017
Rate this response:  
Not yet rated
peep



Group memberships:
Premium Members

Joined: 20 Aug 2012
Posts: 162

Points: 1298

Post Posted: Mon Apr 16, 2018 7:03 am Reply with quote    Back to top    

Thank you for responding.

Since we are using CDC and it connects using only odbc driver we have no other option.
As a final option I will open a Case with IBM. Will keep you all posted.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42748
Location: Denver, CO
Points: 220287

Post Posted: Mon Apr 16, 2018 7:17 am Reply with quote    Back to top    

Andy, I don't think they were asking about TAF, a.k.a. Transparent Application Failover, which is why I only made a peripheral mention of it. And agree, seems to me a parameter of some kind to switch between the two ODBC configurations needed would be the way to go.

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2813
Location: USA
Points: 21314

Post Posted: Mon Apr 16, 2018 7:34 am Reply with quote    Back to top    

While you're talking with Support, you may also want to ask what to replace the CDC Transaction stage with in the future after you upgrade to DataStage 11.7 or newer because that stage has been deprecated, and documentation on a replacement stage or migration path has not yet surfaced.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours