IT13966: UPDATE STATISTICS LOW WITH USTLOW_SAMPLE SET CRASHES OR HANGS THE ENGINE WHEN INDEX CONTAINS MANY DELETED ITEMS

APAR status

• Closed as program error.

Error description

• Update statistics low with ustlow_sample set crashes or hanges
  the engine when index has many deleted items:
  
  (oninit)afstack
  (oninit)afhandler
  (oninit)afcrash_interface
  (oninit)rstcb_cleanup
  (oninit)destroy_session
  (oninit)sq_exit
  (oninit)sqmain
  (oninit)listen_verify
  (oninit)spawn_thread
  (oninit)th_init_initgls
  (oninit)startup
  (oninit)coroutine_start
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users running Update stats that hit a leaf with 0 slots on   *
  * the page can see this                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC7                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC7
  

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

• RC10 PSN

     UP

• RC10 PSY

     UP