| The DB2 UDB family (see Figure 1-4) consists of many different platforms that can coexist in a distributed environment: -
z/OS or OS/390. This offering is the largest of the DB2 family, often serving as an enterprise server handling some of the largest applications in the world. The System/390 is IBM's largest hardware platform. -
Enterprise Edition. This offering is often used to build e-business applications and to support large departmental applications. If offers the most connectivity options and can share data with third-party databases and DB2 on heterogeneous platforms. -
Workgroup Edition. This offering is often used for smaller departmental applications or for applications that do not need access to remote databases on the OS/400, VSE/VM, or OS/390 platforms. -
Enterprise-Extended Edition. This offering is used most often to support very large databases. Popular applications include supporting large data warehouses. By providing intraquery and interquery parallelism, databases can scale to multiple terabytes. DB2 UDB Enterprise-Extended Edition can exploit clusters or massively parallel hardware architectures. -
Personal Edition. This full-function database offering is for standalone use and will not accept remote database requests . Personal Edition is available on Windows, OS/2, and Linux. -
Satellite Edition. This offering is for single-users and has a smaller footprint than Personal Edition. It will not accept remote database requests. This offering is available on the Windows platform. -
Everyplace. This is a mobile computing offering that gives mobile workers access to DB2 data sources in the enterprise through handheld devices such as personal digital assistants (PDAs) and handheld personal computers (HPCs). Figure 1-4. DB2 Universal Database.  DB2 Everyplace DB2 Everyplace (or DB2E) is a tiny " fingerprint " database of about 100K (see Figure 1-5). It is designed for low-cost, low-power, small form-factor devices such as PDAs, HPCs, or embedded devices. DB2 Everyplace runs on devices that use the Palm Computing platform, Windows CE, the EPOC operating system, and the QNX Neutrino. DB2 Everyplace provides a local data store on the mobile or embedded device for storing relational data from elsewhere in the enterprise. Relational data can be synchronized to the handheld device from other DB2 data sources, such as DB2 Universal Database for UNIX, OS/2, and Windows NT; DB2 for OS/390; and DB2 for AS/400. DB2 Everyplace with IBM Mobile Connect will also synchronize data from other open database connectivity (ODBC)-compliant data sources, such as Oracle and Microsoft databases. Figure 1-5. DB2 Everyplace.  The DB2 Everyplace Sync Server mobilizes professionals with e-business information anywhere , anytime . It extends the power of DB2 to a wide range of handheld devices, such as those running the Palm Pilot. DB2 Satellite Edition DB2 Satellite Edition (see Figure 1-6) forms part of a DB2 solution to support systems that operate disconnected from the corporate system the majority of the time and connect occasionally to the corporations central database to exchange data. DB2 Satellite Edition is a full-function, high-performance DB2 database specially designed for occasionally connected workers running Windows operating systems. The satellite system itself does not require the user to manage the database. This means the end user is free to focus on business resultsthe user does not even need to know a database is installed. Figure 1-6. DB2 Satellite environment.  The application areas that can benefit from this solution include contract management, insurance application automation, securities marketing, and automobile insurance claims processing. In addition, large-scale branch office deployments are being used to provide automation to franchise stores, insurance agents , and regional offices of large corporations. In these kinds of environments, the applications are custom built, purchased, or a combination. The satellite environment administration model minimizes the cost of administering a large number of systems by administering collections of systems running the same application and database in groups. Scripts stored at a central administration control point are used to accomplish administrative tasks on the systems in a group . This model also allows for centralized problem determination. Replication administration uses the same model. Replication subscription definitions are stored in a central control server as scripts. When executed at the satellite system, the scripts set up each satellite for replication with a corporate data store. DB2 Satellite Edition's small footprint and application compatibility with the rest of the DB2 family make it an ideal candidate for the delivery of distributed applications on systems that will occasionally connect with corporate data stores to exchange data. This product is available only on the Windows platform. DB2 Personal Edition DB2 Personal Edition (DB2 PE) is a full-function database that enables a single user to create databases on the workstation on which it is installed. It can be used as a remote client to a DB2 server, since it also contains the DB2 client components . The DB2 Personal Edition product is often used by end users requiring access to local and remote DB2 databases or by developers prototyping applications that will be accessing other DB2 databases. Figure 1-7 shows an example of a DB2 Personal Edition installation. In this example, the user can access a local database on his or her desktop machine and access remote databases located on the database server. From the desktop, the user can make changes to the database throughout the day and replicate those changes as a client to the remote database on the DB2 server. Figure 1-7. DB2 Personal Edition.  DB2 Personal Edition includes graphical tools (all of the other products include these tools as well, via the DB2 Administration Client component) that enable a user to administer, tune for performance, access remote DB2 servers, process SQL queries, and manage other servers from a single workstation. This product is available on Windows, OS/2, and Linux. DB2 Workgroup Edition DB2 Workgroup Edition (DB2 WE) is designed for use in a LAN environment. It provides support for both remote and local clients . A server with DB2 Workgroup Edition installed can be connected to a network and participate in a distributed environment, as shown in Figure 1-8. Figure 1-8. DB2 Workgroup Edition with remote clients.  In Figure 1-8, App1 and App2 are local database applications. Remote clients can also execute App1 and App2 if the necessary setup has been performed. A DB2 application does not contain any specific information regarding the physical location of the database. DB2 client applications communicate with DB2 Workgroup Edition using a supported distributed protocol. Depending on the client and server operating systems involved, DB2 Workgroup Edition supports the TCP/IP, NetBIOS, IPX/SPX, named pipes, and APPC protocols. DB2 Workgroup Edition includes DB2 Extenders, which provide the ability to manipulate data outside of conventional rows and columns , and Net.Data, a product that allows you to build Internet-ready applications that store data in DB2 databases. DB2 Workgroup is available on the Windows, OS/2, AIX, Solaris, HP-UX, and Linux platforms. DB2 Enterprise Edition DB2 Enterprise Edition (or DB2 EE) is fully Web-enabled; scalable from single processors to symmetric multiprocessors and to massively parallel clusters; and supports unstructured data such as image, audio, video, text, spatial, and XML with its object relational capabilities. It includes all the functions found in DB2 WE. Applications for DB2 Enterprise Edition can scale upward and execute on massively parallel clusters or can scale downward with applications executing on single-user database systems. DB2 Enterprise Edition is available on the Windows, OS/2, Linux, and UNIX platforms. DB2 Enterprise-Extended Edition DB2 Enterprise-Extended Edition (or DB2 EEE) is the scalability option that enables DB2 to partition data across clusters or massively parallel computers (see Figure 1-9). It includes all the functionality found in DB2 EE and adds to it. To the end user or application developer, the database appears to be on a single computer. All SQL statements are processed in parallel, thus increasing the execution speed for any given query. DB2 Enterprise-Extended Edition is available on the Windows, AIX, Solaris, HP-UX, and NUMA-Q platforms. Figure 1-9. DB2 processing a query in parallel.  DB2 for OS/390 and z/OS DB2 for OS/390 and z/OS is a relational database management system that is the foundation of many e-business, business intelligence, and mission-critical systems. It is the primary focus of this certification guide. DB2 for OS/390 and z/OS is the largest of the DB2 family, often serving as an enterprise server handling many of the largest applications in the world. The environment provided by System/390 and either OS/390 or z/OS is IBM's largest and most powerful, providing the most scalable and available platform. | 
