LI73629: SQL STATMENTS CONTAINIG LIKE PREDICATES CAN LEAK MEMORY WHEN RUN AGAINST VIEWS, LEADS TO SQL0954

APAR status

• Closed as program error.

Error description

• The following SQL statement:
  select * from testview where col1 like ?
  where the view is defined as:
  create view testview as select * from (values 'test') as TEST
      (col1) where 1 = 2
  will leak memory in the application heap. This can lead to
  SQL0954 errors.
  
  Running the same statement againast a normal table or a view
  defined as:
  create view testview as select * from (values 'test') as TEST
      (col1)
  will not leak memory.
  
  An additional indication is, that the rewritten SQL statement
  does not include the LIKE predicate anymore:
  SELECT NULL AS "COL1" FROM (VALUES) AS Q1 WHERE (1 = 2)
  

Local fix

• Remove the "WHERE 1 = 2" clausel from the view definition.
  

Problem summary

• USERS AFFECTED
  All
  
  PROBLEM SUMMARY
  See ERROR DESCRIPTION
  

Problem conclusion

• First fixed in DB2 UDB Version 8.1, FixPak 18
  

Temporary fix

• See LOCAL FIX.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  LI73566

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R810 PSN

     UP

• R820 PSN

     UP

• R910 PSN

     UP

• R950 PSN

     UP