IBM Support

PH44950: Support replicating updates as delete/insert pair for Q Apply CCD Targets (CCD_ALLUPD_AS_DELINS)

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Adding support for source KEY
    UPDATES can be split into a DELETE
    (which updates the original row) and
    an INSERT with the new values at CCD
    target
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1- Users that want to split CCD Key Updates  *
    *                 into Delete Insert pair                      *
    *                 2- Users that use CCD target tables and      *
    *                 want Updates to be split all source updates  *
    *                 into Delete/Insert Pairs                     *
    *                 3- CCD Users who want to use a larger        *
    *                 IBMSNAP_AUTHID column length.                *
    *                 4- ALL CAPTURE users                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1- Adding support for source KEY        *
    *                      UPDATES can be split into a DELETE      *
    *                      (which updates the original row) and    *
    *                      an INSERT with the new values at CCD    *
    *                      target                                  *
    *                      2- Adding support for all source        *
    *                      UPDATES to be split into a DELETE/      *
    *                      INSERT for Non Condensed CCD) and key   *
    *                      updates to be split into delete/insert  *
    *                      for condensed                           *
    *                      3- Q Replication does not support the   *
    *                      CCD IBMSNAP_AUTHID column with lengths  *
    *                      greater than VARCHAR(30).               *
    *                      4- Print capparm                        *
    *                      REINIT_ON_OUTORDER_LOG and change       *
    *                      default to Y                            *
    ****************************************************************
    1- Q Apply needs to able to split source table Key Updates into
    Delete/Insert pairs for CCD target controlled by optional
    column CCD_KEYUPD_AS_DELINS in the IBMQREP_TARGETS table.
    2- Q Apply needs to able to split CCD Updates into
    Delete/Insert pairs and should be controlled by optional column
    CCD_ALLUPD_AS_DELINS in the IBMQREP_TARGETS table.
    3- Q Replication deactivates any CCD targets where the
    IBMSNAP_AUTHID column is longer than VARCHAR(30) length
    4- Capparm REINIT_ON_OUTORDER_LOG should be set to Y by default
    and should always be printed to the log
    

Problem conclusion

  • 1- Adding optional column CCD_KEYUPD_AS_DELINS which enables
    source KEY UPDATES to CCD targets to be split into a
    DELETE(which updates the original row and marks operation as D)
    and an INSERT which inserts the new values.
    2- Adding optional column CCD_ALLUPD_AS_DELINS to enables KEY
    UPDATES and regular UPDATES to CCD targets to be split into a
    DELETE(which updates the original row for Condensed CCD and
    marks operation as D and inserts the before values for Non
    Condensed CCD) and an INSERT which inserts the new values.
    CCD_UPD_AS_DELINS=Y - all updates go to target as Delete/Insert
    for non condensed CCD. For condensed CCD, since it can not have
    duplicates for the key the IBMSNAP_operation will be marked as
    U for non key updates. For key updates, the key that was
    updated will be marked as D at target and the new value of the
    key will be marked as I at target.
    CCD_UPD_AS_DELINS=N - all updates will be marked as U at target
    for condensed CCD and a U record will be inserted for non
    condensed CCD.
    CCD_KEYUPD_AS_DELINS=Y - key updates go to the target as
    Delete/Insert for non condensed CCD. For condensed CCD the key
    that was updated will be marked as D at target and the new
    value of the key will be marked as I at target.
    CCD_KEYUPD_AS_DELINS=N - key updates will be marked as U at
    target for condensed CCD and a U record will be inserted for
    non condensed CCD.
    3- Add support to Q Apply to tolerate IBMSNAP_AUTHID column
    lengths longer than VARCHAR(30)
    4- Change the default for Capture parameter
    REINIT_ON_OUTORDER_LOG to Y and always print to the log.
    Function Level: 1140.103
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH44950

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    B33

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-03-16

  • Closed date

    2022-03-24

  • Last modified date

    2022-06-10

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI79876 UI79877 UI79878 UI79879

Modules/Macros

  • ASN2BASE ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCATM  ASNCCMD
    ASNCLPAP ASNCLPCL ASNCLPCM ASNCLPCO ASNCLPMS ASNCLPQA ASNMCMD
    ASNMON   ASNQACMD ASNQAHKT ASNQAPAG ASNQAPP  ASNQAROW ASNQASUB
    ASNQBRWZ ASNQCAP  ASNQCCMD ASNQDEP  ASNQEXRP ASNQLODZ ASNQMFMT
    ASNQP2PA ASNQP2PI ASNQSPIL ASNQSQLZ ASNQXFMT ASNRBASE ASNTDIFF
    ASNTDSP  ASNTRC
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • RB33 PSY UI79876

       UP22/03/29 P F203

  • RB34 PSY UI79877

       UP22/03/30 P F203

  • RB35 PSY UI79878

       UP22/03/30 P F203

  • RB36 PSY UI79879

       UP22/03/30 P F203

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B33"}]

Document Information

Modified date:
11 June 2022