Metadata interchange
Metadata interchange is expanded to support the industry standard, Common Warehouse Metadata Standard, from the Object Management Group, facilitating solution integration among heterogeneous tools.

Enhanced SQL
New SQL functions for moving aggregates, such as moving average and moving sum, are now available for analytical queries. These additional computational functions expand your OLAP capabilities and improve the performance of these typically challenging queries.

Heterogeneous distributed query
DB2 Universal Database users now have the power of distrubuted query across any DB2 family database, Oracle database, or OLE DB source. This is the first phase of the integration of IBM DataJoiner® into DB2 Universal Database.