Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates

Does the DB2 Native Endpoint capture changes when loading data with DB2 LOAD REPLACE?

No ratings
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
David_Fergen
Former Employee
Former Employee

Does the DB2 Native Endpoint capture changes when loading data with DB2 LOAD REPLACE?

Last Update:

Aug 28, 2020 6:11:53 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jul 23, 2020 4:50:16 PM

Question:
Does the DB2 Native Endpoint capture changes when loading data with DB2 LOAD REPLACE?

 
Reading the IBM documentation, it says that if you specified LOG=yes the changes are actually logged.

Answer:

The DB2 LOAD REPLACE is done on the logical/row level, thus even when specifying LOG=yes, we cannot get the relevant CDC information from the logs.
 
An alternative method is issuing a TRUNCATE and then LOAD RESUME SHRLEVEL CHANGE.

Labels (1)
495 Views
Was this article helpful? Yes No
Version history
Last update:
‎2020-08-28 06:11 AM
Updated by:
Digital Support