PM50669: WRONG NUMBER OF ROWS IN LOGICAL UNLOAD IF SELECT INCLUDES WHERE CLAUSE WITH PREDICATE REQUESTING COMPARISON OF TWO VARCHAR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU 3.2 only:
  The number of rows in the output of a logical unload can be
  wrong if the SELECT statement includes a WHERE clause with a
  predicate requesting the comparison of two varchar data.
  
  PB11296
  

Local fix

• Use the SQL access by specifying DB2 FORCE.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *                 All users of HPU 3.2.                        *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  *                      The number of rows in the output of     *
  *                      a logical unload can be wrong if the    *
  *                      SELECT statement includes a WHERE       *
  *                      clause with a predicate requesting      *
  *                      the comparison of two varchar data.     *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• The UDBSPGSQ  module was changed.
  

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

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK74261

     UP11/12/02 P F112

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.