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

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

• For download information, go to:
  http://www.ibm.com/support/fixcentral
  

APAR Information

• 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