PI41195: ROWS FROM ONE PARTITION WRITTEN IN OUTFILE OF ANOTHER PARTITION,LEADS TO UNEXPECTED EXTRA NUMBER OF ROWS O 15/05/15 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When unloading a partitioned table space into one output file
  per partition, some rows from one partition can be written into
  the outfile meant for another partition.
  The extra rows are also written in the correct output file, thus
  leading to an overall extra number of unloaded rows.
  
  This can occur if the following conditions are fulfilled :
  - the fix for PI30581/PB12589 is applied
  - the output format applicable to the unload is FORMAT INTERNAL
  
  and either of the following conditions is true :
  - the data are unload an image copy (COPYDDN)
    and ORIGINOBID 0 was specified
  - the data is unloaded from the table space (native mode) or
    from an image copy and the OBID of the online table in
    hexadecimal end with 2 zeroes (i.e. its representation is
    like x'xx00'), or, its decimal value is either 0 or
    a multiple of 256.
  
  PB12793 dupe
  

Local fix

• If ORIGINOBID 0 was specified, specify the actual OBID of the
  table stored in the image copy.
  
  Otherwise no circumvention exists unless a single output file
  for all partitions is acceptable.
  In such a case, specifying a unique output data set allows to
  get the correct overall output data.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When unloading a partitioned table      *
  *                      space into one output file per          *
  *                      partition, some rows from one           *
  *                      partition can be written into the       *
  *                      outfile meant for another partition.    *
  *                      The extra rows are also written in the  *
  *                      correct output file, thus leading to    *
  *                      an overall extra number of unloaded     *
  *                      rows.                                   *
  *                      The can occur if the following          *
  *                      conditions are fulfilled :              *
  *                      - the fix for PI30581 is applied        *
  *                      - the output format applicable to the   *
  *                      unload is FORMAT INTERNAL               *
  *                      pb 12793                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The UDBCRFEL  module was changed.
  

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:

  UI28951 UI28952

Modules/Macros

•    INZ$$PRM INZADTOO INZCHECK INZHPUCL INZLAUNC
  INZTSSID INZTVAR  INZUTILK INZZSCOD
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI28951

     UP15/07/03 P F507

• R430 PSY UI28952

     UP15/07/03 P F507

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.