Overview of data warehousing in Db2

Data warehousing in Db2® is a suite of products that combines the strength of Db2 with a data warehousing infrastructure from IBM®.

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

Starting with data warehousing in Db2, Version 10.5.x fix pack 4 you can no longer install other Db2 software with the data warehousing in Db2 installer. You can only install data warehousing in Db2.

The following components are provided in data warehousing in Db2:

Data warehousing in Db2 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 data warehousing in Db2 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 data warehousing in Db2. Instead, you can migrate to Cognos® Dynamic Cubes. For more information, see Cognos Dynamic Cubes overview
  • IBM Data Server Client
  • WebSphere® Application Server
Data warehousing in Db2 client
  • Design Studio
    • SQL Warehousing (SQW) Tool
  • Administration Console Command Line Client