IBM Support

JR65237: STRUCTURE OF TABLE HAS CHANGED EVENT RAISED EVEN THOUGH NO DDL OCCURRED IF THE TABLE HAS A FOR BIT DATA COLUMN AND TABLE DEFINIT

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

  • Structure of table has changed event raised even though no DDL
    occurred if the table has a FOR BIT DATA column and table
    definition is old
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * This issue might affect you if you are using IDR             *
    * 11.4.0.4-5666 or older for Db2 LUW                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Not available                                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IDR 11.4.0.4-5670 or newer for Db2 LUW            *
    ****************************************************************
    

Problem conclusion

  • Upgrading to IDR 11.4.0.4-5670 or newer for Db2 LUW resolves the
    issue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR65237

  • Reported component name

    IS CDC DB2 LUW

  • Reported component ID

    5725E30DL

  • Reported release

    B40

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-02-27

  • Closed date

    2023-03-03

  • Last modified date

    2023-03-03

  • 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 DB2 LUW

  • Fixed component ID

    5725E30DL

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:
04 March 2023