PM12601: UNLOAD IMAGE COPY GENERATES MSG FIELD OVERLAP END OF RECORD OR S0C7 OR S0C4

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When unloading from an image copy that was created on another
  DB2 subsystem, or on another table space, or before a
  DROP/CREATE operation on the same table space, the unloaded data
  may be incorrect in the following case:
  when the original table has been altered by adding new columns,
  and a REORG, or a LOAD REPLACE has not occured on the object
  before creating the image copy, and when the structure of the
  unloaded table on the target subsystem was created directly with
  the complete list of columns.
  The symptoms may be incorrect data for the added columns,
  potential abend S0C4 or S0C7, conversion errors or messages
  specifying FIELD OVERLAP END OF RECORD.
  PB10646
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When unloading from an image copy that  *
  *                      was created on another DB2 subsystem,   *
  *                      or on another table space, or before a  *
  *                      DROP/CREATE operation on the same table *
  *                      space, the unloaded data may be         *
  *                      incorrect in the following case:        *
  *                      when the original table has been        *
  *                      altered by adding new columns, and a    *
  *                      REORG, or a LOAD REPLACE has not        *
  *                      occured on the object before creating   *
  *                      the image copy, and when the structure  *
  *                      of the unloaded table on the target     *
  *                      subsystem was created directly with     *
  *                      the complete list of columns.           *
  *                      The symptoms may be incorrect data for  *
  *                      the added columns, potential abend      *
  *                      S0C4 or S0C7, conversion errors or      *
  *                      messages specifying FIELD OVERLAP END   *
  *                      OF RECORD.                              *
  *                      PM 10646                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzpab module was changed in order to not consider as
  mandatory the added columns.
  

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

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK58095

     UP10/06/24 P F006

• R320 PSY UK58096

     UP10/06/24 P F006

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.