IC79982: -239/-100 OR -268/-100 FOR SERIAL AFTER HDR FAILOVER ON NEW PRIMARY

APAR status

• Closed as program error.

Error description

• After failover, on the new primary, insert statements get
  -239/-100 or -268/-100 because of a serial value.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of tables with SERIAL, SERIAL8, or BIGSERIAL columns   *
  * on HDR, SDS, and RSS secondary servers.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * At a secondary server, the partition header saving the       *
  * current value for a SERIAL, SERIAL8, or BIGSERIAL column is  *
  * not updated correctly if the SERIAL, SERIAL8, or BIGSERIAL   *
  * column reaches its maximum value and rolls over to 1.  If    *
  * this happens and the secondary server ever becomes a         *
  * standard or primary server, attempts to insert into the      *
  * table containing the SERIAL, SERIAL8, or BIGSERIAL column    *
  * will result in duplicate values for the column(s).           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC10 or later.                          *
  ****************************************************************
  

Problem conclusion

• Fixed in IDS 11.50.xC10.
  

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

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels

• RB50 PSY

     UP

• RB70 PSY

     UP