IBM Support

JR65100: IIDR FOR POSTGRESQL TARGET DOES NOT ALLOW ADDITIONAL TABLE MAPPINGS IN SAME SUBSCRIPTION IN ORDER WHEN DB2I IS SOURCE.

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

  • IIDR for PostgreSQL target does not allow additional table
    mappings in same subscription in order when db2i is source.
    

Local fix

  • Add all the table mappings at once
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * This issue might affect you if you are replicating multiple  *
    * tables from Db2 for i to PostgreSQL.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When you try to save a second mapping within a subscription, *
    * you see an error.                                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IDR 11.4.0.4-5644 or newer for PostgreSQL.        *
    ****************************************************************
    

Problem conclusion

  • Upgrading to IDR 11.4.0.4-5644 or newer for PostgreSQL resolves
    the issue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR65100

  • 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-07-20

  • Closed date

    2022-07-29

  • Last modified date

    2022-09-08

  • 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

[{"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 September 2022