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

Obtain the fix for this APAR.

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 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.