Please enable JavaScript to view this site.

2021/04/13

•Replicator Engine (SQDRPL) (only): Ignore the CDCOP value 'z' created by a Db2/z capture when performing a capture based target refresh. The 'z' is intended to trigger target Delete ALL processing which is meaningless for JSON/AVRO targets.

•Apply (SQDENG) and Replicator (SQDRPL) Engines: When connecting to a Confluent Registry will make use of the user-id and password specified in the .netrc file unless directly overridden in the Confluent Registry url userid/password@whatever.

•Db2/z Log Capture (SQDDB2C): Enhancement supporting EDITPROC processing for captured data. An edit procedure assigned to a table by an EDITPROC clause on the CREATE Table statement can be used to transform an entire row and is often used for encryption of data. A new startup parameter, --editproc instructs the capture to request IFI to invoke an EDITPROC, if applicable to the source table, to perform decryption of the log record.

Syntax

apply start <capture_cab_file_name> --editproc

 

Note, --editproc is dependant on IBMs Db2/z APAR PK79207, delivered in 2009, which provided EDITPROC support in IFCID 306. This will become a standard part of Db2/z Version 13 (Apollo).

 

•Db2/z Log Capture (SQDDB2C): Enhancement allowing the normal Metadata scan at the start of capture to be skipped. The Metadata scan is used for tracking ddl changes and is required to support Schema Evolution in subscribing Replicator Engines. When all subscribers to a Db2/z Capture are Apply Engines the initial scan can be skipped. While this eliminates one scan of the Db2/z logs going back to the Safe Restart point, the time saved will only be noticeable when a Capture has been stopped for a period of time long enough to generate a very large number of logs.

Syntax

apply start <capture_cab_file_name> --no-ddl-tracking

 

Note, Verification that ddl tracking has been disabled will be visible on the first few lines in the SQDLOG DD output when the Db2/z Log Capture is started.

•Apply Engine (SQDENG): Upgrade the minimum level of Unicode supported on Windows to International Components for Unicode (ICU) 68.2.