IT37127: A QUERY WILL CAUSE AN AF (POSSIBLY WITH -874) IF ANSI JOIN IS USED

APAR status

• Closed as program error.

Error description

• A query containing ANSI joins may cause a segmentation
  violation, possibly with the error:
  
  -874 General exception error has occurred in the optimizer.
  
  
  ANSI joins typically have the form of:
  [LEFT|RIGHT|FULL] [OUTER] JOIN tab1 ON tab1:col = tab2:col
  
  ... but it may be possible to direct the optimizer (+ ORDERED)
  to use an ANSI join and achieve the same result.
  
  
  A typical Linux x86_64 stack:
  
  00000000014a5f2d
    tos: 0x00000000445bc180
  state: running
     vp: 1
  
  0x00000000014a5f2d (oninit) afstack
  0x00000000014aae49 (oninit) afhandler
  0x00000000014ab502 (oninit) affail_interface
  0x00000000014abfca (oninit) mt_ex_throw_sig
  0x00000000014ba1c8 (oninit) afsig_handler
  0x00007f6802316b10 (Linux) <signal frame>
  0x00000000009760e8 (oninit) op_join
  0x00000000009798ad (oninit) op_phasejoin
  0x000000000083c4f1 (oninit) sqoptim
  0x0000000000a98fae (oninit) bldstructs
  0x0000000000aa63da (oninit) sqcmd
  0x0000000000aa68fd (oninit) sq_prepare
  0x0000000000b8dc2e (oninit) sqmain
  0x00000000015d5286 (oninit) spawn_thread
  0x0000000001496903 (oninit) th_init_initgls
  0x00000000014ddb2f (oninit) startup
  

Local fix

• To work around this problem, the following dynamic onconfig
  change
  may help:
  
  onmode -wm OPT_ANSIJOIN_P1PRUNE=100
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC15 and 14.10.xC7.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 12.10.xC15 or 14.10.xC7 (when     *
  * available).                                                  *
  ****************************************************************
  

Problem conclusion

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