PM16670: ABENDU1022 OR INCORROUT ON UNLOAD FIC

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• U1022 ABEND or incorrect output on an unload from an image copy
  for the following conditions:
  1.  The image copy was created while the table had a row format
      different from its initial one.  For example, when the
      VERSION value from SYSIBM.SYSTABLES for the involved table
      is greater than 0.
  2. The online (current) table involved in the unload has its
     initial row format, for instance when the VERSION value
     from SYSIBM.SYSTABLES for the involved table is 0.
     PB10677
  .
  Note:  The VERSION value from SYSIBM.SYSTABLE is greater than
         zero when:
         a.  an ALTER COLUMN statement has been performed in
             DB2 V8 or higher
         b.  an ALTER ADD column-definition has been performed
             in DB2 V9 or higher
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU may fail (e.g. with U1022 ABEND)    *
  *                      or produce incorrect output data When   *
  *                      an unload from an image copy is         *
  *                      requested. This occurs where the        *
  *                      following conditions are true:          *
  *                      - the image copy was created while      *
  *                      the table had a row format different    *
  *                      from its initial one (in other words,   *
  *                      the VERSION value from SYSIBM.SYSTABLES *
  *                      for the involved table was greater than *
  *                      0)                                      *
  *                      - the online (current) table involved   *
  *                      in the unload has its initial row       *
  *                      format (in other words, the VERSION     *
  *                      value from SYSIBM.SYSTABLES for the     *
  *                                                              *
  *                                                              *
  *                                                              *
  *                      involved table is 0).                   *
  *                      The VERSION value from SYSIBM.SYSTABLE  *
  *                      is greater than zero where:             *
  *                      - an ALTER COLUMN statement has been    *
  *                      performed (in DB2 V8 or higher)         *
  *                      - an ALTER ADD column-definition has    *
  *                      been performed in DB2 V9 or higher      *
  *                      PB 10677                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  udbcrrts module was changed to detect the unsupported situation
  and to stop the process by issuing a U1021 ABEND.
  

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 UK58894

     UP10/07/23 P F007

• R320 PSY UK58895

     UP10/07/23 P F007

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.