topic Re: Count in Qlik Monitor when doing the initial load in Qlik Replicate

Count in Qlik Monitor when doing the initial load

adbdkb — Fri, 08 Jul 2022 16:01:26 GMT

When we do initial load ( DB2 z/OS ) on a single DB2 table using target endpoint ( Kafka topic ), does the count in the Task monitor indicate the number of rows that are currently in the table or changes that have happened to the table that are in the transaction log, which may contain rows that may have multiple changes to them after the row was initially inserted.

This question comes to mind because, Qlik works on the transaction logs, not on actual tables, right?

Thank you

Re: Count in Qlik Monitor when doing the initial load

SwathiPulagam — Fri, 08 Jul 2022 16:59:11 GMT

Hi @adbdkb ,

Since this is a duplicate post we can close this thread as I answered in the actual post.

Thanks,

Swathi

Re: Count in Qlik Monitor when doing the initial load

Bill_Steinagle — Fri, 08 Jul 2022 17:09:40 GMT

Hi,

Thank you for the post to the Qlik Community. The Full Load panel in Replicate will show the amount of rows in the given Table as its being loaded. During the Load process we are caching the incoming changes for the Table until the Full Load completes. Once the Load is complete the amount of rows shows on the Monitor Table Full Load completed, and then the changes that were cached during the load will show on the change processing tab as they are being applied to the Target.

Example Load Completed:

Now the Load is complete you select the Change Processing Tab as this will contain the incoming changes to the Target.

Hope this information is helpful and keep in mind the Full Load does a SELECT * from Table to process the data from Source to Target.

Regards,

Bill Steinagle

Re: Count in Qlik Monitor when doing the initial load

adbdkb — Mon, 11 Jul 2022 15:29:25 GMT

Sure. I am not sure, how the exact question got duplicated. One thing I remember, I was having issues with authentication on the community log-in multiple times when I tried to POST the question - It said the action failed. So, I reposted that same question about 3-4 times - so even though it showed a failure message, it may have actually gone through.

Yes, we can close this post