New Features

The Db2 Plugin version 3.1.0 introduces the Staging Push feature. This feature will allow users to control the restore of the staging database and they can also control the state of the restored staging database.

Staging Push

With the Staging Push feature, the restore and rollforward operations will be managed by the user from the CLI. During dSource creation (or RESYNC) the plugin will create an empty mount point and will provide a restore and rollforward template that will help the user to create the redirect restore script. Once the dSource will be ready then the user can perform restore and rollforward operations from CLI. The restore must be as per the plugin provided template. After the restore, the staging database should remain in rollforward pending state, and prior to the next snapshot, the user can do a rollforward to a specific Point-in-Time (by providing a timestamp to rollforward command) against the available archive logs.

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

  1. Enterprise Server Edition
  2. Advanced Enterprise Server Edition
  3. Advanced Edition
  4. Standard Edition
  5. For the supported Db2 versions, Delphix supports the corresponding Db2 Developer edition with Db2 plugin support
  • Delphix Support Policies specifically list Major and Minor release coverage. If a minor release is listed as covered, then all patch releases under that minor release are certified.
  • Db2 versions below 10.5 i.e (10.1, 9.8) are NOT supported by the plugin.
  • Db2 supports only 64-bit OS

Key:

Color

Supported? 

Yes
(error)No

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
Supported OS Version10.511.111.5
RHEL 6.9

(error)
RHEL 7.0

(error)
RHEL 7.1

(error)
RHEL 7.2

(error)
RHEL 7.3

(error)
RHEL 7.4

(error)
RHEL 7.5

(error)
RHEL 7.6

(error)
RHEL 7.7(error)

(error)
RHEL 7.8(error)

6.0.5+

RHEL 8.2(error)(error)

Advanced Interactive eXecutive (AIX)

Db2 plugin support for below mentioned OS and Db2 versions


Supported DBMS Version
Supported OS Version10.511.111.5
AIX 7.1

AIX 7.2

Plugin/Delphix Engine Compatibility

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

The plugin versions starting 2.1.0 till 2.7.3 are on extended support. Please contact Delphix Support for any queries.


Plugin Version
Delphix Engine3.0.03.0.13.0.23.1.03.1.14.0.04.0.14.1.04.1.14.1.2
6.0.0.x

(error)(error)(error)(error)(error)
6.0.1.x

(error)(error)(error)(error)(error)
6.0.2.x

(error)(error)(error)(error)(error)
6.0.3.x

(error)(error)(error)(error)(error)
6.0.4.x

(error)(error)(error)(error)(error)
6.0.5.x

(error)(error)(error)(error)(error)
6.0.6.x

(error)(error)(error)(error)(error)
6.0.7.x

(error)(error)(error)(error)(error)
6.0.8.x

(error)
6.0.9.x

(error)
6.0.10.x

(error)
6.0.11.x

(error)
6.0.12.x




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.1.0

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.1Upgrade 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