Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Advantage DB2 has over MS SQL Server?

Advantage DB2 has over MS SQL Server?

Thanks for taking the time to read this by the way.

We're a small company (less than 220 employees), and we are currently using SQL Server 6.5 - 2000 in our databases.  The biggest database has a just over 5 GIGS of data, but it's growing. We are an  NT shop, and main systems are written in VB and ASP.  We have both client server applications and web browsing systems.  

We maybe jumping to Java soon, since we maybe purchasing an application that is written in Java and its back-end is DB2.

The boss wants to know if weather we should go head and convert all of our databases to DB2.  I have no work experience with DB2, and all I heard is that it's not as cheap as SQL Server and it takes more times from  DBA in setting up and maintaining it.

Any information regarding the pros and cons of this two relational database management system software is appreciated.


RE: Advantage DB2 has over MS SQL Server?

I've been a db2 man for many years, and have yet to use SQL server, but I've worked alongside many people that have used both. The word on the street is that SQL server is easier to set up, more flexible, and the language is more powerful. As I've said, this is not from personal experience but just what people have said, so take that as you will.

RE: Advantage DB2 has over MS SQL Server?


I have worked with SQL Server for the past 28 months, both as a developer and as a DBA.  Since the release of the 7.0 version, life has been much easier as a DBA.  The 7.0 and the 2000 versions have some type of self-configuration features, which has given me more time to focus on other activities (i.e., participate in system analysis process, DB software researches, performance tunning, and other in-house projects).

I have no experience with DB2.  What can I expect as a DBA in a DB2 environment?

Thanks again for sharing your experiences.

RE: Advantage DB2 has over MS SQL Server?

We have a couple of web applications, written in VB and asp, that use both SQL Server and DB2.  From an application developer's perspective, I'd say that SQL server is more flexible, and generally friendlier to use.  However, nothing beats the performance of DB2.  We have some queries that access a DB2 table of 500 million rows (that's right, half a billion), that run in seconds.

RE: Advantage DB2 has over MS SQL Server?

I agree that SQL Server is easy to use both for developers and DBAs.  If there's a much better performance in DB2, then it may be worth switching.  I am sure that DB2 will come up with a more friendlier user-interfaces and features for all users in future releases.

Can I ask what version of DB2 you are using?  Workgroup or
Enterprise?  Windows, Unix, or AS400?


RE: Advantage DB2 has over MS SQL Server?

We're using DB2 UDB for OS/390 V7 Licensed Bookshelf.  An IBM mainframe, in other words.  We reach DB2 from our Microsoft NT Server by using a product from IBM called DB2 Connect.

RE: Advantage DB2 has over MS SQL Server?

We're using DB2 UDB for OS/390 V7 .  An IBM mainframe, in other words.  We reach DB2 from our Microsoft NT Server by using a product from IBM called DB2 Connect.

RE: Advantage DB2 has over MS SQL Server?

Hello Sobeit,

As a parttime DBA I work both with DB2 and ORACLE. I have absolutely no problem with performance of DB2, it's stability is excellent, but you have to acquire a certain shade of blue (IBM blue that is). The boys (can't be girls in this case) who dreamed this up never gave much thought about us, simple mortals. I have 2 thick DBA manuals and each time I try to look something up , I start wondering which sadistic soul managed to create such incomprehensible stuff. It deserves a razzie award for most inaccesible it-manual (other stuff from IBM is slightly better, but deserves no praise)
Suggested reading:

DB2 UDB V7.2 SQL Cookbook by Graeme Birchall

T. Blom
Information analist
Shimano Europe

Red Flag This Post

Please let us know here why the post below is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close