PH62070: CLOB not replicating in Event Publishing

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CLOB not replicating in Event Publishing
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- Customers using search conditions         *
  *                 2- Q capture with table DCC removed for      *
  *                 active subs                                  *
  *                 3- All Q Apply users                         *
  *                 4- All Capture users                         *
  *                 5- All SQL Apply users                       *
  *                 6- Customers using noncondensed CCD targets  *
  *                 7- Event Publishing users                    *
  *                 8- CCD users with before value columns       *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- Q Capture incorrectly replicates     *
  *                      rows partially matching search          *
  *                      condition                               *
  *                      2- Deactivate the subscription if DCC   *
  *                      is turned off while Capture is running  *
  *                      for an active subscription              *
  *                      3- During the recent run of Q Apply,    *
  *                      several instances of the ASN8999D       *
  *                      spillQ were observed in the logs.       *
  *                      These messages should not appear in     *
  *                      non-debug mode.                         *
  *                      4- Q Capture memory leak when adding    *
  *                      subscriptions                           *
  *                      5- SQL Apply failed if LOADX=Y and      *
  *                      target table is on LUW                  *
  *                      6- In Q Apply, the default value for    *
  *                      CHKDEP_NONCONDCCD should be N.          *
  *                      7- Event Publishing did not publish a   *
  *                      CLOB along with the other columns in a  *
  *                      source table.                           *
  *                      8- Drop column with target CCD with     *
  *                      before values does not work             *
  ****************************************************************
  1- Q Capture does not filter data properly using
  SEARCH_CONDITION when "IN_MEM_FILTER_EVAL=Y". For example, when
  for the given search condition `WHERE :C1 in
  ('EST_ZN','WST_NZ','NOR_ZN','STH_ZN')`, 'WST' is incorrectly
  replicated.
  2- If DCC is turned off while Capture is running for an active
  subscription, Capture does not detect it and stops capturing
  changes from the table. So data will be lost. When Capture
  restarts, it will detect DCC is turned off and issues ASN7018E
  and deactivates the subscription.
  3- The ASN8999D messages should be suppressed in non-debug mode
  4- There is a memory leak when adding subscriptions to a
  Capture that is already running with a large number of
  subscriptions. For each new subscription, the array of IFI
  filters is recreated, but the old one is not freed.
  5- SQL Apply in z/OS is encountering a -444 error when
  attempting to load a table in Db2 LUW using DSNUTILS. The LOAD
  utility, which is a part of the Db2 for z/OS Utilities suite,
  cannot be invoked for Db2 LUW targets.
  6- In Q Apply, the default value for CHKDEP_NONCONDCCD should
  be N. Noncondensed CCD targets should not have any
  dependencies, so changing the default for this parameter will
  allow for parallelism in Q Apply to improve performance.
  7- Event Publishing did not publish a CLOB along with the other
  columns in a source table. And Q Capture program received
  return code "6024" from routine
  "queueSub::writeXMLLOBDataChunk"
  8- Q Apply fails to find the correct before column name and
  does not drop the column from the target table
  

Problem conclusion

• 1- Q Capture will properly filter rows when using search
  conditions.
  2- If DCC was removed while capture is running for an active
  subscription, when restart Capture, it will deactivate the
  subscription and will not stop.
  3- These messages should be suppressed in non-debug mode to
  reduce log clutter and improve readability. Only critical
  messages and errors should be logged in non-debug mode.
  4- Capture should free the old array of filters when recreating
  the new array for an active subscription.
  5- SQL Apply is modified to ignore the LOAD option when the
  target is LUW and default to truncating the target table and
  performing a full refresh.
  6- The default value for CHKDEP_NONCONDCCD will be changed to
  N.
  7- Q Capture is changed to initialize an allocated buffer so
  data conversion and publishing will work correctly.
  8- Q Apply was fixed to drop both before and after value
  columns when that CCD column had before values and
  REPL_DROP_COL=Y
  Note: ASNCLP has been updated from v1159 s2409261137.
  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:

  UI98624 UI98625 UI98626 UI98627

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 UI98624

     UP24/10/08 P F410

• RB34 PSY UI98625

     UP24/10/09 P F410

• RB35 PSY UI98626

     UP24/10/09 P F410

• RB36 PSY UI98627

     UP24/10/09 P F410

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.