Qlik Replicate Reload Reporting

[apouliou]

Hi all, we use Qlik Replicate and want to automate one. We use this as a source
IBM DB2 for iSeries and target Oracle. I would like to know if it is possible to report a reload on a transformation. This means that when a reload has taken place, an entry should be created in a report table in the target database by entering the tabel-name, task and time of the last reload.

[boaz_newman]

Hello

Replicate has a control table named attrep_history, you can add this table to each of your tasks, and it will create an entry in that table indicating the time of each realod (among other details)

Please see this page in the UG for more details:

https://help.qlik.com/en-US/replicate/November2022/Content/Replicate/Main/Control%20Tables/replicati...

Regards

boaz

[sureshkumar]

Hello @apouliou 

In addition to Boaz  comment, In Replicate UI go to Monitor windows--> Tools--> History
where you can find Full Load history and you can export the details using "Export to TSV" option.

Regards,
Suresh

[apouliou]

Hallo,

in der Tabelle attrep_history wird nur der Task-Name hinterlegt, nicht die Tabelle für die der Reload vorgenommen wurde. Gibt es Log-Tabelle / Methode bei der auch der Tabellen-Name hinterlegt ist?

Gruß Apostolos

[apouliou]

Hallo,

ich wollte es automatisieren, ohne manuellen Eingriff.

Gruß

[boaz_newman]

Hello

There is no option in Replicate to get a full load history on a table level. This information is available only in the task log.

Boaz

[Heinvandenheuvel]

@boaz_newman  "no option in Replicate to get a full load history on a table level."

Hmm, I think there is. Through the Enterprise Manager API the call is GetTableStatuses

Response:

{
"table_details":[
{
"schema_on_source":"{string}",
"table_on_source":"{string}",
"schema_on_target":"{string}",
"table_on_target":"{string}",
"state":"{enum}",
"data_errors_count":"{int64}",
"table_full_load_info":{
"start_time":"{string}",
"end_time":"{string}",
"estimated_row_count":"{int64}",
"estimated_end_time":"{string}",
"transferred_row_count":"{int64}",
"transferred_volume_mb":"{int64}"
},
"table_cdc_info":{ ...

The same information can be obtained (unsupported) through the REPCTL commandline interface:

repctl -d <\Replicate\data> gettablesstatus ?

state:optional enum, valid values:   [btw... input and output Enums]
00 - TABLE_NOT_EXIST
01 - TABLE_BEFORE_LOAD
02 - TABLE_FULL_LOAD
04 - TABLE_COMPLETED
08 - TABLE_CANCELED
16 - TABLE_ERROR
127 - TABLE_ALL
128 - TABLE_UPDATES

fl_start_time:optional int64
fl_last_time:optional int64

Hein.