IBM DB2 component release notes

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

Changelog

Version 2024.1.7

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 2024.1.0

Features

  • DI-7331: Add an option to limit how much data is extracted from journals.

Bug fixes

  • DI-7370: Remove AUTONOMOUS SQL transaction type, as it has no effect.

Version 2023.3.0 (IBM DB2 component)

Features

  • DI-8052: Change Data Capture DB2-400: Add the ability to calculate the journal boundaries through sequences instead of timestamps.

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)

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)

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)

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)

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