IBM Support

PH23855: NEED A NEW INVOCATION PARAMETER FOR THE ACTION THAT Q CAPTURE SHOULD TAKE WHEN A SUBSCRIBED TABLE IS DROPPED.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Dropping a source table for an active subscription caused
    erroneous behavior for Q Capture.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1- ALL Capture users                         *
    *                 2- All Replication users                     *
    *                 3- All Q Capture users                       *
    *                 4- All Q Capture customers                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1- Too many ASN0635I messages in the    *
    *                      job log.                                *
    *                      2- Replication tasks issued a SELECT    *
    *                      from SYSIBM.SYSLEVELUPDATES table to    *
    *                      check the DB2 level information. If     *
    *                      the user did not have the right         *
    *                      authority, the SQL statement returned   *
    *                      SQLCODE -551. Subsequently the          *
    *                      replication tasks also failed           *
    *                      3- Dropping a source table for an       *
    *                      active subscription caused erroneous    *
    *                      behavior for Q Capture.                 *
    *                      4- Q Capture displays ASN0725W plus     *
    *                      diagnostic data and continues           *
    *                      executing after its log reader detects  *
    *                      out of order log records.               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1- Currently Capture puts out an ASN0635I message for every row
    in IGNTRAN table. It will be too many messages in the job log
    if there are thousands of rows in IGNTRAN table.
    2- Replication task failed when checking the
    SYSIBM.SYSLEVELUPDATES table for Db2 level information and the
    user did not have the right authority.
    3- When a subscribed table is dropped, the user needs to tell
    Capture how to handle the subscription.
    4- Q Capture will display ASN0725W plus diagnostic data,
    rollback uncommitted MQ transactions and reinitialize after its
    log reader detects out of order log records first time, display
    ASN0725W plus diagnostic data and stop after its log reader
    detects out of order log records second time if its
    REINIT_ON_OUTORDER_LOG is 'Y'. Q Capture will display ASN0725W
    plus diagnostic data and stop after the log reader detects out
    of order log records if its REINIT_ON_OUTORDER_LOG is 'N'
    (Default).
    

Problem conclusion

Temporary fix

Comments

  • 1- Capture was fixed to suppress the ASN0635I message from the
    job log.  It will only go to the .log.
    2- Replication initialization is changed to ignore any SQL
    error when checking the SYSIBM.SYSLEVELUPDATES table for Db2
    level information.
    3- Q Capture will provide a new option "DROPTAB_ACTION" for
    user to specify the action that Q Capture should take when a
    subcribed table is dropped.
    4- The Q Capture REINIT_ON_OUTORDER_LOG parameter has been
    added to prevent data loss the log reader detects out of order
    log records
    Note: ASNCLP has been updated from db2_v111m4fp6 s2004231900.
    Functional level: 1140.103
    

APAR Information

  • APAR number

    PH23855

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    B33

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2020-03-30

  • Closed date

    2020-04-30

  • Last modified date

    2020-06-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI69297 UI69298 UI69299 UI69300

Modules/Macros

  •    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  ASNDBCON ASNDB2CN
    ASNDB2SQ ASNDEDE  ASNDONE  ASNENUP  ASNENUS  ASNESES  ASNFIFI
    ASNFRFR  ASNITIT  ASNJAJP  ASNKOKR  ASNLOAD  ASNMCMD  ASNMDATA
    ASNMON   ASNMONIT ASNMPROC ASNMUPDT ASNNONO  ASNPLPL  ASNPRUNE
    ASNPTBR  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 ASNQPROF
    ASNQP2PA ASNQP2PI ASNQSPC  ASNQSPIL ASNQSPS  ASNQSQLZ ASNQXFMT
    ASNQ1021 ASNQ1140 ASNRBASE ASNRURU  ASNSFALL ASNSQLCZ ASNSVSE
    ASNS1021 ASNTDIFF ASNTDSP  ASNTDSQL ASNTRC   ASNUOW   ASNVCD
    ASNVMON  ASNVREOR ASNVSQL  ASNV1021 ASNV1140 ASNZHCN  ASNZHTW
    ASNZOSCN ASN2BASE ASN2DBCN ASN2DB2C ASN2DB2Q ASN2SQLZ ASN2ZOSC
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • RB33 PSY UI69297

       UP20/05/12 P F005

  • RB34 PSY UI69298

       UP20/05/12 P F005

  • RB35 PSY UI69299

       UP20/05/12 P F005

  • RB36 PSY UI69300

       UP20/05/12 P F005

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 June 2020