Welcome to September's Qlik Data Integration newsletter. Each month, we cover one endpoint and share our top resources, best practices, release updates and upcoming webinars.
Subscribe to the Qlik Data Integration topic to be notified of future editions!
Index
- Webinar
- Resource Highlights
- Qlik Replicate November 2023 and FIPS
- Knowledgebase Article
- Endpoint Spotlight: DB2
- New Issues Reported
- Tips!
- Best Practice
- Release Updates
- Fixes
- Upcoming Enhancements
- Troubleshooting tips
- Analyze Qlik Replicate Logs
- Qlik Replicate End of Life Versions
Webinar
Book your calendar for the upcoming Q&A with Qlik: Qlik Replicate Sources and Targets Q&A session scheduled for October 24th at 10:00 AM EDT. It is a live Q&A session with a panel of Qlik experts. Bring your questions, and we do our best to answer them.
Resource Highlights
Qlik Replicate November 2023 and FIPS
The November 2023 release of Qlik Replicate is not yet FIPS compliant. If you require a compliant environment, remain on the already FIPS compatible versions. See Qlik Replicate November 2023 and FIPS: Release not yet FIPS compliant for details.
Knowledgebase Article
Endpoint Spotlight: DB2
Find our latest knowledge base articles for DB2 endpoints.
New Issues Reported
- Qlik Replicate and R4Z after upgrade to 2023.5 SP02: additional download required
The Qlik Replicate service pack 02 release for 2023.5 includes old R4Z installation files from the previous SP01 build.To upgrade the R4Z component, additional files need to be downloaded and installed. See Qlik Replicate and R4Z after upgrade to 2023.5 SP02: additional download required for details.
- SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation.
Qlik Replicate with a DB2 z/OS source endpoint (using R4Z) displays authorization and privilege errors. See Qlik Replicate DB2 z/OS - [SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: 42501 NativeError: -551 M... for more information and how to resolve the issue.
Tips!
- R4Z Db2 mainframe install is completed but no Changes are coming through
Check that the Tables you wish to be performing CDC replication upon, have been "turned on" for capturing the changes from the DB2 z/OS Logs. See Qlik Replicate: R4Z DB2z No CDC coming through for details. - Qlik Replicate DB2 z/OS task may stop/fail with R4DB2: ALL CB ENTRIES ARE IN USE
This means that a task is trying to start, but the maximum number of R4Z Control Blocks (in the R4Z CDC service environment on the mainframe) is in use. Find the resolution in Qlik Replicate: DB2 z/OS R4Z [SOURCE_CAPTURE ]W: R4DB2: ALL CB ENTRIES ARE IN USE.
Best Practice
- Match R4Z and Qlik Replicate versions
The Qlik Replicate and R4Z versions you install must be part of the same release, which can either be an initial release or a patch/service release. This means that if you upgrade Qlik Replicate, you must also upgrade your R4Z installation (to the version that correlates with the Qlik Replicate release you are installing), unless it has the same build number as your currently installed R4Z. Note that despite being part of the same release, the Qlik Replicate and R4Z build numbers (reflected in their file names) might not be the same.
For example, Qlik Replicate May 2022 SR2 includes the following files:
- QlikReplicate_2022.5.0.499_X64.zip (the Replicate installer)
- QlikReplicate_2022.5.0.290_r4z.zip (the R4Z installer).
- How to avoid WLM tasks being cancelled due to Work Load Manager Policy settings
When installing and using the DB2 z/OS endpoint in Qlik Replicate, WLM tasks on the mainframe may get cancelled. There are multiple root causes for this, but a common one can be addressed by reviewing the execution priority (WLM settings).
See Qlik Replicate and R4Z: Best practice to ensure DB2 z/OS Workload Manager (WLM) tasks are not cancel... for details.
Release Updates
Fixes
Qlik Replicate May 2023 Patch 3
ID: RECOB-7408
Type: Issue
Component/Process: IBM DB2 for z/OS Source
Description: The capture process would not recover from a communication error in the metadata connection.
ID: RECOB-7385
Type: Issue
Component/Process: IBM DB2 for z/OS Source
Description: The following ambiguous warning message would sometimes be issued when resuming a task:
Transaction <> was committed after the Full Load started and the BEGIN TRANSACTION statement was not captured.
ID: RECOB-7220
Type: Issue
Component/Process: DB2 z/OS Source
Description: DB2 would sometimes abend in a data sharing environment when tasks moved back and forth between LPARs.
Qlik Replicate May 2023 Patch 2
ID: RECOB-7311
Type: Enhancement
Component/Process: IBM DB2 for z/OS Target
Description: Performance was improved when using the zload utility to load files.
ID: RECOB-7146
Type: Issue
Component/Process: IBM DB2 for z/OS Target
Description: The task log would display the following incorrect warning when replicating from IBM DB2 on z/OS 13.1 (which is certified): Replicate has not been certified to work with DB2 z/OS version '13.01.0005', and therefore any issues you may encounter with this version are not covered by your license agreement.
ID: RECOB-7114
Type: Issue
Component/Process: IBM DB2 for z/OS Target
Description: The R4Z DO4GRANT JCL was updated to grant the R4Z user permissions on the SYSIBM.SYSTABLEPART and SYSIBM.SYSPARMS tables.
Upcoming Enhancements
Qlik Replicate November 2023 IR
- Expose stream buffer tuning parameters in task settings (Replicate & QEM - Expose stream buffer tuning parameters in task settings )
- Confluent Schema Register using BOTH authentication methods (Public Key + Username & password)
- Snowflake - Support Transactions in Upsert Mode
- Boolean Data Type support for PG sources and Bit support for SQL Server targets
- Google BigQuery - Secure current authentication (no longer have credential files on customer file system)
- Aurora PostgreSQL source - without the "superuser" role certification
- Azure Database for MySQL Flexible Server - Source & Target Certification
- MariaDB 10.6 to 10.11 versions on MySQL - certification
- MariaDB 10.6 version on Amazon RDS - certification
- Google Cloud SQL for MSSQL Source endpoint
- Databricks 12.2 LTS Certification
- Databricks Serverless SQL warehouse certification
Troubleshooting tips
Analyze Qlik Replicate Logs
An evergreen pair of articles helps you read and analyze Qlik Replicate log files:
How to analyze a Qlik Replicate log
List of the error types in Qlik Replicate
Qlik Replicate End of Life Versions
| Version | Release Date | End of Support Date |
| Qlik Replicate May 2023 | May 9, 2023 | May 9, 2025 |
| Qlik Replicate November 2022 | November 8, 2022 | November 8, 2024 |
| Qlik Replicate May 2022 | May 10, 2022 | May 10, 2024 |
| Qlik Replicate November 2021 | November 8, 2021 | November 8, 2023 |
| Qlik Replicate May 2021 | May 11, 2021 | May 11, 2023 |
| Qlik Replicate November 2020 | November 10, 2020 | November 30, 2022 |
| Qlik Replicate April 2020 (6.6) | April 16, 2020 | April 30, 2022 |
| Qlik Replicate 6.5 | November 14, 2019 | November 30, 2021 |
| Qlik Replicate 6.4 | April 1, 2019 | April 14, 2021 |
| Qlik Replicate 5.5 | August 1, 2017 | November 30, 2020 |
For more information, see Qlik Product Lifecycles.