IT41351: HASH JOINS REQUIRING OVERFLOW NOW FAILING WITH -208

APAR status

• Closed as program error.

Error description

• After upgrade to 14.10.xC4W1 (or 12.10.xC14) and newer, hash
  joins that so far ran well can now fail with error -208.
  
  Trapping the error would show the join in following stack:
  
   afstack
   afhandler
   affail_interface
   check_traperror
   sqerr
   ha_insrt_hashtab_or_ovrfl_page
   hjoin_open
   producer_thread
   startup
  
  With hash joins so far relying on PSORT_DBTEMP setting, this
  might appear as though PSORT_DBTEMP didn't work any more - which
  is true only indirectly.
  

Local fix

• Turn on (add) flag 0x10000000 in onconfig SQL_DEF_CTRL parameter
  to get back the old behavior (first determine its current value
  using 'onstat -g cfg SQ_DEF_CTRL).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server 12.10.xC14+ and 14.10.xC4W1+.       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 12.10.xC16 or 14.10.xC9.          *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC16 and 14.10.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