PM40056: NUMBER OF UNLOADED ROWS FOR A LOGICAL UNLOAD WITH A WHERE CLAUSE MAY BE WRONG WHICH RESULTS IN MISSING ROWS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The number of unloaded rows for a logical unload with a WHERE
  clause involving a huge number of embedded AND or OR predicates
  may be wrong.
  The problem occurs only if the unload is processed in native
  mode.
  
  The symptom is the unload will be missing rows, therefore
  missing data.
  
  PB11198
  

Local fix

• For unloads from the table space (not from an image copy), with
  SQL statements which length do not exceed the 32 kB DB2 limit,
  the use of SQL mode by specifying the DB2 FORCE option solves
  the problem.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The number of unloaded rows for a       *
  *                      logical unload with a WHERE clause      *
  *                      involving a huge number of embedded     *
  *                      AND or OR predicates may be wrong. The  *
  *                      problem occurs only if the unload is    *
  *                      processed in native mode. Local fix:    *
  *                      For unloads from the table space (not   *
  *                      from an image copy), with SQL           *
  *                      statements which lengths do not         *
  *                      exceed the 32 kB DB2 limit, the use     *
  *                      of SQL mode by specifying the DB2       *
  *                      FORCE option solves the problem.        *
  *                      PB 11198                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The udbspgsq  module was fixed.
  

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:

Modules/Macros

•    INZADBSK INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK73227

     UP11/11/02 P F111

• R410 PSY UK73228

     UP11/11/02 P F111

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.