topic Re: DB2 statements issued when using Qlik Replicate in Qlik Replicate

DB2 statements issued when using Qlik Replicate

husainbhavna — Tue, 04 Oct 2022 13:30:31 GMT

Hello All,

I am using DB2 Qlik replicate to load data into DB2. I want to know what are the actual commands issued by Qlik Replicate on DB2 when:

1 ) Performing a Full Load and the 'DROP and CREATE Table' is selected if the target table already exists

2) Performing a Full Load and the 'TRUNCATE before loading' is selected if the target table already exists

Also on which scenario does the following statement run by Qlik Replicate on DB2:

ALTER TABLE "SCHEMA"."TABLENAME" activate not logged initially with empty table

Your inputs will be much appreciated. Thank you

Best Regards,
Husainbhavna

Re: DB2 statements issued when using Qlik Replicate

Heinvandenheuvel — Tue, 04 Oct 2022 15:10:32 GMT

The absolute best way to know what is being asked from a DB is to ask that DB. For Oracle that could be queries to the V$SQL table and its friends, or Event 10046 trace files. For DB@ that might be through https://www.ibm.com/docs/en/db2/10.5?topic=statements-create-event-monitor or DB2TRC. Most databases have 3rd party tools to help with this. Toad might be a good choice.

Replicate can help through its logs. First enable TRACE level logging for TARGET_LOAD and TARGET_APPLY. See if that give enough detail for your needs. If not enough, then switch to VERBOSE. Because VERBOSE can be VERY verbose please be sure to test to tiny table and tiny change batches. Like 10 rows to load, 2 rows to insert.

Hein.

Re: DB2 statements issued when using Qlik Replicate

lyka — Tue, 04 Oct 2022 18:00:41 GMT

Hello,

Enabling TRACE or VERBOSE logging will give you some details on this.

For Full load, increase the logging for target_load and source_unload.

For CDC, increase the logging for target_apply and source_capture.

Hope this helps!

Thanks

Lyka

Re: DB2 statements issued when using Qlik Replicate

husainbhavna — Thu, 06 Oct 2022 09:34:47 GMT

Thank you Hein. Setting to VERBOSE helped.

Re: DB2 statements issued when using Qlik Replicate

husainbhavna — Thu, 06 Oct 2022 09:35:29 GMT

Hello Lyka,

Thank you. Setting to Verbose helped.

Sincerely,

Husain