Tag: databases

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