PH23762: ABEND OR INCORRECT DATA UNLOADED FROM IMAGE COPY IF ONLINE TABLEWITH VERSIONS AND COPIED TABLE WITH NO VERSION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 HPU terminates in ABEND or unload incorrect data when the
  following conditions are fulfilled:
  - the data is unloaded from an image copy data set (COPYDDN
  option)
  - the input image copy contains the data from a table (the
  "copied" table) that had no version at the time of copy
  - the input image copy contains the description of the version 0
  - the table designated by the UNLOAD statement (the "online"
  table) has versions
  - the OBID of the copied and the online tables are different
  which requires the specification of ORIGINOBID in the UNLOAD
  statement
  (the value of VERSION from the SYSIBM.SYSTABLES catalog table is
  greater than 0 for this table)
  

Local fix

• if applicable, add the DDLDDN option to provide Db2 HPU with the
  DDL of the object to unload.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Db2 HPU terminates in ABEND or unload   *
  *                      incorrect data when the following       *
  *                      conditions are fulfilled:               *
  *                      - the data is unloaded from an image    *
  *                        copy data set (COPYDDN option)        *
  *                      - the input image copy contains the     *
  *                        data from a table (the "copied"       *
  *                        table) that had no version at the     *
  *                        time of copy                          *
  *                      - the input image copy contains the     *
  *                        description of the version 0          *
  *                      - the table designated by the UNLOAD    *
  *                        statement (the "online" table) has    *
  *                        versions                              *
  *                      - the OBID of the copied and the online *
  *                        tables are different which requires   *
  *                        the specification of ORIGINOBID in    *
  *                        the UNLOAD statement                  *
  *                      (the value of VERSION from the SYSIBM.  *
  *                      SYSTABLES catalog table is greater than *
  *                      0 for this table)                       *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  ABEND or incorrect data unloaded from Image Copy if online table
  with versions and copied table with no version
  

Problem conclusion

• Code has been changed to fix this problem
  

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

• INZ$$PRM INZTDSC  INZTVAR  INZUTIB1 INZUTIB2 INZUTILC INZUTILK
  INZUTILL
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI69508

     UP20/05/22 P F005

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.