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

[DuongNguyen]

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

Can you give me a example?

[john_wang · Accepted solution]

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.

[DuongNguyen · Accepted solution]

hi John_wang.

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

[DuongNguyen · Accepted solution]

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

[john_wang · Accepted solution]

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.

[DuongNguyen · Accepted solution]

@john_wang thank you so much. 

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

[john_wang · Accepted solution]

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.

[john_wang]

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.