PM60124: A LOGICAL UNLOAD WITH A WHERE CLAUSE HAVING AN IN PREDICATE ON CHAR DATA RETURNS AN INCORRECT NUMBER OF ROWS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical unload with a WHERE clause having an IN predicate on
  CHAR data returns an incorrect number of rows.
  
  This occurs only if one of the items of the IN predicate has
  trailing blanks as in the following example:
  
  UNLOAD TABLESPACE
  QUIESCE NO
  DB2 NO
  SELECT NAME
  FROM SYSIBM.SYSPACKAGE
  WHERE NAME IN (
                 'ADB27AC ' ,
                 'ADB27SP' ,
                 'ADB2CHK' ,
                 'ADB2CID' ,
                 'ADB2CON' ,
                 'ADB2REP'
                )
  OUTDDN (UNLDDN1)
  FORMAT DSNTIAUL STRICT ;
  
  PB11487
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A logical unload with a WHERE clause    *
  *                      having an IN predicate on char data     *
  *                      returns an incorrect number of rows.    *
  *                      This occurs only if the table encoding  *
  *                      scheme is not EBCDIC and at least one   *
  *                      of the items of the IN predicate has    *
  *                      trailing blanks as in the following     *
  *                      example:                                *
  *                      UNLOAD TABLESPACE                       *
  *                      QUIESCE NO                              *
  *                      DB2 NO                                  *
  *                      SELECT NAME                             *
  *                      FROM SYSIBM.SYSPACKAGE                  *
  *                      WHERE NAME IN (                         *
  *                                    'ADB27AC ' ,              *
  *                                    'ADB27SP' ,               *
  *                                    'ADB2CHK' ,               *
  *                                    'ADB2CID' ,               *
  *                                    'ADB2CON' ,               *
  *                                    'ADB2REP'                 *
  *                                   )                          *
  *                      OUTDDN (UNLDDN1)                        *
  *                      FORMAT DSNTIAUL STRICT ;                *
  *                      PB 11487                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  ocher and inode modules were changed to remove the trailing
  blanks before comparing the values involved in the IN predicate.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK77749 UK77750

Modules/Macros

•    INZRSAVE INZTPMEM INZUTILK INZUTILX INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK77749

     UP12/04/12 P F204

• R410 PSY UK77750

     UP12/04/12 P F204

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.