Data Integration

 View Only
Expand all | Collapse all

IDR on IBM i - RGZPFM on source: what does it reflects on destination?

  • 1.  IDR on IBM i - RGZPFM on source: what does it reflects on destination?

    Posted Sun January 09, 2022 03:34 PM

    Good day:

    What does IDR reflect on IBM i destination when a RGZPFM is executed on IBM i source side?  Is there any difference when the replication is based on Primary Key or when it is based on RRN?  Is there any datasource configuration parameter that modifies this behavior?

    I couldn't find details on IBM Documents (former Knowledge Center) and I need to know for planning some changes on my applications.

    Thank you so much



    ------------------------------
    Daniel Jose Lema Guanziroli
    ------------------------------


    #DataReplication
    #DataIntegration


  • 2.  RE: IDR on IBM i - RGZPFM on source: what does it reflects on destination?

    Posted Mon January 10, 2022 01:11 AM
    Daniel

    The CLRPFM (=truncate table) is registered in the iSeries journal as a CR entry type. For a database target I would expect all the target data to be removed. If the mappings and the database type permit, a truncate table or CLRPFM is performed. If the mappings do not permit a truncate (e.g. the table operation to clear data before a refresh or in response to a truncate is disabled by a delete where clause) all relevant rows are deleted (which is a lot slower than a truncate table of course). Specifically for an iSeries target, if the D_MIRROR user does not have *ALL authority to the target table, a row-by-row delete is done in that case also.

    If you wish to suppress the truncate operation on the target you can simply specify a row fiter on the iSeries source to omit where &ENTTYP='CR'


    For a non-database target such as Kafka or Flat File, I believe nothing is registered on the target. As the CDC target is not stateful in the same way as a database, a truncate table has no meaning.

    Hope this helps

    Robert

    ------------------------------
    Robert Philo
    ------------------------------