IBM DB2


The IBM DB2 is a relational model database server developed by IBM. It primarily runs on Unix (namely AIX), Linux, system i (formerly as/400), z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions. Alongside DB2 is another RDBMS: Informix, which was acquired by IBM in 2001


Different DB2 Editions:


DB2 Enterprise Server Edition

DB2(R) Universal Database (UDB) Enterprise Server Edition (ESE) is a multiuser version of DB2 that allows you to create and manage single-partitioned or partitioned database environments. Partitioned database systems can manage high volumes of data and provide benefits such as increased performance and high availability. Other features of DB2 UDB Enterprise Server Edition include:

  • A data warehouse server and related components.
  • DB2 Connect(TM) functionality for accessing data stored on midrange and mainframe database systems such as DB2 for iSeries(TM)or DB2 UDB for z/OS(TM) and OS/390(R). DB2 UDB Enterprise Server Edition provides support for both local and remote DB2 clients. Use of the DB2 Connect component is limited to five (5) registered users per server. If additional users are required, a separate DB2 Connect program must be acquired. Contact your IBM(R) sales representative for more information.
  • Satellite administration capabilities allow DB2 UDB ESE to remotely administer DB2 UDB Personal Edition and DB2 UDB Workgroup Server Edition database servers that are configured as satellites. For more information about satellite capabilities, refer to the satellite administration documentation.

DB2 Workgroup Server Edition

DB2 Workgroup Server Edition is the ideal scalable, full-fledged relational database for small to medium sized businesses. In addition to having the power and reliability to handle department level workloads with ease, Workgroup Server Edition is packed with features that reduce the overall costs of owning a database including:

  • Enhanced pureXML capabilities
  • Back-up compression capabilities
  • Maximum data availability to minimize the costs associated with planned and unplanned downtime.
  • Self-tuning memory management and other autonomic features
  • Innovative security and audit capabilities
  • Developer productivity enhancements

DB2 Express-C

IBM DB2 Express-C is a no-charge community edition of the DB2 data server. It is ideal for small businesses and multi-branch companies, as well as developers and business partners who serve these clients. DB2 Express-C can be setup quickly, is easy-to-use, and includes self-managing capabilities. It also embodies all of the core features of the more scalable DB2 editions, including the revolutionary pureXML technology for powering a new breed of Web 2.0 and SOA based solutions

DB2 Express Edition

DB2 Express, with attractive entry-level pricing, is the ideal data server for the small and medium business (SMB) market.

DB2 Express is the ideal entry level data server which is suitable for transaction processing or complex query workloads on servers with up to two processors. DB2 Express is also packed with features that reduce the overall costs of owning a database including:

  • Optimized to utilize up to 4 processor cores and 4GB of memory
  • Installs quickly and easily
  • Can be transparently embedded with other applications
  • Includes autonomic and remote management features
  • Enabled for Cloud Computing and Virtualization
  • Includes pureXML technology to power the next generation of agile SOA applications
  • Includes homogeneous federation, homogeneous SQL replication, and backup compression
  • Offers a choice of User, Value Unit, Server, and Yearly licensing models

IBM DB2 UDB, DB2 Database ,IBM DB2 SQL, USA, India, Canada, Illinois, Minnesota, Arizona