Overview of DB2 Warehouse

DB2® Warehouse is a suite of products that combines the strength of DB2 with a data warehousing infrastructure from IBM®.

You can use DB2 Warehouse to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, and front-end analysis tools.

Starting with DB2 Warehouse, Version 10.5.x fix pack 4 you can no longer install other DB2 software with theDB2 Warehouse installer. You can only install DB2 Warehouse.

The following components are provided in DB2 Warehouse:

DB2 Warehouse application server
  • Administration Console
    • SQL Warehousing (SQW) administration
    • Cubing Services administration
      • If you already have Cubing Services installed on your system, you can continue to use it when you upgrade your version of DB2 Warehouse to the newest version. However, if Cubing Services is not already installed on your system, then it is not an option as you upgrade to the newest version of DB2 Warehouse. Instead, you can migrate to Cognos® Dynamic Cubes. For more information, see Cognos Dynamic Cubes overview
  • IBM Data Server Client
  • WebSphere® Application Server
DB2 Warehouse client
  • Design Studio
    • SQL Warehousing (SQW) Tool
  • Administration Console Command Line Client


Feedback | Information roadmap