IBM Support

PH31335: SQL APPLY SUPPORT OF TARGET DATABASE IN RREPL MODE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL Replication does not support target database in 'RREPL' mode
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1- All Q Capture users                       *
    *                 2- All SQL Apply users                       *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1- Q Capture stops when encountering    *
    *                      dictionary error and                    *
    *                      LOGRD_ERROR_ACTION=E is specified.      *
    *                      2- SQL Replication does not support     *
    *                      target database in 'RREPL' mode         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1- Q Capture did not handle LOGRD_ERROR_ACTION=E correctly.
    2- SQL Apply failed with ASN1001E when updating target database
    in RREPL mode.
    

Problem conclusion

  • 1- Q Capture is changed to deactivate a subscription when
    encountering a compression dictionary error and
    LOGRD_ERROR_ACTION=E is specified.
    2- Changed SQL Apply to register itself with DB2 as a
    replication program via the RRSAF SET REPLICATION function so
    that it can update target database in RREPL mode.
    Note: ASNCLP has been updated from db2_v111m4fp6 n2012091900.
    Function Level: 1140.103
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH31335

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    B33

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-11-05

  • Closed date

    2020-12-18

  • Last modified date

    2021-01-04

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

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

    UI73231 UI73232 UI73233 UI73234

Modules/Macros

  •    ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCATM
    ASNCCMD  ASNCLPAP ASNCLPCL ASNCLPCM ASNCLPCO ASNCLPMS ASNCLPQA
    ASNDBCON ASNMCMD  ASNMON   ASNQACMD ASNQAPP  ASNQCAP  ASNQCCMD
    ASNQDEP  ASNQEXRP ASNQMFMT ASNQXFMT ASNRBASE ASNTDIFF ASNTDSP
    ASNTRC   ASN2BASE ASN2DBCN
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • RB33 PSY UI73231

       UP20/12/30 P F012

  • RB34 PSY UI73232

       UP20/12/31 P F012

  • RB35 PSY UI73233

       UP20/12/30 P F012

  • RB36 PSY UI73234

       UP20/12/30 P F012

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.

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

Document Information

Modified date:
05 January 2021