Count in Qlik Monitor when doing the initial load

[adbdkb]

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

[SwathiPulagam]

Hi @adbdkb ,

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

Thanks,

Swathi

[Bill_Steinagle · Accepted solution]

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

[adbdkb]

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