DB2 Version 10.1 for Linux, UNIX, and Windows

Installation prerequisites for DB2 pureScale Feature (AIX)

Before you install IBM® DB2® pureScale® Feature, you must ensure that your system meets specific requirements. You can use the db2prereqcheck command to check the software and firmware prerequisites of a specific DB2 version.
Important: For the most up-to-date installation requirements for DB2 database products, you must start using the System requirements for IBM DB2 for Linux, UNIX, and Windows and System requirements for IBM DB2 Connect™ technotes. These technotes use IBM Software Product Compatibility Reports (SPCR). With the SPCR tool, you can locate and find complete lists of supported operating systems, system requirements, prerequisites, and optional supported software for DB2 database products. This DB2 Information Centre topic might be removed in a future release or fix pack.
Your system meets the following hardware and firmware, software, and storage requirements

Hardware and firmware prerequisites

The DB2 pureScale Feature is supported on any Power® 7 compatible rack mounted server which supports one of these Ethernet RoCE or InfiniBand QDR adapters:
  • PCIe2 2-Port 10GbE RoCE SFP+ Adapter with feature code EC27, EC28, EC29, EC30
  • PCIe2 2-port 4X InfiniBand QDR Adapter with feature code 5283, 5285
Note: Given the widely varying nature of such systems, IBM cannot practically guarantee to have tested on all possible systems or variations of systems. In the event of problem reports for which IBM deems reproduction necessary, IBM reserves the right to attempt problem reproduction on a system that may not match the system on which the problem was reported.

The DB2 pureScale Feature is supported on any RoCE and QDR cable and switch that is supported by the Power 7 servers.

The hardware and firmware requirements for IBM validated servers are listed in these tables later in this section: Servers in a DB2 pureScale environment must use both an Ethernet network and high-speed communication adapter port.
The communication adapter port can be:
  • a 10 Gigabit Ethernet (10GE) network.
  • an InfiniBand (IB) network.
To use a 10GE network all 10GE network adapters and switches must be capable of remote direct memory access (RDMA) over Converged Ethernet (RoCE).
Note: Although a single Ethernet adapter is required on a host for the public network in a DB2 pureScale environment, you should set up Ethernet bonding for the network if you have two Ethernet adapters. Ethernet bonding (also known as channel bonding) is a setup where two or more network interfaces are combined. Ethernet bonding provides redundancy and better resilience in the event of Ethernet network adapter failures. Refer to your Ethernet adapter documentation for instructions on configuring Ethernet bonding.
Table 1. Server-specific hardware details for IBM validated DDR - InfiniBand support1 and required firmware level
Server Minimum Required Platform Firmware level InfiniBand network adapter, GX Dual-port 12x Channel Attach - DDR InfiniBand Channel adapter InfiniBand Channel conversion cables
IBM POWER7® 795 (9119-FHB) * AH720_102 or higher Feature Code 1816 12x to 4x (Feature Code 1828, 1841, or 1854)
IBM POWER7 780 (9179-MHB) * AM720_102 or higher Feature Code 1808 12x to 4x (Feature Code 1828, 1841, or 1854)
IBM POWER7 780 (9179-MHC) * AM740_042 or higher Feature Code 1808 12x to 4x (Feature Code 1828, 1841, or 1854)
IBM POWER7 770 (9117-MMB) * AM720_102 or higher Feature Code 1808 12x to 4x (Feature Code 1828, 1841, or 1854)
IBM POWER7 770 (9117-MMC) * AM740_042 or higher Feature Code 1808 12x to 4x (Feature Code 1828, 1841, or 1854)
IBM POWER7 750 (8233-E8B) AL730_049 or higher Feature Code 5609 12x to 4x (Feature Code 1828, 1841, or 1854)
IBM POWER7 740 (8205-E6C) AL720_102 or higher Feature Code EJ04 12x to 4x (Feature Code 1828, 1841, or 1854)
IBM POWER7 740 (8205-E6B) AL720_102 or higher Feature Code 5615 12x to 4x (Feature Code 1828, 1841, or 1854)
IBM POWER7 730 (8231-E2B) AL720_102 or higher Feature Code 5266 4x to 4x cables (Feature Code 3246)
IBM POWER7 720 (8202-E4C) AL720_102 or higher Feature Code EJ04 12x to 4x (Feature Code 1828, 1841, or 1854)
IBM POWER7 720 (8202-E4B) AL720_102 or higher Feature Code 5615 12x to 4x (Feature Code 1828, 1841, or 1854)
IBM POWER7 710 (8231-E2B) AL720_102 or higher Feature Code 5266 4x to 4x cables (Feature Code 3246)
IBM POWER6® 595 (9119-FHA) EH350_071 or higher Feature Code 1816 12x to 4x (Feature Code 1828, 1841, or 1854)
IBM POWER6 550 Express (8204-E8A) EL350_071 or higher Feature Code 5609 12x to 4x (Feature Code 1828, 1841, or 1854)
Note:
  1. Although the purchasing of DDR IB hardware is no longer available, DB2 for Linux, UNIX, and Windows still supports configurations with DDR IB.
  2. When acquiring systems, consider the I/O ports available and future workloads for greater flexibility and scalability. The servers marked with an asterisk (*) are designed for enterprise applications. For more information about selecting the hardware, see "Site and hardware planning" in the IBM System Hardware documentation: http://publib.boulder.ibm.com/infocenter/powersys/v3r1m5/index.jsp.
  3. InfiniBand Channel conversion cables are available in multiple lengths, each with a different product feature code (FC). Some different 12x to 4x InfiniBand Channel conversion cable lengths available are 1.5 m (FC 1828), 3 m (FC 1841), and 10 m (FC 1854). Your data center layout and the relative location of the hardware in the DB2 pureScale environment are factors that must be considered when selecting the cable length.
Table 2. Server-specific hardware details for IBM validated QDR - InfiniBand support and required firmware level
Server Minimum Required Platform Firmware level PCle2 Dual port QDR InfiniBand Channel adapter
IBM POWER7 780/HE (9179-MHC) AM740_042_042 PCIe2 2-port 4X InfiniBand QDR Adapter (Feature code: 5285)
IBM POWER7 770/MR (9117-MMC) AM740_042_042 PCIe2 2-port 4X InfiniBand QDR Adapter (Feature code: 5285)
IBM POWER7 740 2S (8205-E6C with optional low-profile slots) AL740_043_042 PCIe2 2-port 4X InfiniBand QDR Adapter (Feature code: 5285), or PCIe2 Low Profile 2-port 4X InfiniBand QDR Adapter (Feature code: 5283) in the PCIe Newcombe Riser Card (Feature code: 5685), or both
IBM POWER7 740 (8205-E6B) with Newcombe (optional low-profile Gen2 slots) AL720_102 PCIe2 Low Profile 2-port 4X InfiniBand QDR Adapter (Feature code: 5283) in the PCIe Newcombe Riser Card (Feature code: 5685)
IBM POWER7 710 (8231-E1C) AL740_043_042 PCIe2 Low Profile 2-port 4X InfiniBand QDR Adapter (Feature code: 5283) in the PCIe Newcombe Riser Card (Feature Code: 5685)
IBM POWER7 720 (8202-E4B) AL730_066_035 PCIe2 Low Profile 2-port 4X InfiniBand QDR Adapter (Feature code: 5283) in the PCIe Newcombe Riser Card (Feature Code: 5685)
IBM POWER7 720 (8202-E4C) AL740_043_042 PCIe2 2-port 4X InfiniBand QDR Adapter (Feature code: 5285), or PCIe2 Low Profile 2-port 4X InfiniBand QDR Adapter (Feature code: 5283) in the PCIe Newcombe Riser Card (Feature code: 5685), or both
IBM POWER7 730 2S (8231-E2C) AL740_043_042 PCIe2 Low Profile 2-port 4X InfiniBand QDR Adapter (Feature code: 5283) in the PCIe Newcombe Riser Card (Feature Code: 5685)
Note:
  • Although the purchasing of QDR IB switches is no longer available through IBM, DB2 for Linux, UNIX, and Windows still supports configurations with QDR IB switches supported by Intel.
  • QDR IB adapters do not support virtualization. Each LPAR requires a dedicated QDR IB adapter. For example, if a machine is has two LPARs (one for CF and one for member), each of these LPARs must have its own dedicated QDR IB adapter.
Table 3. Server-specific hardware details - IBM validated RDMA over Converged Ethernet (RoCE) support and required firmware level
Server Minimum Required Platform Firmware level PCIe Support for RoCE network adapters
IBM POWER7 780/HE (9179-MHC) AM740_042_042 PCIe2 2-Port 10GbE RoCE SFP+ Adapter (Feature code EC28) (Copper)

PCIe2 2-Port 10GbE RoCE SR Adapter (Feature code EC30) (Optical)

IBM POWER7 770/MR (9117-MMC) AM740_042_042 PCIe2 2-Port 10GbE RoCE SFP+ Adapter (Feature code EC28) (Copper)

PCIe2 2-Port 10GbE RoCE SR Adapter (Feature code EC30) (Optical)

IBM POWER7 780/HE (9179-MMD) AM760_034_034 PCIe2 2-Port 10GbE RoCE SFP+ Adapter (Feature code EC28) (Copper)

PCIe2 2-Port 10GbE RoCE SR Adapter (Feature code EC30) (Optical)

IBM POWER7 770/MR (9117-MMD) AM760_034_034 PCIe2 2-Port 10GbE RoCE SFP+ Adapter (Feature code EC28) (Copper)

PCIe2 2-Port 10GbE RoCE SR Adapter (Feature code EC30) (Optical)

IBM POWER7 720 1S (8202-E4C with optional low-profile slots) AL740_043_042 PCIe2 2-Port 10GbE RoCE SFP+ Adapter (Feature code EC28) (Copper)

PCIe2 2-Port 10GbE RoCE SR Adapter (Feature code EC30) (Optical)

PCIe2 Low Profile 2-Port 10GbE RoCE SFP+ Adapter (Feature code EC27) (Copper) in the PCIe Newcombe Riser Card (Feature code 5685)

PCIe2 Low Profile 2-Port 10GbE RoCE SR Adapter (Feature code EC29) (Optical) in the PCIe Newcombe Riser Card (Feature code 5685)

IBM POWER7 740 2S (8205-E6C with optional low-profile slots) AL740_043_042 PCIe2 2-Port 10GbE RoCE SFP+ Adapter (Feature code EC28) (Copper)

PCIe2 2-Port 10GbE RoCE SR Adapter (Feature code EC30) (Optical)

PCIe2 Low Profile 2-Port 10GbE RoCE SFP+ Adapter (Feature code EC27) (Copper) in the PCIe Newcombe Riser Card (Feature code 5685)

PCIe2 Low Profile 2-Port 10GbE RoCE SR Adapter (Feature code EC29) (Optical) in the PCIe Newcombe Riser Card (Feature code 5685)

IBM POWER7 710 1S (8231-E1C) AL740_043_042 PCIe2 Low Profile 2-Port 10GbE RoCE SFP+ Adapter (Feature code EC27) (Copper)

PCIe2 Low Profile 2-Port 10GbE RoCE SR Adapter (Feature code EC29) (Optical)

IBM POWER7 730 2S (8231-E2C) AL740_043_042 PCIe2 Low Profile 2-Port 10GbE RoCE SFP+ Adapter (Feature code EC27) (Copper)

PCIe2 Low Profile 2-Port 10GbE RoCE SR Adapter (Feature code EC29) (Optical)

IBM Flex System® p260 Compute Node (7895-22X) AF763_042 EN4132 2-port 10Gb RoCE Adapter (Feature code EC26)
IBM Flex System p260 Compute Node (7895-23X) AF763_042 EN4132 2-port 10Gb RoCE Adapter (Feature code EC26)
IBM Flex System p460 Compute Node (7895-42X) AF763_042 EN4132 2-port 10Gb RoCE Adapter (Feature code EC26)
Note: RoCE adapters do not support virtualization. Each LPAR requires a dedicated RoCE adapter. For example, if a machine is has two LPARs (one for CF and one for member), each of these LPARs must have its own dedicated RoCE adapter.

10GE Cable Information:

Table 4. IBM Qualified Copper SFP+ (10GE) Cable Information
  1 meter 3 meter 5 meter
Feature Code number EN01 EN02 EN03
Note:
  • IBM Qualified Copper SFP+ cables or standard 10-Gb SR optical cabling (up to 300 meter cable length) can be used for connecting RoCE adapters to the 10GE switches.
Table 5. IBM Qualified QSFP+ Cable Information for 10GE RoCE
  1 meter 3 meter
Feature Code number EB2B EB2H
Note:
  • IBM Qualified QSFP+ cables can be used as inter-switch links between Power Flex System 10GE switches.
Table 6. QDR IB cable information (1, 3, 5, 10, 30 meters)
  1 meter (copper) 3 meter (copper) 5 meter (copper) 10 meter (optical) 30 meter (optical)
Feature Code number 3287 3288 3289 3290 3293
Table 7. Supported InfiniBand network switches
InfiniBand switch Intel model number Number of ports Type Required rack space
IBM 7874-024 9024 24 4x DDR InfiniBand Edge Switch 1U
IBM 7874-040 9040 48 4x DDR InfiniBand Fabric Director Switch 4U
IBM 7874-120 9102 128 4x DDR InfiniBand Fabric Director Switch 7U
IBM 7874-240 9240 288 4x DDR InfiniBand Fabric Director Switch 14U
IBM 7874-036 12200 36 QDR InfiniBand Switch 1U
IBM 7874-072 12800-040 72 QDR InfiniBand Switch 5U
IBM 7874-324 12800-180 324 QDR InfiniBand Switch 14U
Note:
  • All of the InfiniBand switches listed in the previous table must use the embedded subnet management functionality. When ordering InfiniBand switches from Intel, management modules must be purchased for the switch.
  • Although the purchasing of IB switches is no longer available through IBM, DB2 for Linux, UNIX, and Windows still supports configurations with IB switches supported by Intel.
  • If using two switches in the DB2 pureScale environment, two or more 4x to 4x inter-switch links (ISL) are required. To help with performance and fault tolerance to inter-switch link failures, use half the number of inter-switch link cables as there are total communication adapter ports connected from CFs and members to the switches. For example, in a two switch DB2 pureScale environment where the primary and secondary CF each has four cluster interconnect netnames, and there are four members, use 6 inter-switch links (6 = (2 x 4 + 4) /2). Choose 4x to 4x InfiniBand ISL cables of appropriate length for your network environment.

DDR and QDR InfiniBand network switch types cannot be intermixed. The same type of switch, adapter and cables must be used in a cluster. A server using a DDR IB adapter must use a DDR type switch and the corresponding cables. A server using a QDR IB adapter must use a QDR type switch and the corresponding cables.

In general, any 10GE switch that supports global pause flow control, as specified by IEEE 802.3x is also supported.
Table 8. IBM validated 10GE switches for RDMA
IBM Validated Switch
Blade Network Technologies® RackSwitch™ G8124
Juniper Networks QFX3500 Switch
Note:
  • IBM Qualified Copper SFP+ cables or standard 10-Gb SR optical cabling (up to 300 meter cable length) can be used as inter-switch links. Cables that are 3 meter or 7 meter SFP+ cables supplied by Juniper can be used between Juniper switches.
  • For the configuration and the features that are required to be enabled and disabled, see Configuring switch failover for a DB2 pureScale environment on a 10GE network (AIX). However, the exact setup instructions might differ from what is documented in the switch section, which is based on the IBM validated switches. Refer to the switch user manual for details.

Storage hardware requirements

DB2 pureScale Feature supports all storage area network (SAN) and directly attached shared block storage. Configuring DB2 cluster services managed shared storage is recommended for better resiliency. For more information about DB2 cluster services support, see the “Shared storage considerations” topic. The following storage hardware requirements must be met for DB2 pureScale Feature support.
  • The following local free disk space on each host:
    • 3 GB to extract the installation
    • 6 GB for the Installation path
    • 5 GB for the /tmp directory
    • 5 GB for the instance home directory
    • 5 GB for the /var directory.
  • A minimum of three shared file systems are required, each on a separate physical disk. A fourth shared disk is recommended to configure as the DB2 cluster services tiebreaker disk.

    The following minimum shared disk space must be free for each file system:
    • Instance shared files: 10 GB1
    • Data: dependent on your specific application needs
    • Logs: dependent on the expectant number of transactions and the applications logging requirements
Note: If the host memory is not enough, you can install the product but cannot start the database instance. Memory requirement is different based on the total number of the database or instances existing on the same host.

Software prerequisites

The AIX® operating system version levels, technology levels, and required fixes are listed by supported adapters and switch types:
Before running the installation, or the installFixPack command, ensure that fixes are applied for your operating system.
Table 9. Specific software requirements for DDR InfiniBand adapters and switches - AIX operating system version and technology levels
AIX version Technology Level Minimum Service Pack (SP) level Required uDAPL level uDAPL APAR AIX APAR
AIX 6.1 6 5 6.1.6.15   IV01781 (included in SP6)*
AIX 6.1 7 1 6.1.7.0    
AIX 6.1 7 3 6.1.7.1    
AIX 6.1 7 5 6.1.7.15    
AIX 6.1 8 1 6.1.8.0 IV35889* IV34702 (included in SP2)
AIX 6.1 9 1 6.1.9.01    
AIX 7.1 0 3 7.1.0.15   IV02136 (included in SP4)*
AIX 7.1 1 1 7.1.1.0    
AIX 7.1 1 3 7.1.1.2    
AIX 7.1 1 5 7.1.1.15    
AIX 7.1 2 1 7.1.2.0 IV35894* IV34702 (included in SP2)
AIX 7.1 3 1 7.1.3.01    
Note:
  1. Starting on AIX 6.1 TL9 and AIX 7.1 TL3, the uDAPL version required is the uDAPL level that is included in the AIX image. This is subject to change with respect to Technology Level and Service Pack level.
  2. To download IV35889, see ftp://public.dhe.ibm.com/aix/ifixes/iv35889/.
  3. To download IV35894, see ftp://public.dhe.ibm.com/aix/ifixes/iv35889/.
Table 10. Specific software requirements for QDR InfiniBand adapters and switches - AIX operating system version and technology levels
AIX version Technology Level Minimum Service Pack (SP) level Required uDAPL level uDAPL APAR AIX APAR
AIX 6.1 7 5 6.1.7.15   IV263831
AIX 6.1 8 1 6.1.8.0 IV35889* IV34702 (included in SP2)
AIX 6.1 9 1 6.1.9.05    
AIX 7.1 1 5 7.1.1.15   IV263842
AIX 7.1 2 1 7.1.2.0 IV35894* IV34702 (included in SP2)
AIX 7.1 3 1 7.1.3.05    
Note:
  1. InfiniBand IV26383.epkg.Z ifix is available via FTP from: ftp://public.dhe.ibm.com/aix/ifixes/iv26383/.
  2. InfiniBand IV26384.epkg.Z ifix is available via FTP from: ftp://public.dhe.ibm.com/aix/ifixes/iv26384/.
  3. To download IV35889, see ftp://public.dhe.ibm.com/aix/ifixes/iv35889/.
  4. To download IV35894, see ftp://public.dhe.ibm.com/aix/ifixes/iv35889/.
  5. Starting on AIX 6.1 TL9 and AIX 7.1 TL3, the uDAPL version required is the uDAPL level that is included in the AIX image. This is subject to change with respect to Technology Level and Service Pack level.
Table 11. Specific software requirements for RoCE - AIX operating system version and technology levels
AIX version Technology Level Minimum Service Pack (SP) level Required uDAPL level uDAPL APAR AIX APAR
AIX 6.1 7 3 6.1.7.2 (updated with IV20240)   IV20240
AIX 6.1 7 5 6.1.7.15    
AIX 6.1 8 1 6.1.8.0 IV35889* IV34702 (included in SP2)
AIX 6.1 9 1 6.1.9.01    
AIX 7.1 1 3 7.1.1.2 (updated with IV20241)   IV20241
AIX 7.1 1 5 7.1.1.15    
AIX 7.1 2 1 7.1.2.0 IV35894* IV34702 (included in SP2)
AIX 7.1 3 1 7.1.3.01    
Note:
  1. Starting on AIX 6.1 TL9 and AIX 7.1 TL3, the uDAPL version required is the uDAPL level that is included in the AIX image. This is subject to change with respect to Technology Level and Service Pack level.
  2. Download and install the uDAPL package at the base Technology Level (not the uDAPL packages specific to a fix pack) from the AIX Web Download Pack Programs website, see https://www14.software.ibm.com/webapp/iwm/web/reg/signup.do?source=aixbp&lang=en_US&S_PKG=udapl. After installing the base uDAPL package, apply the appropriate uDAPL fix for the Technology Level from the IBM Support portal, see https://www-304.ibm.com/support/docview.wss?q1=U830315&dc=DB510&rs=1209&uid=isg1fileset664799651&cs=UTF-8&lang=en&loc=en_US.
  3. If the AIX system is running on a Technology Level with the minimum Service Pack specified in the table, all APARs listed in the row must be installed except for AIX APARs marked with an asterisk (*). The asterisk marked APARs are only required for DB2 pureScale environments with multiple switches. For a system that runs on a Technology Level with a later Service Pack, verify whether the APAR fix is included in the Service Pack level. The first Service Pack the APAR fix is included in is in the table next to the APAR in parentheses. To obtain fixes for the APARs for a system running a Service Pack higher than the minimum required and lower than the Service Pack the fix was first included in, see IBM Support Fix Central: http://www-933.ibm.com/support/fixcentral/.
  4. On RoCE networks, after the AIX APAR is applied, the uDAPL level will change.
  5. To download IV35889, see ftp://public.dhe.ibm.com/aix/ifixes/iv35889/.
  6. To download IV35894, see ftp://public.dhe.ibm.com/aix/ifixes/iv35889/.
Required Software:
Note:
  • AIX workload partitions (WPARs) are not supported in a DB2 pureScale environment.
  • Version 10.1 Fix Pack 4 (and higher fix packs):
    • GPFS: If you have IBM General Parallel File System ( GPFS) installed, it must be GPFS 3.5.0.17. If you need to upgrade to this GPFS level or install the GPFS fixes, the required files are found on the DB2 pureScale installation image in the /db2/aix/gpfs/efix directory.
    • Tivoli® SA MP:If you have IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP), it must be Version 3.2.2.5.
  • Version 10.1 Fix Pack 3:
    • GPFS: If you have GPFS installed, it must be GPFS 3.5.0.7 (TL2) with efix10. If you need to upgrade to this GPFS level or install the GPFS fixes, the required files are found on the DB2 pureScale installation image in the /db2/aix/gpfs/efix directory.
    • Tivoli SA MP:If you have Tivoli SA MP installed, it must be Version 3.2.2.5.
  • Version 10.1 Fix Pack 2 (and earlier fix packs):
    • GPFS: If you have GPFS already installed, it must be GPFS 3.5 PTF4 + efix 13. If the existing level is below this level, the installation of DB2 pureScale Feature will not install the required GPFS level automatically, users must perform a manual upgrade of GPFS to the required level. If the existing level is higher than the required level, the installation of DB2 pureScale Feature will skip the GPFS update and use the existing version.
    • Tivoli SA MP: If you have Tivoli SA MP installed, it must be Tivoli SA MP 3.2.2.1 + efix 2 + RSCT Joplin PTF7. The installation of DB2 pureScale Feature upgrades existing Tivoli SA MP installations to this version level.
  • Version 10.1 Fix Pack 1:
    • GPFS: If you have GPFS already installed, it must be GPFS 3.4.0.14 + efix 4. If the existing level is below this level, the installation of DB2 pureScale Feature will not install the required GPFS level automatically, users must perform a manual upgrade of GPFS to the required level. If the existing level is higher than the required level, the installation of DB2 pureScale Feature will skip the GPFS update and use the existing version.
    • Tivoli SA MP: If you have Tivoli SA MP installed, it must be Tivoli SA MP 3.2.2.1 with RSCT Joplin PTF 5. The installation of DB2 pureScale Feature upgrades existing Tivoli SA MP installations to this version level.
  • Version 10.1 General Availability (GA):
    • GPFS: If you have GPFS already installed, it must be GPFS 3.4.0.11. If the existing level is below this level, the installation of DB2 pureScale Feature will not install the required GPFS level automatically, users must perform a manual upgrade of GPFS to the required level. If the existing level is higher than the required level, the installation of DB2 pureScale Feature will skip the GPFS update and use the existing version.
    • Tivoli SA MP: If you have Tivoli SA MP installed, it must be Tivoli SA MP 3.2.2.1 (integrated) with RSCT 3.1.2.1 (Joplin PTF 2). The installation of DB2 pureScale Feature upgrades existing Tivoli SA MP installations to this version level.
1 For better I/O performance, create a separate GPFS™ file system to hold your database and specify this shared disk on the create database command.