This topic describes the Db2 (DBMS) versions that are supported by Delphix, as well as the compatible operating systems (OS), for use on target and source environments.


Supported DBMS Versions

  • Db2 Enterprise Server Edition 10.5
  • Db2 Advanced Enterprise Server Edition 10.5
  • Db2 Enterprise Server Edition 11.1
  • Db2 Advanced Enterprise Server Edition 11.1
  • Db2 Developer Edition 11.1 (on RHEL 6.7)

Supported Operating Systems

  1. ESE: Enterprise Server Edition
  2. AESE: Advanced Enterprise Server Edition
  3. As of Delphix Engine 5.1.6 - For the supported Db2 versions, Delphix supports the corresponding Db2 Developer edition where the vendor, IBM, supports it
  4. 64-bit OS support only

Red Hat Enterprise Linux (RHEL) 

ESE and AESE Support

Supported DBMS Version

ESE 10.5AESE 10.5ESE 11.1AESE 11.1




Supported OS Version
RHEL 6.0Not SupportedNot SupportedNot SupportedNot Supported
RHEL 6.1Not SupportedNot SupportedNot SupportedNot Supported
RHEL 6.2Not SupportedNot SupportedNot SupportedNot Supported
RHEL 6.3Not SupportedNot SupportedNot SupportedNot Supported
RHEL 6.4SupportedSupportedNot SupportedNot Supported
RHEL 6.5SupportedSupportedNot SupportedNot Supported
RHEL 6.6SupportedSupportedNot SupportedNot Supported
RHEL 6.7SupportedSupportedSupportedSupported
RHEL 6.8SupportedSupportedSupportedSupported
RHEL 6.9SupportedSupportedSupportedSupported
RHEL 7.0SupportedSupportedSupportedSupported
RHEL 7.1SupportedSupportedSupportedSupported
RHEL 7.2SupportedSupportedSupportedSupported
RHEL 7.3SupportedSupportedSupportedSupported
RHEL 7.4SupportedSupportedSupportedSupported
RHEL 7.5SupportedSupportedSupportedSupported
RHEL 7.6SupportedSupportedSupportedSupported

Supported Db2 Fixpack with Delphix Engine

Delphix does not support different Db2 versions for interdependent datasets at the same time if they are in a parent-child relationship. VDB provision or refresh may fail in the case where the instance containing its parent dataset is on a different Db2 version. Before you upgrade the Db2 version of the instance containing the VDB dataset, ensure that the instance containing the parent dataset is also upgraded to the same version. Refer to the Db2 support matrix.

Db2 11.1 Fix Packs 

Db2 11. Fix Packs Non-HADR (including archive log support) Linking

SourceStaging
11.1.1.111.1.2.211.1.3.311.1.4.4
11.1.1.1SupportedSupportedSupportedSupported
11.1.2.2Not SupportedSupportedSupportedSupported
11.1.3.3

Not Supported

SupportedSupportedSupported
11.1.4.4Not SupportedSupportedSupportedSupported

Db2 11. Fix Packs HADR Linking

SourceStaging
11.1.1.111.1.2.211.1.3.311.1.4.4
11.1.1.1SupportedSupportedSupportedNot Supported
11.1.2.2Not SupportedSupportedSupportedNot Supported
11.1.3.3

Not Supported

SupportedSupportedNot Supported
11.1.4.4Not SupportedNot SupportedNot SupportedSupported

Db2 11. Fix Packs Provisioning

StagingTarget
11.1.1.111.1.2.211.1.3.311.1.4.4
11.1.1.1SupportedSupportedSupportedSupported
11.1.2.2Not SupportedSupportedSupportedSupported
11.1.3.3

Not Supported

SupportedSupportedSupported
11.1.4.4Not SupportedSupportedSupportedSupported

Db2 10.5 Fix Packs

Db2 10.5 Fix Packs - NON HADR linking

SourceStaging
10.5.0.110.5.0.210.5.0.310.5.0.410.5.0.510.5.0.610.5.0.710.5.0.810.5.0.910.5.0.10
10.5.0.1SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.2SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.3SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.4SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.5SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.6SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.7SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.8SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.9SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.10SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported

Db2 10.5 Fix Packs - HADR Linking

SourceStaging
10.5.0.110.5.0.210.5.0.310.5.0.410.5.0.510.5.0.610.5.0.710.5.0.810.5.0.910.5.0.10
10.5.0.1SupportedNot SupportedNot SupportedNot SupportedNot SupportedSupportedSupportedSupportedSupportedNot Supported
10.5.0.2Not SupportedSupportedNot SupportedNot SupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.3Not SupportedNot SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.4Not SupportedNot SupportedNot SupportedSupportedNot SupportedSupportedSupportedSupportedSupportedSupported
10.5.0.5Not SupportedNot SupportedNot SupportedNot SupportedSupportedNot SupportedSupportedSupportedSupportedSupported
10.5.0.6Not SupportedNot SupportedNot SupportedNot SupportedNot SupportedSupportedSupportedSupportedSupportedSupported
10.5.0.7Not SupportedNot SupportedNot SupportedNot SupportedNot SupportedNot SupportedSupportedSupportedSupportedSupported
10.5.0.8Not SupportedNot SupportedNot SupportedNot SupportedNot SupportedNot SupportedNot SupportedSupportedSupportedSupported
10.5.0.9Not SupportedNot SupportedNot SupportedNot SupportedNot SupportedNot SupportedNot SupportedNot SupportedSupportedSupported
10.5.0.10Not SupportedNot SupportedNot SupportedNot SupportedNot SupportedNot SupportedNot SupportedNot SupportedNot SupportedSupported

Db2 10.5 Fick Packs HADR-NON HADR Provision

StagingTarget
10.5.0.110.5.0.210.5.0.310.5.0.410.5.0.510.5.0.610.5.0.710.5.0.810.5.0.910.5.0.10
10.5.0.1SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.2SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.3SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.4SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.5SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.6SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.7SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.8SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.9SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported
10.5.0.10SupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupportedSupported

Advanced Interactive eXecutive (AIX)


Supported DBMS Version

ESE 10.5AESE 10.5ESE 11.1AESE 11.1


 Supported OS Version
AIX 6.1Not SupportedNot SupportedN/AN/A
AIX 7.1SupportedSupportedSupported
Supported
AIX 7.2Supported
Supported
SupportedSupported

Plugin/Delphix Engine Compatibility

Plugins should be installed on compatible Delphix Engines per the table below:

Delphix EngineDb2_2.0.1Db2_2.1.0Db2_2.2.1Db2_2.3.0Db2_2.4.0Db2_2.4.1Db2_2.4.2Db2_2.5.1Db2_2.6.0Db2_2.6.1Db2_2.7.0Db2_2.7.1
5.1.xNoNoNoNoNoNoNoNoNoNoNoNo
5.2.2.xYesNoNoNoNoNoNoNoNoNoNoNo
5.2.3.xNoYesYesYesNoNoNoNoNoNoNoNo
5.2.4.xNoYesYesYesNoNoNoNoNoNoNoNo
5.2.5.xNoYesYesYesNoNoNoNoNoNoNoNo
5.2.6.xNoYesYesYesNoNoNoNoNoNoNoNo
5.3.0.xNoYesYesYesYesYesYesYesYesYesYesYes
5.3.1.xNoYesYesYesYesYesYesYesYesYesYesYes
5.3.2.xNoYesYesYesYesYesYesYesYesYesYesYes
5.3.3.xNoYesYesYesYesYesYesYesYesYesYesYes
5.3.4.xNoYesYesYesYesYesYesYesYesYesYesYes
5.3.5.xNoYesYesYesYesYesYesYesYesYesYesYes
5.3.6.xNoYesYesYesYesYesYesYesYesYesYesYes
5.3.7.xNoYesYesYesYesYesYesYesYesYesYesYes

Unsupported Db2 Versions and Features

  • Db2 9.7 and below

  • Db2 Database Partitioning Feature (DPF)

  • Db2 pureScale

  • Ingestion to DMS Raw Devices

  • V2P