Db2 for IBM i agent changelog

GSSD-682: Fixed CL program creation;

Fixed direct journal reader mode when RRN is selected as key;

Fixed CL program error catching;

Support for bulk load operations when targeting IBM i series tables;

New read modality for CDC changes feed performances boost:

New receivers fetch method: faster and more reliable;

Fixed DDS keys discovery;

DDS improvements;

GSSD-625: Fixed get column information for AS400 v7.2;

GSSD-629: Fixed an issue that could cause the agent to fail identifying an update made to a table without a primary key when a technical field is used instead of the unique row identifier, causing it to be taken as an insert leading to an unwanted UI error (UPSERT fallback mechanism prevented any data loss);

GSSD-628: Fixed retrieval of the oldest sequence number of a journal;

Improved management of journal checkpoints;

Added support for native boolean type;

Added journal checkpoint migration from older receiver rotation logic;

GSSD-606: Fixed handling of high receiver rotation;

GSSD-569: Supported AS400 custom data type;

GSSD-617/619: Fixed missing logic to handle Update operations by splitting into Delete and Insert actions for key changes;

Added additional logs to trace an issue affecting journal-receivers rotation;

Added support for RRNs;

In case of multi-journals, the agent will now use parallel journal reading to improve performance;

Added support for TLS connection;

GSSD-569: Fixed a bug that could cause the agent to forcely apply host’s timezone to the source incoming data over CDC while maintaining the original timezone for Snapshot-related data;

GSSD-501: Added support for DDS discovery;

GSSD-577: Added support for multi-member files (only the primary "physical" member is considered);

Improved reconnection resilience;

Updated vendor libraries.

Fixed a regression on IBM i 7.3 and lower;

Fixed an issue during non journaled tables migration towards 2.1.9’s caching layer;

Fixed a regression on IBM i 7.3 and lower;

Fixed a regression on IBM i 7.3 and lower;

Fixed journal reader not forwarding errors when data read fails;

Fixed DSPJRN command parameters to support version 7.2 and 7.3;

AS400 add support for AS400 version 7.2 and 7.3 using timestamp as start point for DSPJRN if checkpoint is null;

GSSD-474: Added support for Binary data type;

GSSD-326: Added support for source agent caching;

GSSD-277: Added support for auto skip of receivers if the previous receiver is not accessible;

GSSD-466: Fixed an issue with the serialization of timestamp data type with date precision set to 3 (milliseconds).

GSSD-375: Fixed AS400 NChar deserialization;

The agent no longer perform checks among all the entities when saving a config for a single entity, therefore being quicker and more responsive;

GSSD-391: Added support for reading logical files (VIEWS), currently only supporting Snapshot mode;

System objects with prefix $ are now ignored from the information schema retrieval;

GSSD-375: Added backwards compatibility for IBM i DB2 7.2 during files' statistics retrieval for automatic journal discovery;

Display journal command fixes;

Added support for writing to target table that don’t have an attached journal;

Relaxed checks for FOR BIT DATA data types;

GSSD-340: Added support for xyz FOR BIT DATA data type in IBM i Series;

Fixed merge statement generation;

Fixed an issue preventing Packed decimal data types to be correctly saved in an AS400 target table;

GSSD-301: Added clearer error handling when a File is currently unaccessible due to a lock;

GSSD-308: Fixed backwards compatibility issue with 7.3 TR11 / 7.4 TR5;

GSSD-290: Fixed a rare condition that could cause Gluesync to miss certain changes from being replicated.

Fixed AS400 7.3 backward compatibility issue;

Added support for short data type such as SMALL INT (other DBs will follow in the next releases);

Fixed journal reading of certain date and time format;

Added support for recursion protection;

Fixed a journal deserialization issue that could affect users having tables with custom date and time format;

Added support for automatic disambiguation when multiple tables have the same name.

Added additional logs to trace an issue affecting journal deserialization;

GSSD-285: Added management of tables under journal with same name but located in different libraries;

GSSD-283: fixed an issue that was displaying an error about "duplicate keys" entries within the Gluesync’s staging area;

Minor fixes and improvements.

Enhanced the controls when retriveing journal library name from a FILE, this prevents a wrong library name to be selected when the table is not journaled;

It now handles journal receveivers that do not share contiguous sequence number;

Added support for tables journaled with AFTER image.

Fixed numeric data types mapping;

Added control to journaling mode;

Journal reading performance significantly improved with up to 40x faster loads on very crowded databases;

Fixed concurrent operation on Journal Reader that cause a fake error in notifications hub;

GSSD-186: Fixed schema creation for IBM i DB2 database setting automatic deletion of journal receivers to true;

GSSD-184: Fixed merge statements character set issues when targeting an IBM i DB2 database;

GSSD-176: Fixed merge statements issues when targeting an IBM i DB2 database;

GSSD-167: Fix IBM i series journal entry data auto casting for IBM i series 7.3 or lower;