Hello, can someone help with decoding value in ifx_replcheck? - I have read in docs it is timestamp plus row version but need more precisely.

We re using ifx_replcheck to identify changed rows since last recorded values for rows. Currently we are looking for why ifx_replcheck is different on table row where it seems values in all columns are the same. Table has insert, delete, update trigger defined. And one explanation could be the row is updated a couple of times but finally has the same value as when its state was recently recorded.

So we need to know when the change in ifx_replcheck was done

Thank you

Milan:

You are confusing the ifx_replcheck shadow column with the two VERCOLS shadow columns ifx_insert_checksum and ifx_row_version. The ifx_replcheck shadow column is a single column that just has a pseudo-timestamp in it. That value will always change when the row is updated whether with the same values or different values or even if it was deleted and re-inserted with the same values.

Just for completeness, the VERCOLS column ifx_insert_checksum contains a checksum of the row as it was when the row was inserted and does not change when the row is updated. The ifx_row_version starts at 1 and is incremented whenever the row is updated. 

So, here are the scenarios describing the behavior of the VERCOLS shadow columns:

• Row was deleted and reinserted with the same values:
  The ifx_row_version will be 1 and the ifx_insert_checksum will be the same.
• Row was deleted and reinserted with different values:
  The  ifx_row_version will be 1 and the ifx_insert_checksum will be different
• Row was updated to the same values:
  The ifx_row_version will have increased and the ifx_insert_checksum will be unchanged.
• Row was updated to different values in one or more columns:
  The ifx_row_version will have increased and the ifx_insert_checksum will be unchanged.

Art

Hello, can someone help with decoding value in ifx_replcheck? - I have read in docs it is timestamp plus row version but need more precisely.

We re using ifx_replcheck to identify changed rows since last recorded values for rows. Currently we are looking for why ifx_replcheck is different on table row where it seems values in all columns are the same. Table has insert, delete, update trigger defined. And one explanation could be the row is updated a couple of times but finally has the same value as when its state was recently recorded.

So we need to know when the change in ifx_replcheck was done

Thank you

Hello, can someone help with decoding value in ifx_replcheck? - I have read in docs it is timestamp plus row version but need more precisely.

We re using ifx_replcheck to identify changed rows since last recorded values for rows. Currently we are looking for why ifx_replcheck is different on table row where it seems values in all columns are the same. Table has insert, delete, update trigger defined. And one explanation could be the row is updated a couple of times but finally has the same value as when its state was recently recorded.

So we need to know when the change in ifx_replcheck was done

Thank you

Hi Milan,

try dbinfo('UTC_TO_DATETIME', ifx_bit_rightshift(ifx_replcheck, 32)).

Yes, ifx_replcheck does contain last update time which also enables "cdr check --since" functionality.
(It does not for pre-existing, still unmodified data in case REPLCHECK got added using ALTER TABLE.)

HTH,
 Andreas

Hello, can someone help with decoding value in ifx_replcheck? - I have read in docs it is timestamp plus row version but need more precisely.

We re using ifx_replcheck to identify changed rows since last recorded values for rows. Currently we are looking for why ifx_replcheck is different on table row where it seems values in all columns are the same. Table has insert, delete, update trigger defined. And one explanation could be the row is updated a couple of times but finally has the same value as when its state was recently recorded.

So we need to know when the change in ifx_replcheck was done

Thank you

Hi Milan,

try dbinfo('UTC_TO_DATETIME', ifx_bit_rightshift(ifx_replcheck, 32)).

Yes, ifx_replcheck does contain last update time which also enables "cdr check --since" functionality.
(It does not for pre-existing, still unmodified data in case REPLCHECK got added using ALTER TABLE.)

HTH,
 Andreas

Hello, can someone help with decoding value in ifx_replcheck? - I have read in docs it is timestamp plus row version but need more precisely.

We re using ifx_replcheck to identify changed rows since last recorded values for rows. Currently we are looking for why ifx_replcheck is different on table row where it seems values in all columns are the same. Table has insert, delete, update trigger defined. And one explanation could be the row is updated a couple of times but finally has the same value as when its state was recently recorded.

So we need to know when the change in ifx_replcheck was done

Thank you

Hi Milan,

try dbinfo('UTC_TO_DATETIME', ifx_bit_rightshift(ifx_replcheck, 32)).

Yes, ifx_replcheck does contain last update time which also enables "cdr check --since" functionality.
(It does not for pre-existing, still unmodified data in case REPLCHECK got added using ALTER TABLE.)

HTH,
 Andreas

Hello, can someone help with decoding value in ifx_replcheck? - I have read in docs it is timestamp plus row version but need more precisely.

We re using ifx_replcheck to identify changed rows since last recorded values for rows. Currently we are looking for why ifx_replcheck is different on table row where it seems values in all columns are the same. Table has insert, delete, update trigger defined. And one explanation could be the row is updated a couple of times but finally has the same value as when its state was recently recorded.

So we need to know when the change in ifx_replcheck was done

Thank you