PI95252: POTENTIAL MISSING, DUPLICATE OR UNEXPECTED ROWS WHEN UNLOADING FROMMAGE COPY REQUIRING SORT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• (HPU 5.1 only) The data unloaded from image copies (COPYDDN
  option) is not consistent with the content of the image copies.
  The unloaded data can be affected as follows:
  - an expected row is missing
  - an unexpected row is present
  This can occur if the following conditions are fulfilled:
  -  the data is unloaded from image copies (COPYDDN option) which
     occurs when one of the following condition applies:
     + the image copy is retrieved from the DB2 catalog (COPYDDN
  LAST_IC or COPYDDN -integer option) and the catalog
  (SYSIBM,SYSCOPY table) indicates it is an INLINE image copy
     + the input image copy is allocated in the JCL (COPYDDN
  ddname option) and the keyword INLINE or FROM_COPYTOCOPY or
  MERGE_IIC is specified
  - the involved image copies were taken while concurrent updates
  of the table occurred, in other words the images copies contain
  duplicate pages
  
  PB52193
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of High Performance Unload                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PI94890:                                                     *
  * An ABENDS0C4 or an unpredictable result occurs when one of   *
  * the following conditions are fulfilled:                      *
  * - case 1) DB2 HPU is used with the UNLOAD PLUS syntax and    *
  * requests the CSV format with the NULLSTRING '' option        *
  * - case 2) DB2 HPU is used with the HPU native syntax and     *
  * requested the DELIMITED format with the NULVAL '' option.    *
  *                                                              *
  * PI95252:                                                     *
  * The data unloaded from image copies (COPYDDN option) is not  *
  * consistent with the content of the image copies. The         *
  * unloaded data can be affected as follows:                    *
  * - an expected row is missing                                 *
  * - an unexpected row is present                               *
  * This can occur if the following conditions are fullfilled    *
  * -  the data is unloaded from image copies (COPYDDN option)   *
  * which processing involves a sort, which occurs when one of   *
  * the following condition applies:                             *
  *    + the image copy is retreived from the DB2 catalog        *
  * (COPYDDN LAST_IC or COPYDDN interger option) and the catalog *
  * (SYSIBM,SYSCOPY table) indicates it is an INLINE image copy  *
  *    + the input image copy is allocated in the JCL (COPYDDN   *
  * ddname option) and the keyword INLINE or FROM_COPYTOCOPY or  *
  * MERGE_IIC is specified                                       *
  * - the involved image copies were taken while concurrent      *
  * updates of the table occurred, in other words the images     *
  * copies contain duplate pages                                 *
  *                                                              *
  * PI95525:                                                     *
  * The unload should support logical unloads (OUTDDN) against   *
  * lists of objects (LISTDEF                                    *
  * statement and SELECT specifying FROM LIST) with SELECT       *
  * statements including a WITH UR clause.                       *
  *                                                              *
  * PI95528:                                                     *
  * In our procedure, a COBOL program defines which utility is   *
  * going to run (BMC or HPU).                                   *
  * The users inform all the values they need and this program   *
  * chooses between BMC or HPU.                                  *
  * Since HPU syntax is not compatible with comments starting    *
  * with '*', we need to write                                   *
  * an exception to force BMC every time it happens.             *
  *                                                              *
  * PI95529:                                                     *
  * The expected messages about the allocation of the image      *
  * copies involved in the unload of a                           *
  * partitioned table space are issued only for the image copy   *
  * of partition #1.                                             *
  * This occurs if the image copies are retreived from the DB2   *
  * catalog                                                      *
  * (i.e. COPYDDN LIAST_IC or COPYDDN -integer is specified) and *
  * these image copies are                                       *
  * FlashCopy image copies.                                      *
  *                                                              *
  * PI95531:                                                     *
  * An IEC161I 076-002 about an ICnnnnn ddname and the  INZI800E *
  * message are issued before                                    *
  * DB2 HPU stops with completion code 8 when unloading XML data *
  * from image copy (COPYDDN option).                            *
  * This occurs if the image copy of the XML table space is a    *
  * FlashCopy and the corresponding                              *
  * image copy of the base table space a regular image copy.     *
  *                                                              *
  * PI95532:                                                     *
  * An intermittent ABENDS0C4 can occurs when unloading LOB data *
  * from a partitionned table space.                             *
  * This can occur if the fix for PI93191/UI53940 is applied.    *
  *                                                              *
  * PI95534:                                                     *
  * DB2 HPU can terminate with ABENDU133 reason 3 while          *
  * unloading LOB/XML data from a FlashCopy.                     *
  *                                                              *
  * PI95555:                                                     *
  * An unload run with the EXECUTE NO option can stops with      *
  * ABENDS0C4 and issue the following traceback:                 *
  *     6  _inzztopoControlPartDdnLink +0000044A 1876 INZUTILK   *
  * inzztopo.c                                                   *
  *     7  _inzztopoEnhanceTopology +00000232 1421 INZUTILK      *
  * inzztopo.c                                                   *
  *     8  inzztopoAnalyse +00000122 150 INZUTILK inzztopo.c     *
  *     9  inzrunRunHpu+000003D6 343 INZUTILK inzrun.c           *
  *     10 main +0000192E 1553 INZUTILK inzmain.c                *
  *     11 CELQINIT +00001A52 CELQLIB CELQINIT                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF for problem resolution                         *
  ****************************************************************
  

Problem conclusion

• Code has been changed to fix this problem
  

Temporary fix

• PI94890:
  - case 1) if your HPU settings specify
  UNLOAD_PLUS_STRICT(NULLSTRING) in the VUU030/ULOPTNS parameter,
  remove the NULLSTRING '' from the unload command. Otherwise, no
  circumvention exists.
  - case 2) remove the NULLVAL '' option which is the default.
  

Comments

• ×**** PE21/05/11 FIX IN ERROR. SEE APAR PH37143  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI54811

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI54811

     UP18/04/05 P F804

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.