Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

DB2

Posted Apr 9, 2003

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

By Alexander Chigrik

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.



    DB2 Archives

    Comment and Contribute

     


    (Maximum characters: 1200). You have characters left.

     

     



















    Thanks for your registration, follow us on our social networks to keep up-to-date