IC85389: ASSERTION FAILURE ON A SECONDARY SERVER "PG_FRPTR 3798 < SIZEOF(IFX_PAGE_T) 24 OR > SLOTBEG 3796" WHEN INSERTING ROWS INTO A TAB

APAR status

• Closed as program error.

Error description

• The secondary server (e.g. RSS, HDR, SDS) will get an assertion
  failure with the message below when inserting rows into a table
  with nchar columns used in the index and the database is created
  with case insensitivity.
  
  bfcheck: bad page: pg_frptr 3798 < sizeof(ifx_page_t) 24 or >
  slotbeg 3796
  
  The stack trace looks like:
  
  (oninit)afstack
  (oninit)afhandler
  (oninit)affail_interface
  (oninit)bffail
  (oninit)buffput
  (oninit)doadditem
  (oninit)plogredo
  (oninit)rlogm_redo
  (oninit)next_recvr
  (oninit)prod_loop2
  (oninit)producer_thread
  (oninit)startup
  

Local fix

• Change column to char from nchar and/or set database with case
  sensitivity.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * 11.70XC3 and above                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC6                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.xC6
  

Temporary fix

Comments

• http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp
  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