PH49051: With many Q Capture replicating to one Q Apply, an upgrade of one capture causes CAPTURE_LEVEL to be upgraded for all Q Captures

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• When upgrading one Capture to a new function level, Q Apply may
  update CAPTURE_LEVEL in IBMQREP_RECVQUEUES table for all
  receive queue entries even for those associated with other
  Capture sources.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- All Q Capture users                       *
  *                 2- Multiple Q Capture sources going to a     *
  *                 single Q Apply target.                       *
  *                 3- Users that use CCD target tables and      *
  *                 want Updates split into Delete/Insert Pairs  *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- Q Capture source on Db2 v11 did not  *
  *                      work after customer migrated Db2 on     *
  *                      proxy systems to V12                    *
  *                      2- When upgrading one Capture to a new  *
  *                      function level, Q Apply may update      *
  *                      CAPTURE_LEVEL in IBMQREP_RECVQUEUES     *
  *                      table for all receive queue entries     *
  *                      even for those associated with other    *
  *                      Capture sources.                        *
  *                      3- CCD target tables with               *
  *                      CCD_KEYUPD_AS_DELINS=Y or               *
  *                      CCD_ALLUPD_AS_DELINS=Y and Apply        *
  *                      startup parameter MULTI_ROW_INSERT=Y    *
  *                      can sometimes get IBMSNAP_OPERATION=U   *
  *                      instead of splitting the update into    *
  *                      DELETE/INSERT. Workaround: Use          *
  *                      MULTI_ROW_INSERT=N                      *
  ****************************************************************
  1- Partitioned tables on Db2 v11 are not replicated after Db2
  on proxy system migrated to V12.
  2- When processing function level change from one Q Capture, Q
  Apply may update CAPTURE_LEVEL in IBMQREP_RECVQUEUES table for
  unrelated receive queues associated with other Q Capture
  sources incorrectly.
  3- Q Apply needs to able to split CCD Updates into
  Delete/Insert pairs when MULTI_ROW_INSERT is enabled.
  

Problem conclusion

• 1- Extract the partition number from the log record header for
  any version of Db2 log records. If this is a V12 log reader,
  and the paritionNo is not supplied in the LRH, it is either
  because the table is not partitioned or we are in proxy mode
  and the source is down-level.
  2- Q Apply will update CAPTURE_LEVEL in IBMQREP_RECVQUEUES only
  for the receive queue on which the function level change
  message is received from Q Capture.
  3- Q Apply is fixed to handle when MULTI_ROW_INSERT=Y and
  customer has CCD_KEYUPD_AS_DELINS=Y or CCD_ALLUPD_AS_DELINS=Y
  for CCD target tables
  ASNCLP was not updated.
  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:

  UI82517 UI82518 UI82519 UI82520

Modules/Macros

• ASN2BASE ASN2ZOSC ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCATM
  ASNCCMD  ASNCCPWK ASNMCMD  ASNMON   ASNQACMD ASNQAPP  ASNQAROW
  ASNQBRWZ ASNQCAP  ASNQCCMD ASNQDEP  ASNQEXRP ASNQMFMT ASNQXFMT
  ASNRBASE ASNTDIFF ASNTDSP  ASNTRC   ASNZOSCN
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RB33 PSY UI82517

     UP22/09/27 P F209

• RB34 PSY UI82518

     UP22/09/28 P F209

• RB35 PSY UI82519

     UP22/09/27 P F209

• RB36 PSY UI82520

     UP22/09/27 P F209

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.