IBM Support

PH00518: Q APPLY ACTIVATES A Q SUBSCRIPTION AFTER IT ATTEMPTS TO LOAD THE TARGET TABLE AND THE LOAD FAILS.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as unreproducible in next release.

Error description

  • Q Apply activates a Q subscription after it attempts to load
    the target table and the load fails.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1- All SQL Apply customers.                  *
    *                 2- All Q Apply customers.                    *
    *                 3- Q Apply                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1- The SQL Apply ASNLOAD exit calls     *
    *                      the Db2 SYSPROC.DSNUTILS stored         *
    *                      procedure to run Db2 utilities (LOAD,   *
    *                      REPAIR).                                *
    *                      2- Q Apply activates a Q subscription   *
    *                      after it attempts to load the target    *
    *                      table and the load fails.               *
    *                      3- Q Apply agents interrupted for       *
    *                      program stop may commit a partially     *
    *                      applied transaction if it encounters a  *
    *                      rare race condition in message logging  *
    *                      shutdown logic and attempts to          *
    *                      directly issue a ASN message into       *
    *                      IBMQREP_APPLYTRACE table and commit.    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1- The SQL Apply ASNLOAD exit needs to be changed to call
    either the Db2 SYSPROC.DSNUTILU stored procedure or the Db2
    SYSPROC.DSNUTILS stored procedure to run Db2 utilities (LOAD,
    REPAIR).
    2- The Q Apply load function is not returning the Db2 load
    utility return code.
    3- During Q Apply program stop, race conditions in msgLogger
    disable code may lead to Apply agents with partially applied
    transaction to issue commit instead of rollback if an ASN
    message gets issued to APPLYTRACE table.
    

Problem conclusion

Temporary fix

Comments

  • 1- The SQL Apply ASNLOAD exit has been changed to call either
    the SYSPROC.DSNUTILS or SYSPROC.DSNUTILU stored procedure to
    run Db2 utilities (LOAD, REPAIR).
    2- The Q Apply load function has been changed to return the Db2
    load utility return code.
    3- Q Apply stop processing is fixed to avoid agents with
    partial transactions from directly issuing ASN messages into
    IBMQREP_APPLYTRACE table or doing commit.
    Note: ASNCLP has been updated from db2_v105fp11 n180809.
    

APAR Information

  • APAR number

    PH00518

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    A21

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-07-13

  • Closed date

    2018-08-15

  • Last modified date

    2018-09-04

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

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

    UI57892 UI57893 UI57894 UI57895

Modules/Macros

  •    ASNAAPP  ASNACMD  ASNACMP  ASNADMSP ASNAFET
    ASNAISO  ASNAMAN  ASNAPP   ASNAPPLY ASNAPRS  ASNAWPN  ASNBNDDR
    ASNBNDSR ASNBPXB  ASNCAP   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
    ASNISLKM ASNISMKD ASNITIT  ASNJAJP  ASNKOKR  ASNLKMSG ASNLOAD
    ASNMCMD  ASNMDATA ASNMKDIR 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 ASNQMZ10 ASNQNMIH ASNQPROF ASNQP2PA ASNQP2PI ASNQSPC
    ASNQSPIL ASNQSPS  ASNQSQLZ ASNQXFMT ASNQZV10 ASNQ1001 ASNQ1021
    ASNRBASE ASNRURU  ASNSFALL ASNSMZ10 ASNSQLCZ ASNSVSE  ASNS1001
    ASNS1021 ASNTDIFF ASNTDSP  ASNTDSQL ASNTRC   ASNUOW   ASNVCD
    ASNVMON  ASNVREOR ASNVSQL  ASNV1001 ASNV1021 ASNZHCN  ASNZHTW
    ASNZOSCN ASN2BASE ASN2DBCN ASN2DB2C ASN2DB2Q ASN2SQLZ ASN2ZOSC
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • RA21 PSY UI57892

       UP18/08/24 P F808

  • RA24 PSY UI57893

       UP18/08/24 P F808

  • RA25 PSY UI57894

       UP18/08/24 P F808

  • RA26 PSY UI57895

       UP18/08/24 P F808

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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A21","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 September 2018