New Features
The Db2 Plugin version 3.0.1 fixes the bug wherein the jobs on UI hung intermittently due to a known IBM Db2 bug.
Migration and Compatibility
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
Supported Operating Systems
Supported Db2 Database Editions
- Enterprise Server Edition
- Advanced Enterprise Server Edition
- For the supported Db2 versions, Delphix supports the corresponding Db2 Developer edition with Db2 plugin support
Db2 supports only 64-bit OS.
Red Hat Enterprise Linux (RHEL)
Support for RHEL 8.x requires installing the libncurses.5
library onto the host. Please reference KBA 5622 for actionable steps.
Red Hat Enterprise Linux (RHEL)
Db2 plugin support for below mentioned OS and Db2 versions
Supported DBMS Version | 10.5 | 11.1 | 11.5 | |
Supported OS Version | ||||
RHEL 6.4 | Supported | Not Supported | Not Supported | |
RHEL 6.5 | Supported | Not Supported | Not Supported | |
RHEL 6.6 | Supported | Not Supported | Not Supported | |
RHEL 6.7 | Supported | Supported | Not Supported | |
RHEL 6.8 | Supported | Supported | Not Supported | |
RHEL 6.9 | Supported | Supported | Not Supported | |
RHEL 7.0 | Supported | Supported | Not Supported | |
RHEL 7.1 | Supported | Supported | Not Supported | |
RHEL 7.2 | Supported | Supported | Not Supported | |
RHEL 7.3 | Supported | Supported | Not Supported | |
RHEL 7.4 | Supported | Supported | Not Supported | |
RHEL 7.5 | Supported | Supported | Not Supported | |
RHEL 7.6 | Supported | Supported | Not Supported | |
RHEL 7.7 | Not Supported | Supported | Not Supported | |
RHEL 7.8 | Not Supported | Supported | Supported in 6.0.5+ | |
RHEL 8.2 | Not Supported | Not Supported | Supported |
Advanced Interactive eXecutive (AIX)
Db2 plugin support for below mentioned OS and Db2 versions
Supported DBMS Version | 10.5 | 11.1 | 11.5 | |
Supported OS Version | ||||
AIX 6.1 | Not Supported | N/A | N/A | |
AIX 7.1 | Supported | Supported | Supported | |
AIX 7.2 | Supported | Supported | Not Supported |
Supported Db2 Fix Packs on RHEL and AIX
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 Linking
Source | Staging | ||
---|---|---|---|
11.1.1.1 | 11.1.2.2 | 11.1.3.3 | |
11.1.1.1 | Supported | Supported | Supported |
11.1.2.2 | Not Supported | Supported | Supported |
11.1.3.3 | Not Supported | Supported | Supported |
Db2 11. Fix Packs HADR Linking
Source | Staging | ||
---|---|---|---|
11.1.1.1 | 11.1.2.2 | 11.1.3.3 | |
11.1.1.1 | Supported | Supported | Supported |
11.1.2.2 | Not Supported | Supported | Supported |
11.1.3.3 | Not Supported | Supported | Supported |
Db2 11. Fix Packs Provisioning
Staging | Target | ||
---|---|---|---|
11.1.1.1 | 11.1.2.2 | 11.1.3.3 | |
11.1.1.1 | Supported | Supported | Supported |
11.1.2.2 | Not Supported | Supported | Supported |
11.1.3.3 | Not Supported | Supported | Supported |
Db2 10.5 Fix Packs
Db2 10.5 Fix Packs - NON HADR linking
Source | Staging | ||||||||
---|---|---|---|---|---|---|---|---|---|
10.5.0.1 | 10.5.0.2 | 10.5.0.3 | 10.5.0.4 | 10.5.0.5 | 10.5.0.6 | 10.5.0.7 | 10.5.0.8 | 10.5.0.9 | |
10.5.0.1 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.2 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.3 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.4 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.5 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.6 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.7 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.8 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.9 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
Db2 10.5 Fix Packs - HADR Linking
Source | Staging | ||||||||
---|---|---|---|---|---|---|---|---|---|
10.5.0.1 | 10.5.0.2 | 10.5.0.3 | 10.5.0.4 | 10.5.0.5 | 10.5.0.6 | 10.5.0.7 | 10.5.0.8 | 10.5.0.9 | |
10.5.0.1 | Supported | Not Supported | Not Supported | Not Supported | Not Supported | Supported | Supported | Supported | Supported |
10.5.0.2 | Not Supported | Supported | Not Supported | Not Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.3 | Not Supported | Not Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.4 | Not Supported | Not Supported | Not Supported | Supported | Not Supported | Supported | Supported | Supported | Supported |
10.5.0.5 | Not Supported | Not Supported | Not Supported | Not Supported | Supported | Not Supported | Supported | Supported | Supported |
10.5.0.6 | Not Supported | Not Supported | Not Supported | Not Supported | Not Supported | Supported | Supported | Supported | Supported |
10.5.0.7 | Not Supported | Not Supported | Not Supported | Not Supported | Not Supported | Not Supported | Supported | Supported | Supported |
10.5.0.8 | Not Supported | Not Supported | Not Supported | Not Supported | Not Supported | Not Supported | Not Supported | Supported | Supported |
10.5.0.9 | Not Supported | Not Supported | Not Supported | Not Supported | Not Supported | Not Supported | Not Supported | Not Supported | Supported |
Db2 10.5 Fick Packs HADR-NON HADR Provision
Staging | Target | ||||||||
---|---|---|---|---|---|---|---|---|---|
10.5.0.1 | 10.5.0.2 | 10.5.0.3 | 10.5.0.4 | 10.5.0.5 | 10.5.0.6 | 10.5.0.7 | 10.5.0.8 | 10.5.0.9 | |
10.5.0.1 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.2 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.3 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.4 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.5 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.6 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.7 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.8 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
10.5.0.9 | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
Plugin/Delphix Engine Compatibility
Plugins should be installed on compatible Delphix Engines per the table below:
Delphix Engine | Db2_2.0.1 | Db2_2.1.0 | Db2_2.2.1 | Db2_2.3.0 | Db2_2.4.0 | Db2_2.4.1 | Db2_2.4.2 | Db2_2.5.1 | Db2_2.6.0 | Db2_2.6.1 | Db2_2.7.0 | Db2_2.7.1 | Db2_2.7.2 | Db2_2.7.3 | Db2_3.0.0 | Db2_3.0.1 | Db2_3.0.2 | Db2_3.1.0 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6.0.0.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
6.0.1.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
6.0.2.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
6.0.3.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
6.0.4.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
6.0.5.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Plugin Upgrade Path
Use the table below to determine the most efficient upgrade path from your current version to the latest version of the Db2 Plugin.
Your Version | Recommended upgrade path to Db2 3.0.1 |
2.0.1 | Upgrade to 2.1.0, and follow the paths below. |
2.1.0 | Upgrade to 2.2.1, and follow the paths below. |
2.2.1 | Upgrade to 2.3.0, and follow the paths below. |
2.3.0 | Upgrade to 2.4.0, and follow the paths below. |
2.4.0 2.4.1 2.4.2 | Upgrade to 2.5.1, and follow the paths below. |
2.5.1 | Upgrade to 2.6.0, and follow the paths below. |
2.6.0 2.6.1 | Upgrade to 2.7.0, and follow the paths below. |
2.7.0 2.7.1 2.7.2 2.7.3 | Upgrade directly to the latest version |
3.0.0 | Upgrade directly to the latest version |