IC82354: CAN DEFINE A REPLICATE ON TABLES WITH DIFFERING PRIMARY KEY DEFINITION

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

  • It is possible to define a replicate, mastered or not, on tables
    whose primary key definitions have differing fields. This can be
    different columns (by name), types and even number of fields.
    
    If you're lucky this will surface similar to following when
    synchronizing the replicate, but this depends on the general
    table schema (when internal checks are satisfied this problem
    might as well go unnoticed):
    
    Starting synchronization scan for replicate
              tx_repl_g_al117t
    
    Error in cmpCol
            SQL types do not match for c(108) s(103)
    command failed -- Source and Target do not have the same data
    type (202)
    
    ... or ...
    
    command failed -- table column undefined  (3)
    Error Details:
            SQLCODE:-217 Server g_al117s and table tx:Column
    (ifx_erkey_1) not found in any table in the query (or SLV is
    undefined).
    
    
    Having differing primary key definitions might be acceptable
    when relying on --erkey, but then the synchronization shouldn't
    fail.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ER customers on 11.70                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IDS-11.70.xC5                                      *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In IDS-11.70.xC5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC82354

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-03-29

  • Closed date

    2012-10-31

  • Last modified date

    2012-11-01

  • 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

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

  • RA10 PSN

       UP

  • RA10 PSY

       UP

  • RB10 PSN

       UP

  • RB10 PSY

       UP

  • RB50 PSN

       UP

  • RB50 PSY

       UP

  • RB70 PSN

       UP

  • RB70 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

B50

Reference #:

IC82354

Modified date:

2012-11-01

Translate my page

Machine Translation

Content navigation