IBM Support

JR64754: IDR FOR POSTGRESQL ISSUES EVENT WARNING 9700 DUE TO REPORT POSITION BOOKMARK GOING BACKWARDS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • IDR for PostgreSQL issues event warning 9700 due to report
    position bookmark going backwards
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * This issue might affect you if you are using DR              *
    * 11.4.0.4-5625 or older for PostgreSQL as a source engine.    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Under certain circumstances, the Postgres Log Reader API     *
    * returns a transaction commit on an empty transaction that    *
    * has a much older log position than the previous commit that  *
    * was processed.                                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DR 11.4.0.4-5627 or newer for PostgreSQL.         *
    ****************************************************************
    

Problem conclusion

  • Upgrading to DR 11.4.0.4-5627 or newer for PostgreSQL resolves
    the issue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR64754

  • Reported component name

    IDR CDC POSTGRE

  • Reported component ID

    5725E30PS

  • Reported release

    B40

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-03-24

  • Closed date

    2022-03-31

  • Last modified date

    2022-03-31

  • 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

    IDR CDC POSTGRE

  • Fixed component ID

    5725E30PS

Applicable component levels

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

Document Information

Modified date:
01 April 2022