DB2Enterprise Server Edition

DB2 Personal Developer's Edition

DB2 Universal Developer's Edition

DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition

DB2 for z/OS

DB2 for i5/OS

DB2 Data Warehouse Edition

DB2Enterprise Server Edition

To analyze workloads and make recommendations for indexes and MQTs

To present a graphical representation of a data access plan and recommend design changes that will improve performance

To replicate data between a DB2 database and another relational database

To configure clients so they can access databases stored on remote servers

Visual Explain

Alert Center

Journal

Configuration Assistant

SQL Assist

Control Center

Command Editor

Developer Workbench

Task Center

Visual Explain

Configuration Assistant

Satellite Administration Center

DB2 Everyplace

DB2 Express Edition

DB2 Workgroup Server Edition

DB2 Enterprise Server Edition

DB2 Express-C

DB2 Express

DB2 Personal Edition

DB2 Enterprise Server Edition

DB2 for z/OS

DB2 for i5/OS

DB2 Data Warehouse Edition

DB2 Enterprise Server Edition

To analyze workloads and make recommendations for indexes and MQTs

To present a graphical representation of a data access plan and recommend design changes that will improve performance

To replicate data between a DB2 database and another relational database

To configure clients so they can access databases stored on remote servers

Task Center

Visual Explain

Configuration Assistant

Satellite Administration Center

To examine the health of a DB2 Database Manager instance

To visually construct complex DML statements and examine the results of their execution

To schedule tasks, run tasks, and send notifications about completed task s to other users

To analyze database operations performed against a DB2 for i5/OS database

Develop and debug an SQL stored procedure

Develop and debug a user-defined data type

Develop and debug a user-defined function

Develop and run XML queries

Control Center

Command Center

Command Line Processor

Task Center

Historical information about tasks, database changes, messages, and notifications

Information about licenses associated with each DB2 9 product installed on a particular system

Graphical representations of data access plans chosen for SQL statements

Warning and alarm thresholds for database indicators

Granular transactions

Current data

Optimized for queries

Frequent updates

Summarized queries that perform aggregations and joins

Heterogeneous data sources

Voluminous historical data

Sub-second response time

DB2 AVI Extender

DB2 Text Extender

DB2 XML Extender

DB2 Spatial Extender

The DB2 Spatial Extender uses a latitude-longitude coordinate system; the DB2 Geodetic Extender uses a planar, x- and y-coordinate system

The DB2 Geodetic Extender is used to describe points, lines, and polygons; the DB2 Spatial Extender is used to find area, endpoints, and intersects

The DB2 Spatial Extender treats the world as a flat map; the DB2 Geodetic Extender treats the world as a round globe

The DB2 Geodetic Extender can be used to manage information like the locations of office buildings or the size of a flood zone; the DB2 Spatial Extender can be used for calculations and visualizations in disciplines like military command/control and asset

XML columns are used to store XML documents as a hierarchical set of entities

Only XQuery can be used to retrieve an XML document from an XML column

XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints

In order to access any portion of an XML document stored in an XML column, the entire document must be retrieved