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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PK56188

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-11-07

  • Closed date

    2008-01-28

  • Last modified date

    2009-05-18

  • 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.



Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Replication Server

Software version:

910

Reference #:

PK56188

Modified date:

2009-05-18

Translate my page

Machine Translation

Content navigation