IC88543: ASSERTION FAILURE POSSIBLE IN SETCDRALTMODE() WHEN UNIQUE CONSTRAINT IS DROPPED ON A REPLICATED TABLE WHILE ER IS STOPPED

APAR status

• Closed as program error.

Error description

• When you drop a unique constraint on a replicated table while
  enterprise replication is stopped you can encounter an assertion
  failure with a stack like this
  
  afstack
  mt_ex_throw_sig
  afsig_handler
  <signal frame>
  SetCDRAltMode
  cdrDDLSetAltMode
  cdrDDLAlterTablePreDDL
  cdrPreDDLCallBack
  ddalter
  aud_ddalter
  excommand
  sq_execute
  sqmain
  spawn_thread
  startup
  
  This can happen when the automatically created unique constraint
  of a primary key on a table is to be dropped, which basically
  means that the primary key constraint shall be removed.
  
  Usually you should not drop this primary key constraint while a
  replicate is defined on the table, so to be able to successfully
  perform this alter command please delete all replicates on this
  table. For an otherwise defined unique constraint this behavior
  can not be observed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Enterprise Replication                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * An attempt to drop a unique constraint on a table defined    *
  * for replication when Enterprise Replication is in a stopped  *
  * state ("cdr stop") results in a server crash.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC8                                      *
  ****************************************************************
  

Problem conclusion

• The problem is fixed In IDS-11.70.xC8.
  

Temporary fix

Comments

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP