IBM DB2 Component Release Notes

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