topic Re: [Db2 for iSeries source] How to replicate tables created by DDS in Qlik Replicate

[Db2 for iSeries source] How to replicate tables created by DDS

iti-attunity-sup — Wed, 22 May 2024 00:26:53 GMT

Hello support team.

[Info]
Source DB : Db2 for iSeries

[Question]
About following limitation,
>Tables created by DDS: If you need to replicate tables created by DDS, please seek guidance from Qlik Support or your Qlik Customer Success Manager.
https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedReplicateHDD/IBM4DB2-iseries/iseries_limitations.htm

Are tables created by DDS enable to be replicated ?
If yes, would you tell me how to replicate these table?

Best Regards.

Re: [Db2 for iSeries source] How to replicate tables created by DDS

SushilKumar — Wed, 22 May 2024 01:25:21 GMT

Hello @iti-attunity-sup

Thanks for reaching out to Qlik via Qlik Community Support page

DB2 objects created with DDS can be accessed with SQL and objects created with SQL can be accessed with the native record-level access interface.

In the context of DB/2, DDS enables applications to access the DB/2 database over a network, rather than directly accessing the database on the local machine. This enables distributed systems where multiple applications, running on different machines, need to access the same database.

The main difference between DDS and SQL is that DDS is designed for managing distributed databases, while SQL is designed for managing centralized relational databases.

Qlik replicate fetches or get information from Endpoint via Sql extraction. Its highly likely QR requires some function to fetch and process the data which created with DDS and PS/CF/development team enable them only on request.

Regards,

Sushil Kumar

Re: [Db2 for iSeries source] How to replicate tables created by DDS

DesmondWOO — Wed, 22 May 2024 01:49:58 GMT

Hi @iti-attunity-sup ,

If you want to start journaling a physical file (table), please check this AS400 command STRJRNPF.

Regards,
Desmond

Re: [Db2 for iSeries source] How to replicate tables created by DDS

iti-attunity-sup — Wed, 22 May 2024 01:58:10 GMT

Hello Sushil Kumar.
Thank you for your reply.

>Its highly likely QR requires some function to fetch and process the data which created with DDS and PS/CF/development team enable them only on request.

If these function is enabled, is Full Load and Apply changes possible with tables created by DDS?

Best Regards.

Re: [Db2 for iSeries source] How to replicate tables created by DDS

iti-attunity-sup — Wed, 22 May 2024 07:50:20 GMT

Hello Sushil Kumar.
I have one more question.

>Qlik replicate fetches or get information from Endpoint via Sql extraction. Its highly likely QR requires some function to fetch and process the data which created with DDS and PS/CF/development team enable them only on request.

About this, how to request this function?

Best Regards.

Re: [Db2 for iSeries source] How to replicate tables created by DDS

DesmondWOO — Wed, 22 May 2024 08:39:20 GMT

Hi @iti-attunity-sup ,

In most cases, both Full Load and CDC work fine with DDS tables, just same to SQL table. However, customer may encounter unexpected situation. For example, I encountered a support case where the information retrieved from a DB2 system table and a DDS table may not align. The DB2 system table indicates NULL value is not allowed for a column, while DDS table shows it allows. As a result, it affects Replicate when creating the target table.

Regards,
Desmond

Re: [Db2 for iSeries source] How to replicate tables created by DDS

iti-attunity-sup — Wed, 22 May 2024 09:28:44 GMT

Hello Desmond.
Thank you for your reply.

To sum up,
Just by executing AS400 command "STRJRNPF" on source database,
it is enable to replicate tables created by DDS, right ?

Best Regards.

Re: [Db2 for iSeries source] How to replicate tables created by DDS

DesmondWOO — Thu, 23 May 2024 04:30:39 GMT

Hi @iti-attunity-sup ,

The STRJRNPF command associates your database physical file to a journal, allowing Replicate to retrieve changes from the journal. This step must be done for DDS table and SQL table.

Regards,
Desmond

Re: [Db2 for iSeries source] How to replicate tables created by DDS

iti-attunity-sup — Thu, 23 May 2024 05:13:32 GMT

Hello Desmond
Thank you for your reply.

So about following limitation,
>Tables created by DDS: If you need to replicate tables created by DDS, please seek guidance from Qlik Support or your Qlik Customer Success Manager.

Does this mean "STRJRNPF" command ?
Or other setting ?

Best Regards.

Re: [Db2 for iSeries source] How to replicate tables created by DDS

DesmondWOO — Thu, 23 May 2024 08:46:03 GMT

Hi @iti-attunity-sup ,

No. I thought you were asking about how to configure so that Replicate can capture changes for DDS table.

As I mentioned earlier, Replicate may encounter unexpected issues with DDS table. So we document that message in the limitation, and recommended to check with with us before implementing your project.

For any further questions about the DDS table, I would suggest reaching out to your account manager.

Regards,
Desmond

Re: [Db2 for iSeries source] How to replicate tables created by DDS

iti-attunity-sup — Fri, 24 May 2024 08:39:12 GMT

Hello Desmond.
Thank you for your reply.

I understood.

Best Regards.

Re: [Db2 for iSeries source] How to replicate tables created by DDS

iti-attunity-sup — Wed, 29 May 2024 06:43:24 GMT

Hello Desmond
I accepted as solution, but I have one more question.

Even if source table is created by DDS, is it possible about following without additional function?

・Click "Table Selection..." and select table
・Full Load only

Best Regards.

Re: [Db2 for iSeries source] How to replicate tables created by DDS

john_wang — Wed, 29 May 2024 07:18:23 GMT

Hello @iti-attunity-sup ,

Yes, you are right. The table will be visible in Table Selection and it's fine for Full Load ONLY task.

Regards,

John.