IBM DB2 component release notes

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

Changelog

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

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

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

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

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.

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.

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.

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

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

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

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

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

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

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