Often people in newsgroups ask about a comparison of DB2 and
Microsoft SQL Server. In this article I will compare SQL Server 2000
with DB2 Universal Database version 8.1 regarding price, performance,
platforms supported, SQL dialects, and products limits.
SQL Server 2000 only works on Windows-based platforms, including Windows 9x,
Windows NT, Windows 2000 and Windows CE.
In comparison with SQL Server 2000, DB2 Universal Database version 8.1
supports all known platforms, including Windows-based platforms, AIX-based
systems, HP-UX systems, Linux Intel, Sun Solaris and so on.
To install SQL Server 2000, you should have Intel or compatible
platforms and the following hardware:
| Hardware | Requirements |
|---|---|
| Processor | Pentium 166 MHz or higher |
| Memory |
32 MB RAM (minimum for Desktop Engine), 64 MB RAM (minimum for all other editions), 128 MB RAM or more recommended |
| Hard disk space |
270 MB (full installation), 250 MB (typical), 95 MB (minimum), Desktop Engine: 44 MB Analysis Services: 50 MB minimum and 130 MB typical English Query: 80 MB |
DB2 Universal Database v8.1 supports Windows-based platforms,
AIX-based systems, HP-UX systems, Linux Intel, Sun Solaris and so on.
To install DB2 Universal Database v8.1 under the Windows-based
platforms, you should have the following hardware:
| Hardware | Requirements |
|---|---|
| Processor | Pentium or Pentium compatible CPU |
| Memory |
RAM: 256 MB minimum, additional memory may be required. |
| Hard disk space |
Typical installation: 350 Mb minimum Compact installation: 100 Mb minimum Custom installation: 100 Mb minimum. Additional disk space may be required |
To install DB2 Universal Database v8.1 under the UNIX Systems, such
as AIX-based systems, HP-UX systems, Linux and Sun Solaris, you should
have the following hardware:
| Hardware | Requirements |
|---|---|
| Processor |
For AIX: IBM RISC/6000 or eServer pSeries. For HP-UX: For Linux: For Solaris: |
| Memory |
RAM: 256 MB minimum, additional memory may be required. |
| Hard disk space |
Typical installation: 450 to 550 Mb minimum Compact installation: 350 to 400 Mb minimum Custom installation: 350 to 700 Mb minimum. |
I am the owner of MSSQLCity.Com - a site dedicated to providing useful information for IT professionals using Microsoft SQL Server. This site contains SQL Server Articles, FAQs, Scripts, Tips and Test Exams.
DatabaseJournal.com publishes relevant, up-to-date and pragmatic articles on the use of database hardware and management tools and serves as a forum for professional knowledge about proprietary, open source and cloud-based databases--foundational technology for all IT systems. We publish insightful articles about new products, best practices and trends; readers help each other out on various database questions and problems. Database management systems (DBMS) and database security processes are also key areas of focus at DatabaseJournal.com.
Property of TechnologyAdvice. © 2026 TechnologyAdvice. All Rights Reserved
Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.
