• 1 reply
  • Latest Post - ‏2013-04-07T20:19:04Z by Rphilo
9 Posts

Pinned topic CDC Subscriptions LiveAudit

‏2013-04-04T09:51:07Z | idr-cdc
I am using the mapping type Audit and would like to know if there is way to uniquely identify a record replicated by cdc? Like using the SEQNO?
tks  for the help
Updated on 2016-08-14T15:37:44Z at 2016-08-14T15:37:44Z by Ken Motilall
  • Rphilo
    595 Posts

    Re: CDC Subscriptions LiveAudit

    It depends on the source database. Different databases support the various system values in different ways and to different extents, as determined by the features offered by the database.
    For the iSeries. &SEQNO will hold the journal sequence number (when mirroring). However it may not be unique as when a journal receiver is rolled, the sequence number can be reset back to 0 for the new receiver. To be pretty much assured of generating a unique identifier you should also use the transaction &TIMSTAMP.
    For the zSeries, &SEQNO will be the LRSN or RBA when mirroring.
    I do not believe that &SEQNO is supported by any other database.