IBM Support

JR58679: DATA REPLICATION STALLS WHEN THERE ARE FREQUENT BACKUPS WHILE REPLICATION IS CLOSE TO THE HEAD OF LOG

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When Microsoft SqlServer is backed up frequently, this can cause
    CDC for SqlServer to not replicate changes as they are being
    processed, and replication stalls.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * This issue affects users with IIDR 11.4.0.0-5036 to 5039 for *
    * SqlServer, where the datastore is used on the source.        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Subscriptions remain active but do not progress.             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IIDR 11.4.0.0-5040 or later for SqlServer.        *
    ****************************************************************
    

Problem conclusion

  • Upgrading to IIDR 11.4.0.0-5040 or later for SqlServer resolves
    the issue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR58679

  • Reported component name

    IS CDC SQL

  • Reported component ID

    5725E30SQ

  • Reported release

    B40

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-11-02

  • Closed date

    2017-12-14

  • Last modified date

    2017-12-14

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

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

Fix information

  • Fixed component name

    IS CDC SQL

  • Fixed component ID

    5725E30SQ

Applicable component levels

  • RB40 PSY

       UP



Document information

More support for: InfoSphere Data Replication

Software version: B40

Reference #: JR58679

Modified date: 14 December 2017