PH41040: Q Capture looping when q is full and using parallel mq thread

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Q Capture looping when q is full and using parallel mq thread
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- All Capture users                         *
  *                 2- All Capture users                         *
  *                 3- Q Capture users                           *
  *                 4- All SQL Apply users                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- Q Capture abended when decoding      *
  *                      COMMENT statement                       *
  *                      2- Q Capture support of Db2 z/OS        *
  *                      IFI306 filter by partition range        *
  *                      3- Q Capture looping when q is full     *
  *                      and using parallel mq thread            *
  *                      4- SQL Apply should retry using DELETE  *
  *                      when TRUNCATE target table fails with   *
  *                      sqlcode -150                            *
  ****************************************************************
  1- Q Capture abended when decoding COMMENT statement
  2- Db2 z/OS has implemented a range partition filter in IFI
  306. Q Capture is changed to use this enhancement to improve
  Capture program performance for subscriptions by
  range-partition.
  3- Q Capture loops endlessly when running with
  parallel_mqthread=Y and hitting a qfull condition.
  4- Currently, when performing a fullrefresh, the APPLY program
  will execute the TRUNCATE command
  

Problem conclusion

• 1- Capture is changed to check the column datatype of zero
  before decoding.
  2- Q Capture is enhanced to pass the partition range in the
  filter when invoking IFI 306 for subscriptions by
  range-partition. There is no impact for regular subscriptions
  and it simply pass the values 0000.
  3- Fixed the rc when the queue is full in a few places.
  4- Apply should retry this operation with DELETE since VIEW is
  a supported target type.
  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:

  UI78141 UI78142 UI78143 UI78144

Modules/Macros

• ASN2BASE ASN2SQLZ ASNAAPP  ASNACMD  ASNADMSP ASNAPPLY ASNCAP
  ASNCATM  ASNCCMD  ASNMCMD  ASNMON   ASNQACMD ASNQAHKT ASNQAPAG
  ASNQAPP  ASNQAROW ASNQBRWZ ASNQCAP  ASNQCCMD ASNQDEP  ASNQEXRP
  ASNQLODZ ASNQMFMT ASNQP2PI ASNQSPIL ASNQXFMT ASNRBASE ASNSQLCZ
  ASNTDIFF ASNTDSP  ASNTRC
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RB33 PSY UI78141

     UP21/11/30 P F111

• RB34 PSY UI78142

     UP21/12/01 P F111

• RB35 PSY UI78143

     UP21/11/30 P F111

• RB36 PSY UI78144

     UP21/12/01 P F111

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.