Step 1.1 The DB2 Family

• DB2 Everyplace: - DB2 Everyplace is a small-footprint (approximately 350 KB) relational database and a high-performance data synchronization solution that allows enterprise applications and data to be extended to mobile devices such as personal digital assistants (PDAs), handheld personal computers (HPCs), and smart phones
  
  
• DB2 Express: - DB2 Express Edition (or DB2 Express) is an entry-level data serve.
  Add-on features available for DB2 Express include
  a. pureXML: The DB2 pureXML™ Feature provides simple, efficient access to XML data while providing the same levels of security, integrity, and resiliency that are available for relational data. DB2 9 stores XML data in a hierarchical format that naturally reflects the structure of XML. This storage approach, along with innovative XML indexing techniques, allows DB2 to manage XML data efficiently while eliminating the complex and time-consuming parsing that is typically required to store XML data in a relational database.
  b. High Availability: The DB2 High Availability Feature provides 24 x 7 availability to a DB2 data server. Three packages that constitute this feature are High Availability Disaster Recovery (HADR), Online Reorganization, and IBM Tivoli System Automation for Multiplatforms (TSA MP). 
  c. Workload Management: The DB2 Workload Management Feature leverages the Connection Concentrator in conjunction with either Query Patroller (QP) or the DB2 Governor to provide a more proactive, fail-safe workload environment. Connection Concentrator enables fail-safe operation and load balancing of a workload. Query Patroller is a powerful query workload management tool that proactively and dynamically controls submission and execution of queries to manage DB2 data server workloads better. The DB2 Governor monitors and changes the behavior of applications that run against the DB2 data server, depending on rules that you specify in the governor configuration file. 
  d. Performance Optimization: DB2 Performance Optimization combines the functionality of three modules to provide performance optimizations for complex queries, data clustering for On-Line Analytical Processing (OLAP) applications, and high performance for machines with multiple processors. This feature consists of materialized query tables (MQTs), multidimensional clustering (MDC), and Query Parallelism.
  e. DB2 Homogenous Federation Feature: The DB2 Homogeneous Federation Feature provides the ability to manage and access remote DB2 and Informix data servers as if they were local tables.
• DB2 Express-C: -DB2 Express-C is a no-charge entry-level data server
• DB2 Personal Edition: - DB2 Personal Edition (PE) is a single-user, full-function relational database management system that is ideal for desktop or laptop-based deployments.Remote clients cannot access databases that are under DB2 Personal Edition's control, but PCs running DB2 Personal Edition can act as remote clients and access data stored on other DB2 servers.
• DB2 Workgroup Server Edition: -DB2 Workgroup Server Edition (WSE) is a multi-user, full-function client/server database management system.
• DB2 Enterprise Server Edition: -DB2 Enterprise Server Edition (ESE) is a multi-user, full-function, Web-enabled client/server database management system
• DB2 Data Warehouse Edition: -
• DB2 Personal Developer's Edition: -
• DB2 Universal Developer's Edition: -
• DB2 Enterprise Developer's Edition: -
• DB2 for i5/OS: -
• DB2 for z/OS: -