PI95461: ABENDS0C4 INZU447E 218 * FIELD OVERLAPS END OF RECORD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• (HPU 5.1 only)
  An unpredictable issue occurs when data is unloaded from n image
  copy if the following conditions are fulfilled:
  * the input image copy is a global one
       (A global image copy is a copy of a whole tablespace
        versus copies at the partition level.)
  * the image copy contains compressed data except in the
    first partition
  * a PART clause that does not include the first partition
    is specified
  * the target table resides in a not compressed table space
  
  Possible symptoms include the following:
  * ABENDS0C4 with reason code 11
  * completion code 8 after the INZU447E and following message:
      218 * FIELD OVERLAPS END OF RECORD
  * incorrect unloaded data
  
  PB52261 ABENDS0C4 ABEND0C4 S0C4 0C4
  MSGINZU447E MSGINZU447 INZU447E INZU447
  

Local fix

• Use the DDLDDN feature and provide the same DDL as the target
  object but with the COMPRESS YES attribute.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of High Performance Unload                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PI95207:                                                     *
  * When unloading the data from image copies for at least 10    *
  * tablespaces, the unload can terminate in ABEND (ABENDU1010   *
  * in HPU 4.3, not determined in HPU 5.1) if the following      *
  * conditions are fulfilled:                                    *
  * - one of the involved table space is a partition-by-growth   *
  * table space                                                  *
  * - the involved input image copies are allocated dynamically  *
  * by DB2 HPU (COPYDD LAST_IC or COPYDDN -integer is specified  *
  * of COPYDDN tempdd with tempdd is a TEMLATE name)             *
  * - the UNLOAD statement specifies more than 10 SELECT         *
  * statements (either explicitly or using a FROM LIST clause)   *
  *                                                              *
  * PI95461:                                                     *
  * An unpredictable issue occurs when data is unloaded from n   *
  * image copy if the following conditions are fulfilled:        *
  * - the input image copy is a global one                       *
  * - the image copy contains compressed data except in the      *
  * first partition                                              *
  * - a PART clause that does not include the first partition is *
  * specified                                                    *
  * - the target table resides in a not compressed table space   *
  * Some possible symptoms are:                                  *
  * - ABENDS0C4 with resaon code 11                              *
  * - completion code 8 after the INZU447E and 218 * FIELD       *
  * OVERLAPS END OF RECORD messages have been issued             *
  * - incorrect unloaded data                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF for problem resolution                         *
  ****************************************************************
  

Problem conclusion

• Apply the PTF for problem resolution
  

Temporary fix

• PI95207:
  If applicable, split the unload into several unloads with less
  than 10 table space or 10 SELECT statements involved.
  
  PI95461:
  use the DDLDDN feature and provide the same DDL as the target
  object but with the COMPRESS YES attribute.
  

Comments

• ×**** PE21/06/14 FIX IN ERROR. SEE APAR PH12191  FOR DESCRIPTION
  

APAR Information

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

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

  UI55109

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI55109

     UP18/04/12 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.