This section contains information on products and packages that have joined the DB2 family or have changed for Version 7.
This new offering brings together the tools to build, manage, govern, and access DB2 data warehouses. The DB2 Warehouse Manager simplifies and speeds warehouse prototyping, development, and deployment. It gives the data center the control for governing queries, analyzing costs, managing resources, and tracking usage. It helps satisfy user requirements for finding, accessing, and understanding information. It provides flexible tools and techniques for building, managing, and accessing the warehouse. And it meets the most common reporting needs for enterprises of any size.
The DB2 Warehouse Manager adds to the basic warehouse and analytical functions available in DB2 Universal Database by providing:
The offering applies to DB2 Universal Database Enterprise Edition and Enterprise - Extended Edition only.
QMF for Windows is included with the DB2 Warehouse Manager. It provides a multipurpose query tool for business reporting, data sharing, server resource protection, robust application development, and native connectivity to all of the DB2 workstation platforms.
QMF for Windows provides native support for TCP/IP connectivity to Version 5 and later. It is architecturally coupled with DB2 using Distributed Relational Database Architecture (DRDA). Support for a heterogeneous database environment is available through DB2 DataJoiner, which allows users to access other vendor and non-relational workstation databases. See QMF for more Version 7 information.
Query Patroller for DB2 Universal Database is now available for Enterprise Edition and provides support for HP-UX and NUMA-Q, in addition to Windows 32-bit operating systems, AIX, and Solaris platforms. This allows you to manage, govern, and schedule business analysis queries and to more fully utilize the resources available on those DB2 servers. See Query Patroller for other Version 7 enhancements.
DB2 Query Patroller is now part of the Warehouse Manager offering.
DB2 Relational Connect enhances the distributed request functionality included with DB2 Universal Database by allowing users and applications to access data stored in Oracle databases. This can be used in conjunction with built-in distributed query capabilities to formulate queries across DB2, Oracle, and OLE DB databases. It can also be used with the Data Warehouse Center to accelerate select performance from Oracle sources for loading a DB2 data warehouse (see Native OLE DB Support).
A DB2 Universal Database system that has been configured as a federated system and on which DB2 Relational Connect has been installed is capable of referencing multiple DB2 family and Oracle databases within a single query. A federated system is a database management system (DBMS) that supports applications and users submitting SQL statements referencing two or more DBMSs or databases in a single statement. For more information about federated database concepts, see the Administration Guide: Planning.
DB2 Relational Connect is supported on DB2 Universal Database Enterprise Edition or DB2 Universal Database Enterprise - Extended Edition for Windows 32-bit operating systems and AIX systems.
In Version 7, a Workgroup Edition of DB2 is available for all DB2 supported UNIX-based platforms (except for NUMA-Q).
DB2 Universal Database includes the DB2 OLAP Starter Kit which is functionally based on DB2 OLAP Server Version 7. The DB2 OLAP Server Starter Kit lets users of DB2 Universal Database explore and apply online analytical capabilities before acquiring the full product, DB2 OLAP Server, for more complex analysis or deployment to large groups of users. Applications developed by the DB2 OLAP Starter Kit can continue to be extended and used in the full product. Both the DB2 OLAP Starter Kit and DB2 OLAP Server are based on Essbase, the market-leading OLAP technology from Hyperion Solutions. See OLAP Capability for more information.
The DB2 Spatial Extender can now be hosted directly by DB2 Universal Database. This facilitates the inclusion of spatial attributes, such as distance or driving time, into business analyses. This integration allows spatial data to exploit the performance benefits available with a database management system (DBMS). DB2 Spatial Extender conforms to the OpenGIS Consortium (OGS) and ISO standards for storing, indexing, and querying spatial data. See the Spatial Extender User's Guide and Reference for more information.
DB2 Universal Database Net Search Extender provides a high performance method of searching text stored in DB2 databases. Searching with it can be particularly advantageous in Internet applications where performance is an important factor.
Net Search Extender can add the power of fast full-text retrieval to Net.Data, Java, and CLI applications. Its features let you store unstructured text documents of up to 2 gigabytes in databases. It offers application developers a fast, versatile, and intelligent method of searching through such documents.
The Software Developer's Kit is now called the DB2 Application Development Client.