IBM DB2 Component Release Notes

This page lists the main features added to the IBM DB2 Component.

Feature Highlights

Version 2.0.4

Minor improvements and fixed issues

This version contains some minor improvements and fixed issues, which can be found in the complete changelog.

Version 2.0.3

Change Data Capture (CDC)

Multiple improvements have been performed to homogenize the usage of Change Data Capture (CDC) in the various Components.

Parameters have been homogenized, so that all Templates should now have the same CDC Parameters, with the same support of features.

Multiple fixes have also been performed to correct CDC issues. Refer to the changelog for the exact list of changes.

Minor improvements and fixed issues

This version also contains some other minor improvements and fixed issues, which can be found in the complete changelog.

Version 2.0.2

Fix the reverse of DB2 / 400 which could contain invalid characters

When doing a reverse on AS/400 the table and column comments sometimes contain some invisible characters incompatible with Unicode, which cause issues when saving the Metadata, raising exceptions such as "java.lang.RuntimeException: An invalid XML character (Unicode 0x0) was found in the element content.".

To avoid such issues, the reverse does not reverse comments anymore for DB2 / 400, as they can contain invalid characters.

Version 2.0.1

Fixed issue on truncate statement

With IBM DB2 UDB / IBM DB2 UDB for zos / IBM DB2 400, generated truncate table statements were missing the IMMEDIATE keyword, which were causing errors when executing them.

Change Log

Version 2023.1.15

Bug Fixes

  • DI-9193: Template INTEGRATION DB2-400: added a missing commit parameter, which prevented integration flows from passing through a commit step during transactional mode.

Version 2023.1.5 (IBM DB2 Component)

Bug Fixes

  • DI-8405: CDC DB2-400 - Read Journal Data: improve the retrieval of the last available sequence identifier from the journal receiver to avoid any data loss when the AS400 cache is enabled.

Version 2023.1.0 (IBM DB2 Component)

New Features

  • DI-4614: The Create indexes on Target Table parameter has been added to the STAGING DB2-400 As Table template.

  • DI-4615: The Create indexes on Target Table parameter has been added to the STAGING DB2-UDB As Table template.

  • DI-4666: The Create indexes on Target Table parameter has been added to the INTEGRATION DB2-400 template.

  • DI-4667: The Create indexes on Target Table parameter has been added to the INTEGRATION DB2-UDB template.

Bug Fixes

  • DI-5959: The expression that automatically generates the primary key addition constraint does not include the schema name.

  • DI-5960: When using the Privacy Protect tool, the queries generated for primary key creation are incorrect. They do not include the schema name inside the constraint definition, which is mandatory for some technologies such as AS400.

Version 19.0.22 (Designer)

Bug Fixes

  • DI-1266: IBM DB2 UDB / IBM DB2 UDB for zos / IBM DB2 400: generated truncate table statements are missing the IMMEDIATE keyword, which is causing errors when executing them

Version 2.0.2 (IBM DB2 Component)

Bug Fixes

  • DI-230: IBM DB2 Component: comments are no longer reversed in DB2/400 Metadata as they might contain some invalid characters which makes the Metadata unusable and impossible to save

Version 2.0.3 (IBM DB2 Component)

New Features

  • DI-1773: DB2 Technologies - Add a default size for VARCHAR datatypes

  • DI-1912: Templates updated - support having CDC sources on Templates which were not supporting it (such as staging templates)

  • DI-1910: Templates updated - New parameter 'Cdc Subscriber' on Templates on which it was not handled yet

  • DI-1909: Templates updated - New Parameters 'Unlock Cdc Table' and 'Lock Cdc Table' to configure the behaviour of CDC tables locking

Bug Fixes

  • DI-968: Replicator XML to Rdbms - When replicating into DB2 AS/400, VARCHAR columns were unexpectedly created without size, which could cause issues: they are now created with a default size of 1000

  • DI-1157: Integration DB2-400 - "drop the pre-integration table" was never executed because the previous link was not properly defined

  • DI-1908: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates on Lock / Unlock CDC steps

  • DI-1907: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates when querying the source data

Version 2.0.4 (IBM DB2 Component)

New Features

  • DI-2547: Template - Integration DB2/400 - support having a target table on which only the update key is mapped

Bug Fixes

  • DI-2742: Template - LOAD Rdbms to DB2-UDB - generated temporary file names may unexpectedly contain object delimiters

Version 3.0.0 (Component Pack)

New Features

  • DI-4508: Update Components and Designer to take into account dedicated license permissions

  • DI-4727: Rebranding: Templates and sample projects

  • DI-4731: Rebranding: Template messages

  • DI-4962: Improved component dependencies and requirements management