PH25065: INFINITE LOOP IF INCORRECT USE OF THE ESCAPE CHARACTERS IN LIKE PREDICATE WITH ESCAPE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 HPU enters an infinite loop when a logical unload, run in
  native mode, specifies a WHERE clause involving a LIKE predicate
  with an ESCAPE escape-expression option and which
  pattern-expression does not comply with the following
  requirement:
  If escape-expression is specified, pattern-expression must not
  contain the escape character that is identified by
  escape-expression, except when immediately followed by the
  escape character, '%', or '_'. For example, if '+' is the escape
  character, any occurrences of '+' other than '++', '+_', or '+%'
  in the pattern is an error.
  

Local fix

• Run the unload in SQL mode by specifying the DB2 FORCE option.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Db2 HPU enters an infinite loop when a  *
  *                      logical unload, run in native mode,     *
  *                      specifies a WHERE clause involving a    *
  *                      LIKE predicate with an ESCAPE           *
  *                      escape-expression option and which      *
  *                      pattern-expression does not comply with *
  *                      the following requirement:              *
  *                      If escape-expression is specified,      *
  *                      pattern-expression must not contain the *
  *                      escape character that is identified by  *
  *                      escape-expression, except when          *
  *                      immediately followed by the escape      *
  *                      character, '%', or '_'. For example,    *
  *                      if '+' is the escape character, any     *
  *                      occurrences of '+' other than '++',     *
  *                      '+_', or '+%' in the pattern is an      *
  *                      error.                                  *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Infinite loop if incorrect use of the escape characters in LIKE
  predicate with ESCAPE
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

Modules/Macros

• INZ$$PRM INZTDSC  INZTVAR  INZUTIB1 INZUTIB2 INZUTILC INZUTILK
  INZUTILL
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI69508

     UP20/05/22 P F005

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.