IT09687: UPDATE STATISTICS MAY RESULT IN ASSERT FAILURE IN HASHFULLNAME WHEN REFERENCING FREED DATA DICTIONARY ENTRY FOR TABLES USING REF

APAR status

• Closed as program error.

Error description

• When running update statistics in a database containing tables
  with referential constraints it is possible that an AF with a
  stack similar to the following may occur if a reference is made
  to a freed data dictionary entry that has been re-used.
  
  afstack
  mt_ex_throw_sig
  afsig_handler
  hashfullname
  getddhptr
  getshdicptrx
  fndiccp
  checkrefdicp
  verrefinfo
  blddicref
  bldrefsx
  bldrefs
  maybe_bldrefs
  ip_sqloptim
  ip_sqloptim
  cmp_stmt
  cmp_proc
  pr_compile
  aud_pr_compile
  updprocstat
  excommand
  sq_execute
  sqmain
  listen_verify
  spawn_thread
  th_init_initgls
  startup
  
  This stack is an example from an instance running the update
  statistics for procedure command.
  
  References to freed data dictionary entries are normally
  intercepted and handled appropriately however depending on the
  content of the re-used memory block there may be specific
  patterns which are not handled correctly resulting in the above
  AF.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * those using referential constraints                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 11.70.xC9                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 11.70.xC9
  

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 PSN

     UP

• RB50 PSY

     UP

• RB70 PSN

     UP

• RB70 PSY

     UP

• RC10 PSN

     UP

• RC10 PSY

     UP