PH26119: ABENDU1009 OR INCORRECT ORDER FOR THE UNLOADED ROWS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical unload (SELECT statement and OUTDDN option) with an
  ORDER clause terminates in ABENDU1009 or produces output data
  not ordered as requested.
  This occurs if the following conditions are fulfilled:
  - the unload is run in native mode
  - the data is unloaded from a partitioned tablespace
  - some of the involved partitions involved in the unload are in
  reordered row format (RRF).
  - the unload specifies the FORMAT INTERNAL option
  - the ORDER key contains one non variable data type column
  located after a variable data type column, in other words, for
  a table described through the Db2 catalog, a variable data type
  column with a column number, (i,e, the value of the COLNO column
  from the SYSIBM,SYSCOLUMNS table, greater than the column number
  of a variable data type column)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: A logical unload (SELECT statement and  *
  *                      OUTDDN option) with an ORDER clause     *
  *                      terminates in ABENDU1009 or produces    *
  *                      output data not ordered as requested.   *
  *                      This occurs if the following conditions *
  *                      are fulfilled:                          *
  *                      - the unload is run in native mode      *
  *                      - the data is unloaded from a           *
  *                      partitioned tablespace                  *
  *                      - some of the involved partitions       *
  *                      involved in the unload are in reordered *
  *                      row format (RRF).                       *
  *                      - the unload specifies the FORMAT       *
  *                      INTERNAL option                         *
  *                      - the ORDER key contains at least:      *
  *                         - one variable data type column      *
  *                         - and one non variable data type     *
  *                         column located, in the table, after  *
  *                         a variable data type column (for     *
  *                         example, for a table described       *
  *                         through the Db2 catalog, a variable  *
  *                         data type column with a column       *
  *                         number - COLNO from the              *
  *                         SYSIBM,SYSCOLUMNS table - greater    *
  *                         than the column number of a variable *
  *                         data type column)                    *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  ABENDU1009 or incorrect order for the unloaded rows
  

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

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI70170

     UP20/07/01 P F006

• R510 PSY UI70173

     UP20/07/01 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.