Skip to main content

JR45688: CDC6.5.1 for INFORMIX: MIRROR FAILS IF SOURCE TABLE HAS NO PRIMARY KEY AND HAS LOB FIELDS


Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • CDC 6.5.1 for Informix: When using Informix as a replication,
    mirror will fail if source table has no primary and has LOB
    fields.
    

Local fix

  • create primary key constraint
    

Problem summary

  • Replication in CDC Informix 6.5.1 might may end with
    an error if the source table contains a LOB column and has
    no primary key.
    

Problem conclusion

  • This issue is fixed by applying ISCDC 6.5.1 Interim Fix 7 for
    Informix.
    

Temporary fix

  • Add a primary key to the source table and update source table
    definition afterwards.
    

Comments

APAR Information

  • APAR number

    JR45688

  • Reported component name

    IS CDC INFORMIX

  • Reported component ID

    5724U7009

  • Reported release

    651

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-07

  • Closed date

    2013-02-08

  • Last modified date

    2013-02-08

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

    JR44928

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

Fix information

  • Fixed component name

    IS CDC INFORMIX

  • Fixed component ID

    5724U7009

Applicable component levels

  • R651 PSY

       UP

Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

InfoSphere Change Data Capture

Scraper


Software version:
651


Reference #:
JR45688


Modified date:
2013-02-08

Translate my page

Content navigation