IBM Support

Frequently Asked Questions (FAQs) about InfoSphere Warehouse

Technote (FAQ)


1. Has InfoSphere Warehouse been known by other names?
2. Does InfoSphere Warehouse have any fix packs?
3. What is the difference between an interim fix, a test fix, a fix pack and a refresh pack?
4. What updates are available for InfoSphere Warehouse?
5. Can DB2 fixpacks be applied with InfoSphere Warehouse?
6. Can one install InfoSphere Warehouse v9.5.x, 9.7.x, or 10.1.0.x after DB2 v9.5, v9.7, or v10.1 fix pack has been applied?
7. How does one acquire InfoSphere Warehouse refresh packs?
8. How does one acquire InfoSphere Warehouse interim fixes?
9. How to find out which fixpack or Interim fix installed?


Answers to the above questions that are frequently asked by customers.
1. This product has had three names:

  • Through version 9.1.2, the product name was DB2® Data Warehouse Edition (aka DWE) -- out of service now
  • In version 9.5, the product name was DB2 Warehouse (aka DB2W)
  • In version 9.5.1, the product name was changed to InfoSphere Warehouse (aka ISW)
  • In version 10.5, the product name was changed back to DB2 Warehouse as it becomes part of the DB2 family again (aka DB2W)

2. InfoSphere Warehouse (ISW) does not have fix packs. Instead, ISW has released refresh packs which are available for ISW v9.5.1, v9.5.2, v9.7.1, v9.7.2, v9.7.3, v9.7.7 and v10.1.0.2

3. An interim or test fix resolves a particular defect or series of defects in a particular component (for example, SQL Warehousing Tool).

An interim fix is a certified fix that is generally available to all customers between regularly scheduled fix packs, refresh packs, or releases.

A test fix is a temporary fix that is supplied to specific customers for testing in response to a reported problem.

A fix pack is a cumulative collection of fixes that has been fully tested by IBM. In some cases, a fix pack may include new functionality. Depending on the product, a fix pack may require the existence of the base product before it can be applied. Fix packs increment the release fix, the 'F' in the V.R.M.F. sequence.

A refresh pack is a cumulative collection of fixes that also includes new functionality. A refresh pack has been fully tested by IBM. Depending on the product, a refresh pack may require the existence of the base product before it can be applied. Refresh packs increment the release modification, the 'M" in the V.R.M.F. sequence.

4. InfoSphere Warehouse has released refresh packs for v9.5, v9.7

These refresh packs can be installed standalone or on top of the base product. For instance, if a system has v9.5.0 installed, v9.5.1 can be installed over top. Likewise, if a system does not have any version of InfoSphere Warehouse installed, one can choose to install v9.5.1 directly onto this clean system. ISW v9.5.0 does not need to installed prior to v9.5.1.

5. Once InfoSphere Warehouse is installed, DB2 fix packs can be applied. For instance, DB2 v9.5 fix pack 3 could be installed with InfoSphere Warehouse v9.5.

Refer to this URL which shows the DB2 fix packs available for the various versions of DB2.

6. Yes, ISW v9.5.x, v9.7.x, or v10.1.0.x can be installed even after one has applied a fix pack to DB2 v9.5, v9.7, or v10.1.

7. To acquire the various InfoSphere Warehouse refresh packs, please refer to the appropriate URL.

To acquire InfoSphere Warehouse v9.5.1 :

To acquire InfoSphere Warehouse v9.5.2 :

To acquire InfoSphere Warehouse v9.7.2:

To acquire InfoSphere Warehouse v9.7.3:

To acquire InfoSphere Warehouse v9.7.7:

To acquire InfoSphere Warehouse v10.1.0.2:

8. Interim fixes are available by contacting InfoSphere Warehouse Technical Support via a Problem Management Record (PMR).

9: version.txt file which located under <InfoSphere Warehouse installation directory> contains information of which version of InfoSphere Warehouse has been installed, it includes fixpack and interim fix information.

Document information

More support for: InfoSphere Warehouse

Software version: 9.5, 9.5.1, 9.5.2, 9.7.0, 9.7.2, 9.7.3, 9.7.7, 10.1,, 10.5

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: Edition Independent

Reference #: 1414309

Modified date: 2014-08-06