IBM Support

Recommended Base Software Stack for InfoSphere Balanced Warehouse E7000 and E7050 for AIX



This document describes the current software stack validated for the InfoSphere Balanced Warehouse E7000 and E7050 for AIX.


The recommendations are based on a philosophy that stability in the InfoSphere Balanced Warehouse takes precedence over functionality and performance. This document provides supplemental information, corrections, and clarifications to the documentation at the IBM InfoSphere Balanced Warehouse download site.

Balanced Warehouse Support strongly recommends that you remain on a validated software and firmware stack for a Balanced Warehouse environment. The software and firmware levels within a validated stack have been tested together by IBM, which helps to ensure that the entire stack is a stable working environment. If you must deviate from a validated stack, consult the FAQ about software and firmware upgrades.

For information about past recommended software stacks, consult the version history of the recommended base software stack.

E7000/E7050 Balanced Warehouse (Based on p5-575 8-core 2.2GHz POWER5+ and DS4800/DS8100)

Current software stack (Jan 24, 2011):

Based on DB2 V9.7

  • AIX 6.1 TL6 SP1
  • DB2 Version 9.7 Fix Pack (FP) 4 -- Updated from FP 3a on March 18, 2011, and then from FP3a special build 26355 on April 21, 2011
  • InfoSphere Warehouse Version 9.7.2
  • IBM Tivoli System Automation for Multiplatforms Version 3.1 FP 7 with RSCT for optional high availability (HA) solutions

Based on DB2 V9.5
  • AIX 6.1 TL6 SP1
  • DB2 Version 9.5 FP 7 -- Updated from FP 6a on April 5, 2011
  • InfoSphere Warehouse Version 9.5.2
  • IBM Tivoli System Automation for Multiplatforms Version 3.1 FP 7 with RSCT for optional high availability (HA) solutions

Current documentation:
  • IBM Balanced Warehouse E7000: Design and Implementation
    -02 refresh (July, 2007)
  • IBM Balanced Warehouse E7050: Design and Implementation
    -01 refresh (July, 2007)

General guidelines:
  • If you update the DS4800 storage controller firmware to, you must use MPIO as the multipath driver because this firmware level does not support RDAC. To check the current driver, issue the following command as the root user:
    manage_disk_drivers -l
    To update the driver to MPIO, issue the following commands:
    manage_disk_drivers -d DS4800 -o AIX_APPCM
    bosboot -ad /dev/ipldevice
    Then reboot the server. For more information about MPIO, see the AIX Information Center.
  • After you update to the new validated AIX level (AIX 6.1 TL6 SP1), it is recommended that you enable medium pages if they were previously disabled. For instructions to enable medium page, follow the steps in this technote. If you are still on the older validated AIX level (AIX 6.1 TL2 SP3), it is recommended that you keep medium pages disabled.
  • Customers using DB2 V9.5 should only enable IOCP if they have upgraded to FP5, which contains the fix for APAR IZ54743. Customers on any level of DB2 V9.7 can also leave IOCP enabled, which is the default behavior on this version of DB2.
  • Ensure that the DB2 Fault Monitor is turned off for all DB2 instances.
    db2fm -i <instancename> -D
    db2fmcu -d
  • For all other parameter settings, consult the Balanced Warehouse documentation.

For details on APARs mentioned in this document and other known issues for DB2 on AIX and previous hardware generations, refer to the document Known issues for DB2 on AIX 5.2, 5.3, 6.1, and 7.1. This document is updated on a regular basis.

For technical support on the Balanced Warehouse for AIX, refer to the document QuickGuide: IBM Technical Support for InfoSphere Balanced Warehouse for AIX.

To receive e-mail notification of changes to this document, sign up for “My Notifications”:
1. Go to the My Notifications Sign In page:
2. If you have an IBM ID and password, sign in. Otherwise, select Register Now and follow the instructions to create an ID.
3. Select the Subscribe tab.
4. Add the following product:
Software > Information Management > InfoSphere Balanced Warehouse
5. Optionally you can add other hardware and software products in your environment.
6. For each product, customize your subscription information, such as the format and frequency of the notifications and the type of notifications you want to receive.

Related information

Documentation download site
All validated InfoSphere Balanced Warehouse stacks
Known issues for DB2 on AIX

Cross reference information
Segment Product Component Platform Version Edition
Information Management DB2 for Linux- UNIX and Windows AIX 9.7, 9.5, 9.1 Enterprise Server

Product Alias/Synonym

IBM Smart Analytics System
InfoSphere Balanced Warehouse
Balanced Configuration Unit (BCU)

Document information

More support for: InfoSphere Balanced Warehouse
Balanced Warehouse E Class - E7000

Software version: 9.1, 9.5, 9.7

Operating system(s): AIX

Software edition: Enterprise

Reference #: 1415641

Modified date: 21 April 2011

Translate this page: