Advertisement

Performance of DB2 Enterprise-Extended Edition on NT with Virtual Interface Architecture

  • Sivakumar Harinath
  • Robert L. Grossman
  • K. Bernhard Schiefer
  • Xun Xue
  • Sadique Syed
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1777)

Abstract

DB2 Universal Database Enterprise-Extended Edition (DB2 UDB EEE) is a parallel relational database management system using a shared-nothing architecture. DB2 UDB EEE uses multiple nodes connected by an interconnect and partitions data across these nodes. The communication protocol used between nodes of DB2 UDB EEE has historically been Transmission Control Protocol (TCP) / Internet Protocol (IP) but has now been extended to include the Virtual Interface (VI) Architecture. This paper discusses a new protocol termed Virtual Interface Protocol (VIP), built on top of the primitives provided by the VI Architecture. DB2 UDB EEE with VIP on a fast interconnect has shown significant improvement in reducing the elapsed time of queries when compared with TCP/IP over fast ethernet. This paper discusses the implementation and performance results on a Transaction Processing Council’s Decision (TPC-D) support database.

Keywords

Transmission Control Protocol Central Processing Unit Central Processing Unit Utilization Node Cluster Central Processing Unit Usage 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Buonandonna, P., et al.: An Implementation and Analysis of the Virtual Interface Architecture. Proceedings of the Supercomputing’ 98 Conference (1998)Google Scholar
  2. 2.
    Compaq, Intel and Microsoft: Virtual Interface Architecture Specification, Version 1.0. Compaq (1997)Google Scholar
  3. 3.
    Grossman, R., Bailey S., Hanley, D.: Data Mining Using Light Weight Object Management in Clustered Computing Environments. Proceedings of the Seventh International Workshop on Persistent Object Stores, Morgan-Kauffmann, San Mateo (1997) 237–249Google Scholar
  4. 4.
    IBM Corporation: DB2® Universal Database™ goes parallel with Enterprise and Enterprise-Extended Edition. IBM Corporation (1998)Google Scholar
  5. 5.
    IBM Corporation: IBM DB2® Universal Database™ on Windows NT Clusters. IBM Corporation (1998)Google Scholar
  6. 6.
    IBM Corporation: IBM DB2® Universal Database™ Administrator Guide, Version 5.2. IBM Corporation (1998)Google Scholar
  7. 7.
    H. Sivakumar H., et al: Improving the performance of DB2 UDB EEE with the Virtual Interface Protocol. LAC Tech Report 99-23TR, Laboratory for Advanced Computing, University of Illinois at Chicago (1999).Google Scholar
  8. 8.
    Transaction Processing Performance Council: TPC-D Benchmark Specification Version. (1998)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2000

Authors and Affiliations

  • Sivakumar Harinath
    • 1
  • Robert L. Grossman
    • 1
  • K. Bernhard Schiefer
    • 2
  • Xun Xue
    • 2
  • Sadique Syed
    • 2
  1. 1.Laboratory of Advanced ComputingUniversity of Illinois at ChicagoChicagoUSA
  2. 2.Database TechnologyIBM Toronto LaboratoryEastNorth York

Personalised recommendations