dcsimg

A Comparison of SQL Server 2000 with DB2 v8.1 - Page 2

April 9, 2003

Software requirements

SQL Server 2000 comes in six editions: Enterprise, Standard, Personal, Developer, Desktop Engine, and SQL Server CE (a compatible version for Windows CE) and requires the following software:

Operating System Enterprise Edition Standard Edition Personal Edition Developer Edition Desktop Engine SQL Server CE
Windows CE No No No No No Yes
Windows 9x No No Yes No Yes No
Windows NT 4.0 Workstation with Service Pack 5 No No Yes Yes Yes No
Windows NT 4.0 Server with Service Pack 5 Yes Yes Yes Yes Yes No
Windows NT 4.0 Server Enterprise Edition with Service Pack 5 Yes Yes Yes Yes Yes No
Windows 2000 Professional No No Yes Yes Yes No
Windows 2000 Server Yes Yes Yes Yes Yes No
Windows 2000 Advanced Server Yes Yes Yes Yes Yes No
Windows 2000 DataCenter Yes Yes Yes Yes Yes No
Windows XP Professional No No Yes Yes Yes No

DB2 Universal Database v8.1 comes in six editions:

  • DB2 Enterprise Server Edition (ESE)
  • DB2 Workgroup Server Edition (WSE)
  • DB2 Workgroup Server Unlimited Edition (WSUE)
  • DB2 Personal Edition (PE)
  • DB2 Universal Developer's Edition (UDE)
  • DB2 Personal Developer's Edition (PDE)
  • and requires the following software:

    Platform Operating System Version Required Patches
    Windows-based Windows NT 4.0 Service Pack 6a or higher
    Windows-based Windows 2000 Service Pack 2 is required for
    Windows Terminal Server
    Windows-based Windows XP Not Necessary
    AIX-Based AIX 4.3.3 (32-bit) Maintenance Level 9 or later, and
    APARs IY22308, Y32690, and IY33024
    AIX-Based AIX 5L (32-bit) Maintenance Level 2 or later
    AIX-Based AIX 5.1.0 (32-bit) Maintenance Level 2 or later, and
    APARs IY31254, IY32217, IY32905,
    IY33023, and IY29345
    AIX-Based AIX 5.1.0 (64-bit) Maintenance Level 2 or later, and
    APARs IY31254, IY32217, IY32905,
    Y33023, and IY32466
    HP-UX HP-UX 11i December 2001 GOLDBASE11i,
    December 2001 GOLDAPPS11i bundles
    Linux For Intel 32-bit:
  • kernel level 2.4.9 or later
  • glibc 2.2.4 or later
  • RPM 3 or later


  • For Intel 64-bit and z-Series:
  • Red Hat Linux 7.2
  • SuSE Linux SLES-7
  • Not Necessary
    Sun Solaris Solaris 7 (32-bit) patch 106327-10
    Sun Solaris Solaris 7 (64-bit) patch 106300-11
    Sun Solaris Solaris 8 (32-bit) patch 108434-03 and 108528-12
    Sun Solaris Solaris 8 (64-bit) patch 108435-03 and 108528-12
    Sun Solaris Solaris 9 Not Necessary

    Performance comparison

    It is very difficult to make a performance comparison between SQL Server 2000 and DB2 Universal Database v8.1. The performance of your databases depend rather on the experience of the database developers and database administrator, than on the database's provider. You can use both of these RDBMS to build stable and efficient systems. It is possible to define the typical transactions, such as those used in inventory control systems, airline reservation systems and banking systems. After defining these typical transactions, it is possible to run them under different database management systems working on the different hardware and software platforms.

    TPC tests

    The Transaction Processing Performance Council (TPC.Org) is an independent organization that specifies the typical transactions (transactions used in inventory control systems, airline reservation systems and banking systems) and some general rules these transactions should satisfy.

    The TPC produces benchmarks that measure transaction processing and database performance in terms of how many transactions a given system and database can perform per unit of time, e.g., transactions per second or transactions per minute.

    The TPC organization made the specification for many tests. There are TPC-C, TPC-H, TPC-R, TPC-W and some old tests, such as TPC-A, TPC-B and TPC-D. The most popular test is the TPC-C test (OLTP test).

    At the moment this article was written, SQL Server 2000 held the top TPC-C by performance results with Distributed Partitioned Views-based cluster systems. See Top Ten TPC-C by Performance Version 5 Results

    At the moment this article was written, SQL Server 2000 held the top TPC-C by price/performance results. See Top Ten TPC-C by Price/Performance Version 5 Results

    Note. Because most organizations really do not run very large databases, the key points on which SQL Server 2000 won the TPC-C benchmarks do not really matter to the vast majority of companies.








    The Network for Technology Professionals

    Search:

    About Internet.com

    Legal Notices, Licensing, Permissions, Privacy Policy.
    Advertise | Newsletters | E-mail Offers