Quick Beginnings

Chapter 2. About DB2 Universal Database

DB2 is a relational database management system that is web-enabled with Java support; scalable from single processors to symmetric multi-processors; and multimedia capable with image, audio, video, and text support. The DB2 products and components provided on your CD-ROM include: DB2 Enterprise Edition, DB2 Workgroup Edition, DB2 Connect Enterprise Edition, and DB2 Client Application Enabler. Features of each are listed below.

DB2 Workgroup Edition

• The DB2 Universal Database server enables local and remote clients and applications to create, update, control, and manage relational databases using Structured Query Language (SQL), ODBC, or CLI.

• The DB2 Client Pack CD-ROM contains all the latest DB2 Client Application Enablers. With DB2 Client Application Enabler, clients from a variety of platforms can connect to any DB2 Universal Database, DB2 Connect and DataJoiner multi-user products.

• The DB2 Net.Data CD-ROM contains all supported DB2 Net.Data (formerly known as DB2 World Wide Web Connection) products. DB2 Net.Data enables application developers to create Internet applications that access data from DB2 databases.

• DB2 Workgroup Edition is licensed on a per user basis.

DB2 Enterprise Edition

The DB2 Enterprise Edition includes all the functions provided in the DB2 Workgroup Edition, plus support for host connectivity providing users with access to DB2 databases residing on host systems such as MVS/ESA, OS/390, AS/400, VM, and VSE.

The DB2 Enterprise Edition supports unlimited LAN database access.

DB2 Connect Enterprise Edition

The DB2 Connect Enterprise Edition (formerly known as DDCS Multi-User Gateway) to provide access from clients on the network to DB2 databases residing on host systems such as MVS/ESA, OS/390, AS/400, VM, and VSE. DB2 Connect Enterprise Edition is available for the AIX, HP-UX, OS/2, Solaris, and Windows NT platforms.

DB2 Client Application Enabler

The DB2 Client Application Enabler enables a client workstation to access the DB2 server.

There are a variety of other DB2 products, which you can order separately:

• DB2 Application Developer's Kit (AD Kit) contains a collection of DB2 Universal Database products, clients, DB2 Connect products, DB2 Software Developer's Kits, and application development tools for all supported platforms. The AD Kit gives you all the tools you need to create multimedia database applications that can run on a variety of platforms and can connect to any DB2 server, including DataJoiner.

• DB2 Universal Database Personal Edition allows you to create and use local databases and to access remote databases if they are available. This product is available for the OS/2, Windows NT, and Windows 95 operating systems.

• DB2 Connect Personal Edition (formerly known as DDCS Single-User) provides access from a single workstation to DB2 databases residing on host systems such as MVS/ESA, OS/390, OS/400, VM, and VSE, as well as access to DB2 Universal Databases. This product is available for the OS/2, Windows 3.1x, Windows NT, and Windows 95 operating systems.

• DB2 Universal Database Extended Enterprise Edition (formerly known as DB2 Parallel Edition) provides the ability for a database to be partitioned across multiple independent computers of a common platform. To the end-user and application developer, it still appears as a single database on a single computer. This fully scalable database system enables an application to use a database that is simply too large for a single computer to handle efficiently. SQL operations and utilities can operate in parallel on the individual database partitions, thereby speeding up the execution time of a single query or utility.

[ DB2 List of Books | Search the DB2 Books ]