PH69938: Q Capture incorrectly issues many ASN8999D messages when there is a row exceeds the message buffer. This is fixing regression

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Q Capture incorrectly issues many ASN8999D messages when there
  is a row exceeds the message buffer. This is fixing
  the regression that was introduced in APAR PH68780
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1-  Q capture with table DCC not on when     *
  *                 Capture started                              *
  *                 2- all Capture users                         *
  *                 3- All Capture users                         *
  *                 4- All users that have inactive send queues  *
  *                 5- All z/os users.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- Capture does not activate a sub if   *
  *                      DCC was not on while Capture started    *
  *                      and DCC was turned on while Capture is  *
  *                      running.                                *
  *                      2- Error in Capture for sub in stopped  *
  *                      queue after DROPCOL                     *
  *                      3- CAPSTART Fails with ASN7167E for     *
  *                      empty altered tables after MOVE TABLE   *
  *                      4- Q Capture keeps writing messages to  *
  *                      inactive send queue and issues          *
  *                      ASN7173W and ASN7015W messages.         *
  *                      5- When there is row can't fit to the   *
  *                      remaining message buffer size, Q        *
  *                      Capture will resize the buffer if       *
  *                      possible, or put the row(s) already in  *
  *                      the message buffer on the queue and     *
  *                      tries to rewrite the current row to     *
  *                      the buffer. But in this case, Q         *
  *                      Capture incorrectly writes ASN8999D     *
  *                      messages before it resizes the buffer   *
  *                      or put the current row on the queue.    *
  ****************************************************************
  1- If DCC  is turned on while Capture is running for a new
   table, Capture does not start the sub and gives a bad error
  message.
  2- Capture failed ASN7004E when restarting the stopped queue
  after DROPCOL
  3- A table was altered and moved from another tablespace. The
  version of the table was non-zero. Capture should not require
  user to REORG if the tablespace is defined as DEFINE NO.
  4- When a send queue is already inactive, Q Capture still tries
  to put messages to this send queue. Because the queue is
  already inactive, it is impossible to write any message to the
  queue and Q Capture issues ASN7173W and ASN7015W messages.
  5- If a row exceeds the remaining message buffer size, Q
  Capture incorrectly writes the ASN8999D messages before it
  resizes or flushes the buffer.
  

Problem conclusion

• 1- If DCC is turned on for a table  while capture is running ,
  Capture will start the sub if a CAPSTART signal is issued.
  2- Capture is changed to always get schema information from the
  VERSION table during queue restart.
  3- Capture should not issue ASN7167E if the SYSTABLEPART.SPACE
  is -1  and skip the REORG check.
  4- If the send queue is already inactive, Q Capture will not
  write any message to this send queue.
  5- Q Capture will resize or flush the buffer when there is a
  row exceeds the remaining message buffer size, and only issues
  the ASN8999D message if the buffer can't be resized or flushed.
  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:

  UO06727 UO06728 UO06729 UO06730

Modules/Macros

• ASN2BASE ASN2DB2C ASN2DB2Q ASN2DBCN ASN2SQLZ ASN2ZOSC ASNAAPP
  ASNACMD  ASNACMP  ASNADMSP ASNAFET  ASNAISO  ASNAMAN  ASNAPP
  ASNAPPLY ASNAPRS  ASNAWPN  ASNBNDDR ASNBNDSR ASNBPXB  ASNCAP
  ASNCATM  ASNCCDA  ASNCCDD  ASNCCMD  ASNCCPWK ASNCDA   ASNCDD
  ASNCDINS ASNCLP   ASNCLPAP ASNCLPB  ASNCLPCL ASNCLPCM ASNCLPCO
  ASNCLPCT ASNCLPEV ASNCLPMS ASNCLPQA ASNCLPRM ASNCMPLD ASNCSCZ
  ASNCTLZD ASNDADK  ASNDB2CN ASNDB2SQ ASNDBCON ASNDEDE  ASNDONE
  ASNENUP  ASNENUS  ASNESES  ASNFIFI  ASNFRFR  ASNITIT  ASNJAJP
  ASNKOKR  ASNLOAD  ASNMCMD  ASNMDATA ASNMON   ASNMONIT ASNMPROC
  ASNMUPDT ASNNONO  ASNPLPL  ASNPRUNE ASNPTBR  ASNQ1021 ASNQ1140
  ASNQACMD ASNQAHKT ASNQAPAG ASNQAPP  ASNQAROW ASNQASUB ASNQBNDE
  ASNQBNDL ASNQBNDR ASNQBNDT ASNQBRWZ ASNQCAP  ASNQCCDA ASNQCCDD
  ASNQCCMD ASNQCTLZ ASNQDEFQ ASNQDEP  ASNQEXRP ASNQFALL ASNQJ001
  ASNQJ002 ASNQLODZ ASNQMFMT ASNQMSTP ASNQNMIH ASNQP2PA ASNQP2PI
  ASNQPROF ASNQSPC  ASNQSPIL ASNQSPS  ASNQSQLZ ASNQXFMT ASNRBASE
  ASNRURU  ASNS1021 ASNSFALL ASNSQLCZ ASNSVSE  ASNTDIFF ASNTDSP
  ASNTDSQL ASNTRC   ASNUOW   ASNV1021 ASNV1140 ASNVCD   ASNVMON
  ASNVREOR ASNVSQL  ASNZHCN  ASNZHTW  ASNZOSCN
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RB33 PSY UO06727

     UP26/02/10 I 1000

• RB34 PSY UO06728

     UP26/02/11 I 1000

• RB35 PSY UO06729

     UP26/02/11 I 1000

• RB36 PSY UO06730

     UP26/02/11 I 1000

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.