The Db2 Plugin version 4.0.1 includes the below improvements.
- Added support for 11.1.4.6 fix pack.
Migration and Compatibility
Supported Db2 Database Editions
- Enterprise Server Edition
- Advanced Enterprise Server Edition
- Advanced Edition
- Standard 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.
Db2 plugin support for below mentioned OS and Db2 versions
Supported DBMS Version | 10.5 | 11.1 | 11.5 | |
Supported OS Version | ||||
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 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.4.6 | |
11.1.1.1 | Supported | Supported | Supported | Supported |
11.1.2.2 | Not Supported | Supported | Supported | Supported |
11.1.3.3 | Not Supported | Supported | Supported | Supported |
11.1.4.6 | Not Supported | 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.4.6 | |
11.1.1.1 | Supported | Supported | Supported | Supported |
11.1.2.2 | Not Supported | Supported | Supported | Supported |
11.1.3.3 | Not Supported | Supported | Supported | Supported |
11.1.4.6 | Not Supported | Supported | Supported | Supported |
Db2 11. Fix Packs Provisioning
Staging | Target | |||
---|---|---|---|---|
11.1.1.1 | 11.1.2.2 | 11.1.3.3 | 11.1.4.6 | |
11.1.1.1 | Supported | Supported | Supported | Supported |
11.1.2.2 | Not Supported | Supported | Supported | Supported |
11.1.3.3 | Not Supported | Supported | Supported | Supported |
11.1.4.6 | Not Supported | 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 | Db2_3.1.1 | Db2_4.0.0 | Db2_4.0.1 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6.0.0.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
6.0.1.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
6.0.2.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
6.0.3.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
6.0.4.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
6.0.5.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
6.0.6.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
6.0.7.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
6.0.8.x | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
6.0.9.x | No | Yes | Yes | Yes | 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 4.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 to 3.0.0, and follow the paths below |
3.0.0 3.0.1 3.0.2 | Upgrade to 3.1.0, and follow the path below |
3.1.0 3.1.1 | Upgrade directly to 4.0.0 or 4.0.1 |
Fixed Issues
Db2 plugin version 4.0.1 contains the following fixed issue.
Key | Summary |
DB2-1684 | [Staging Push]Enable operation on dSource should generate the Restore and Rollforward template file if it is missing |