IC62640: WITH STATEMENT CACHE ENABLED A SELECT IN A CASE STATEMENT USING A SUBQUERY IN THE PROJECTION LIST RETURNS -769 ERROR/SEGV ASSERT

APAR status

• Closed as program error.

Error description

• When the following select is run with statement cache turned on,
  it will return a -769 error
  when run for the fourth time and will sometimes cause the server
  to crash with a segv.  The
  query is quite complex but can be reduced to the following to
  see the -769 error.
  
  case when
    table2_a.col1 in (select table1_a.col1 from table1 table1_a
      where table1_a.col2=2009) then 'Value'
  end
  from table2 table2_a
  
  -769: Internal - iterator execution/phase error UNKNOWN
  ITERATOR.
  
  The assertions show very similar stacks apart from the actual
  end function which is either
  clscan_create or sort_create.
  
  Stack trace information from the AF files:
  
  clscan_create + 0xa0  [oninit]
  it_create + 0x1d0  [oninit]
  prepselect + 0x240  [oninit]
  
  sort_create + 0xb4  [oninit]
  it_create + 0x290  [oninit]
  prepselect + 0x240  [oninit]
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IDS users with statement cache set using subquery inside     *
  * projection list 'case' statement.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When SSC is set and a projection list subquery is used       *
  * inside a CASE statement, the server gives an iterator        *
  * execution error.                                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC6 and above.                          *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in IDS 11.50.xC6.
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP