DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
dwh_user



Group memberships:
Premium Members

Joined: 18 Oct 2018
Posts: 4
Location: Sydney
Points: 52

Post Posted: Thu Nov 29, 2018 4:10 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Additional info: For IIS repositories
Hi experts,

How much better still is using DB2 over SQL Server for IIS repositories these days (IADB and XMETA)?

We are considering upgrading to 11.7 whilst re-architecturing (moving to RedHat). I am guessing it is safe to say that using DB2 for IIS repositories is the best option. However the DBA's are only supporting SQL Server (used currently) and a little Oracle. If we choose DB2 we will loose DBA team's support and will have responsibility for an additional tier.

If I remember correctly, DB2 gets patched very rarely (roughly twice a year?). If true, we do not have a big dependency on DBA team any more.

We have noticed that IADB on SQL Server throws many warnings due to 900 byte index key length limit (IBM's response to a ticket). I suspect that such an issue is not present with IADB on DB2.

How hard should we push the case for DB2 over SQL Server for the IIS repositories?

Thanks!
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54519
Location: Sydney, Australia
Points: 295643

Post Posted: Fri Nov 30, 2018 5:47 pm Reply with quote    Back to top    

I would say you've pretty much answered your own question, except for the subjective portion ("how hard"). What's going to make your life easier, given the fact that, as you note, very little mainten ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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: 42960
Location: Denver, CO
Points: 221541

Post Posted: Fri Nov 30, 2018 9:39 pm Reply with quote    Back to top    

... and here I was going to suggest that it's better to stick with the devil you know. Wink

_________________
-craig

Now I've got that feeling once again, I can't explain; you would not understand
this is now who I am. I have become comfortably numb.
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: 1694
Location: Colleyville, Texas
Points: 23058

Post Posted: Mon Dec 03, 2018 8:41 pm Reply with quote    Back to top    

Craig! Stop talking about Ray like that! Smile

_________________
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2017
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: 42960
Location: Denver, CO
Points: 221541

Post Posted: Mon Dec 03, 2018 9:53 pm Reply with quote    Back to top    

Busted. Embarassed

_________________
-craig

Now I've got that feeling once again, I can't explain; you would not understand
this is now who I am. I have become comfortably numb.
Rate this response:  
Not yet rated
dwh_user



Group memberships:
Premium Members

Joined: 18 Oct 2018
Posts: 4
Location: Sydney
Points: 52

Post Posted: Tue Dec 04, 2018 4:32 pm Reply with quote    Back to top    

Thanks a lot gentlemen!
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