PK56188: CAPTURE AND APPLY - CHANGE THE REQUIREMENT TO HAVE THE IBM C/C++ IBM OPEN CLASS LIBRARY RUN-TIME AVAILABLE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Currently Capture and Apply require the services from the
  C/C++ IBM Open Class Library runtime.  However, the Z/OS
  Migration (from z/OS V1R7) VERSION 1 RELEASE 9 (GA22-7499-11)
  says that the runtime will be removed in V1R9.
  Those are the libraries called SCLBDLL and SCEERUN.  Without
  those libraries capture and apply will fail with error:
    CEE3501S The module IOSTREAM was not found.
  GA22-7499-11 does says those libraries can be downloaded and
  installed but eventually products using them should be changed.
  This situation is related to this URL
  http://www-01.ibm.com/support/docview.wss?&uid=swg24016105
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- No major impact - Q Apply users using     *
  *                 Load_Type = 1, 2 or in IBMQREP_TARGETS table *
  *                 2- z/OS customers using Q Capture            *
  *                 plan/packages bound using BIND option        *
  *                 KEEPDYNAMIC(NO).                             *
  *                 3- users of asnmon QCAPTURE_LATENCY          *
  *                 condition who hit end of log then latency    *
  *                 calculation will use this col                *
  *                 4- ALL                                       *
  *                 5- z/OS customers using load with QApply     *
  *                 6- z/OS customers running replication        *
  *                 programs on z/OS V1.9.                       *
  *                 7- users who only provided FROM value in     *
  *                 rangecol option                              *
  *                 8- Users with delimited format and the       *
  *                 LOB_SEND_OPTIONS=S                           *
  *                 9- ALL                                       *
  *                 10- Q Apply                                  *
  *                 11- Users altering source table while        *
  *                 Capture is running.                          *
  *                 12- Q Capture                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- String "Source Table" and string     *
  *                      "Target Table" were getting printed     *
  *                      instead of the actual table names.      *
  *                      2-  The Q Capture prune thread gets     *
  *                      SQLCODE -518 when it attempts to prune  *
  *                      tables.                                 *
  *                      3- never used this column before        *
  *                      4- Avoid using the subscription object  *
  *                      for intra-thread communication when     *
  *                      disabling a subscription. Use internal  *
  *                      subID and subVersion instead, for       *
  *                      correctness.                            *
  *                      5-  SQL error was not handled           *
  *                      correctly in asnqload.                  *
  *                      6-  Replication programs running on     *
  *                      z/OS V1.9 terminate after displaying    *
  *                      message:  CEE3501S The module IOSTREAM  *
  *                      was not found.                          *
  *                      7- when only 'FROM' was specified       *
  *                      where clause was built incorrectly      *
  *                      with >= and <=                          *
  *                      8- Capture will 0C4 when trying to      *
  *                      send LOB values in the delimited        *
  *                      format.                                 *
  *                      9- Q Apply stops when it detects        *
  *                      non-QREP messages or messages with an   *
  *                      older sequence time, making it          *
  *                      difficult for the user to selectively   *
  *                      delete such messages.                   *
  *                      10- Timing problem causes pruning of    *
  *                      Donemsg Deltomb table to slow down      *
  *                      causing receive queue to fill up.       *
  *                      11- Capture terminated after source     *
  *                      table was altered.                      *
  *                      12- Q Capture might receive SIGSEGV     *
  *                      with debug option while replicating     *
  *                      LOB data                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1- Replace the hardcoded strings with actual table names
  2-  The Q Capture prune thread needs to prepare the SQL
  statement it executes to prune tables after a commit point if
  its plan/packages were bound using BIND option KEEPDYNAMIC(NO).
  3- use last_eol_time for qcapture_latency condition
  4- Use subID and subVersion to disable subscription.
  5-  When there is a SQL error selecting from source server
  during load, handle errors appropriately.
  6-  The IBM Open Class USL IOSTREAM Library (CBC.SCLBDLL) is
  not shipped with z/OS V1.9.
  7- incorrect where clause
  8- The delimited message format does not support sending lobs
  in separate messages.  It only supports inlined lobs
  9-  Q Apply stops when it detects non-QREP messages or messages
  with an older sequence time.
  10- A timing problem causes the Admin thread to calculate wrong
  return times from the prune DoneMsg and Deltomb loops that
  causes the pruning to slow down or stop.
  11- Capture should handle alter source table correctly.
  12- The debug printing routine should be fixed to prevent
  memory allocation error
  

Problem conclusion

• 1- Fixed an error message where the Source table and Target
  table name was not getting printed.
  2- Modify Q Capture to prepare the prune SQL statement if DB2
  has invalidated the statement.
  3- latency will be calculated correctly even if end of log is
  reached.
  4- Use subID and subVersion to disable subscription.
  5- Asnqload has been modified to fix the problem.
  6- Modify replication programs to use Standard C++ classes
  instead of IBM Open Class Library (IOC) classes.
  7- fixed to say >= ex: TIMECOL >= '11:52:51'
  8- Capture will not allow the user to activate a delimited
  publication if LOB_SEND_OPTIONS=I.  It will give the error
  message ASN7172.
  9- Q Apply will delete such messages from the queue and
  continue normal processing.
  10- Fixed the calculations of the timing variables to ensure
  that they never get stale and have sane values.
  11- Capture had been fixed to handle alter table log records
  correctly.
  12- Q Capture does not receive SIGSEGV with debug option while
  replicating LOB data
  

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:

  UK33286 UK33287 UK33288 UK33289

Modules/Macros

•    ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCCMD
  ASNLOAD  ASNMCMD  ASNMDATA ASNMIG8  ASNMON   ASNMONIT ASNMSGT
  ASNMUPDT ASNPLXFY ASNQACMD ASNQAHKT ASNQAPAG ASNQAPP  ASNQAROW
  ASNQASUB ASNQBRWZ ASNQCAP  ASNQCCMD ASNQDEP  ASNQLODZ ASNQMFMT
  ASNQP2PA ASNQP2PI ASNQSPIL ASNQSQL  ASNQSUB  ASNQSUBM ASNQXFMT
  ASNRBASE ASNREG   ASNSQLCF ASNTDIFF ASNTRC   ASNTREP
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• R910 PSY UK33286

     UP08/02/06 P F802

• R911 PSY UK33287

     UP08/02/06 P F802

• R912 PSY UK33288

     UP08/02/07 P F802

• R913 PSY UK33289

     UP08/02/06 P F802

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.