Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Leaving sql server for DB2 Expand / Collapse
Author
Message
Posted Wednesday, March 26, 2014 10:28 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:17 AM
Points: 599, Visits: 1,712
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.




Post #1555073
Posted Wednesday, March 26, 2014 11:27 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, October 3, 2014 2:23 AM
Points: 3,108, Visits: 11,503
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.

Post #1555102
Posted Wednesday, March 26, 2014 2:25 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 7:59 PM
Points: 1,194, Visits: 2,222
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
Post #1555162
Posted Wednesday, March 26, 2014 2:45 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:17 AM
Points: 599, Visits: 1,712
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.


Post #1555173
Posted Wednesday, March 26, 2014 4:44 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 13,890, Visits: 28,285
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
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1555212
Posted Thursday, March 27, 2014 9:09 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 8:53 AM
Points: 411, Visits: 1,310
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.
Post #1555478
Posted Thursday, March 27, 2014 9:19 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 7:59 PM
Points: 1,194, Visits: 2,222
True, Politics play a big role in these decisions ..

--
SQLBuddy
Post #1555489
Posted Thursday, March 27, 2014 11:25 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:17 AM
Points: 1,289, Visits: 2,844
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.



Post #1555583
Posted Friday, March 28, 2014 10:35 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 7:28 AM
Points: 208, Visits: 951
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.
Post #1556037
Posted Friday, March 28, 2014 10:52 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:17 AM
Points: 599, Visits: 1,712
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.



Post #1556052
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse