Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Leaving sql server for DB2


Leaving sql server for DB2

Author
Message
Indianrock
Indianrock
SSC Eights!
SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)

Group: General Forum Members
Points: 858 Visits: 2258
Our company has made the decision to gradually leave sql server in favor of DB2. We have a wide variety of applications ( many acquisitions ) running on MSSql, Oracle, DB2 and others. I think pricing had a lot to do with it.
It will take a few years to migrate the application in my division from C# .net to Python/Java ( I think ) and the databases. I won't be with the company long enough to worry about it but wondered what thoughts you might have about DB2 versus Sql.



Michael Valentine Jones
Michael Valentine Jones
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3254 Visits: 11771
Probably need to hear more of the justification, but I doubt that there will be any money savings from going to DB2, even without the cost of the conversion.
sqlbuddy123
sqlbuddy123
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1212 Visits: 2243
Indianrock (3/26/2014)
Our company has made the decision to gradually leave sql server in favor of DB2. We have a wide variety of applications ( many acquisitions ) running on MSSql, Oracle, DB2 and others. I think pricing had a lot to do with it.
It will take a few years to migrate the application in my division from C# .net to Python/Java ( I think ) and the databases. I won't be with the company long enough to worry about it but wondered what thoughts you might have about DB2 versus Sql.



I don't think it's the Cost factor too. Could be some missing functionality in SQL Server and .Net ..

--
SQLBuddy
Indianrock
Indianrock
SSC Eights!
SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)

Group: General Forum Members
Points: 858 Visits: 2258
One result of this decision is the departure of several senior c# .NET developers along with a few sql server DBAs. The only reason I've heard was pricing, but who knows. Might just be some manager who used to work in an IBM environment and thinks sql server is still like MS Access.



Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17590 Visits: 32265
Cost alone? Nah, surely not. Not that SQL Server is cheap any more, it isn't, but DB2 is hardly the low cost alternative. It's either politics, or some other piece of functionality. Cost doesn't make sense.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
sql-lover
sql-lover
SSChasing Mays
SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)

Group: General Forum Members
Points: 651 Visits: 1930
Indianrock (3/26/2014)
Our company has made the decision to gradually leave sql server in favor of DB2. We have a wide variety of applications ( many acquisitions ) running on MSSql, Oracle, DB2 and others. I think pricing had a lot to do with it.
It will take a few years to migrate the application in my division from C# .net to Python/Java ( I think ) and the databases. I won't be with the company long enough to worry about it but wondered what thoughts you might have about DB2 versus Sql.



When I was in HP, we used to have DB2 , Oracle 10g and 11g (still they have, I think), and MS-SQL (lot of flavors, even SQL200). In my experience, the main reasons for these moves are:

-"Politics" (internal issues within the company with X or Y database product and that company)
-The guru guy(s) that writes .NET (or his team) is leaving the company

I am not a DB2 expert, and MS-SQL is not cheap anymore. But I am not aware of any huge cost saving thing that make a company jump to DB2 instead. Leaving MS-SQL for MySQL or MariaDB? maybe, but I personally find MySQL inferior in many ways. Not to start a DB engine war, but that's my opinion.
sqlbuddy123
sqlbuddy123
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1212 Visits: 2243
True, Politics play a big role in these decisions ..

--
SQLBuddy
Markus
Markus
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1582 Visits: 3672
It depends..... are they simply spinning up an AIX or Linux server, installing one DB2 instance and moving all of the different SQL Server dbs to it that are on multiple machines?

Back in 2011 we finished up a project that eliminated our AIX DB2 Data Warehouse and our Mainframe DB2 systems and moved it all to Oracle and a little of it to SQL Server. The justification was to sunset an outdated Mainframe and AIX server and to 'modernize' our data center along with a ton of cost savings. Well, honestly we got an Oracle ExaData server and most of it moved there. If any of you have dealt with Oracle the word inexpensive is never in a conversation. It costed MORE! The one thing it did do though was take us from four different platforms down to two and eliminated the Mainframe of which very few people left here knew anything about it. It also allowed them to eliminate 9 IT positions. Sad because the Mainframe is by far the most reliable and highest up time system we ever have had here.



samalex
samalex
SSC Veteran
SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)

Group: General Forum Members
Points: 216 Visits: 1050
I'm really curious to know why your making the switch... I work in a DB2/MS SQL mixed shop where we have DB2 LUW and on z/OS plus we have many MS SQL Servers. They all play well together for the most part.

So my question is why, and to what version of DB2 are you moving to (LUW or z)? I agree with others, the cost I'd assume is probably equal to or more, and I've found IBM support just as teeth grinding if not more so than MS support. The whole PMR process through IBM is crazy and their online support is about where MSDN was 10 years ago as far as quality with outdated info and many broken links.

With that being said I do like DB2 as a RDBMS for the most part, and though some of its methods are crazy there's some logic to most of it. Just be ready for connectivity issues until you learn the DB2/IBM way of doing it since it's completely different from MS SQL. Learn how to install the DB2 client and catalog nodes and databases since that'll be the biggest thing for clients who make direct DB calls. Also research DB2 connect of you plan on using DB2 for Z. It can be used for DB2 LUW as well, but I don't think it's needed as much on that front. Also start learning IBM Data Studio. It's their SSMS equivalent, and though it's nice it's buggy and not very intuitive.

If you'd like send me a PM and i can share more info and some of my notes on moving between DB2 and MS SQL there since they're outside of the forum scope.
Indianrock
Indianrock
SSC Eights!
SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)SSC Eights! (858 reputation)

Group: General Forum Members
Points: 858 Visits: 2258
I believe it will be LUW "pure data" but I'm not really involved in the change ( retiring in a few months :-) ) I see open positions for very senior DB2 DBAs with advanced Linux/Unix scripting skills. In our own local application, everything was built on sql server from C# .Net using ORM technology almost totally by developers and no DBA involvement until way late in the game -- years after product rollout.

That wasn't a great way to do things, but whether the current switch has anything to do with a backlash towards more old-school DBA approaches I can't say.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search