topic Re: I run task replicate IDM Db2 for iSeries Source to SQL Server Target error Journal in Qlik Replicate

I run task replicate IDM Db2 for iSeries Source to SQL Server Target error Journal

DuongNguyen — Sat, 07 Oct 2023 15:20:24 GMT

How to get and config Journal Name and Journal Library in qlik replicate?

Can you give me a example?

Re: I run task replicate IDM Db2 for iSeries Source to SQL Server Target error Journal

john_wang — Sun, 08 Oct 2023 01:35:37 GMT

Hello @DuongNguyen ,

Welcome to Qlik Community!

The specified journal library and/or journal name is incorrect, please work with your DBA to get the correct name.

In below sample, the journal QSQJRN exists in library APSUPDB, the journal file type is *JRN:

in Replicate endpoint, the settings are:

You may confirm if your journal name DBMJRN exists in library EAAJRN2 , and if the file type is *JRN.

Hope this helps.

Regards,

John.

Re: I run task replicate IDM Db2 for iSeries Source to SQL Server Target error Journal

DuongNguyen — Sun, 08 Oct 2023 01:49:30 GMT

hi John_wang.

I thank you for your help. I have 2 more problems, can you help me?

Re: I run task replicate IDM Db2 for iSeries Source to SQL Server Target error Journal

DuongNguyen — Sun, 08 Oct 2023 01:58:19 GMT

1st problem. when I configure data with IBM DB2 for iSeries. After I selected the table, bouble clicked on the selected table to configure the transform column and got this error: SYS-E-HTTPFAIL: converter 28709 not found

Hope to receive help from you

Re: I run task replicate IDM Db2 for iSeries Source to SQL Server Target error Journal

john_wang — Sun, 08 Oct 2023 02:48:33 GMT

Hello @DuongNguyen ,

Thanks for the following up. Looks to me the original problem was solved, is that correct?

When it comes to error: converter 28709 not found

If I understood correctly, your DB400 database CCSID or table CCSID is 28709 which is Traditional Chinese. Could you please confirm if your data contains Chinese chars or any chars out of ASCII range?

If you have Chinese chars data then you can convert 28709 to 937, or you can use 37. For example:

Let me know if you need any additional assistance.

Regards,

John.

Re: I run task replicate IDM Db2 for iSeries Source to SQL Server Target error Journal

DuongNguyen — Sun, 08 Oct 2023 03:00:07 GMT

@john_wang thank you so much.

ODBC (IBM DB2 for iSeries Target) how to set CCSID

Re: I run task replicate IDM Db2 for iSeries Source to SQL Server Target error Journal

john_wang — Sun, 08 Oct 2023 03:16:04 GMT

Hello @DuongNguyen ,

Thanks for your update.

In this article we are focusing on "IBM DB2 for iSeries Source" issues. If the problems were resolved, please press "Accept as Solution" button to make it easier for others to find the answer quickly.

If you are facing other challenges, please open a dedicated article, we'd like to help further.

Regards,

John.

Re: I run task replicate IDM Db2 for iSeries Source to SQL Server Target error Journal

john_wang — Sun, 08 Oct 2023 04:19:45 GMT

Hello @DuongNguyen ,

Thanks for your feedback. BTW, please set one or necessary comments (the best one is good enough) as solution next time.

Good luck,

John.