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

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