PM88474: INZU147E ERROR : DUPLICATE COLUMN XXX IN ORDER BY CLAUSE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical unload fails (completion code 8) and issues
  msgINZU147E ERROR : DUPLICATE COLUMN xxx IN ORDER BY CLAUSE when
  the ORDER BY clause of the SQL statement has duplicate
  sort-keys.
  
  As this is tolerated by both DB2 and BMC UNLOAD PLUS and since
  the redundant sort-keys has no effect on the sequence of the
  output rows, it should also be tolerated by DB2 HPU.
  
  PB11904
  

Local fix

• Specify the HPU DB2 FORCE option to run in SQL mode.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A logical unload fails (completion      *
  *                      code 8) and issues msgINZU147E ERROR :  *
  *                      DUPLICATE COLUMN xxx IN ORDER BY        *
  *                      CLAUSE when the ORDER BY clause of the  *
  *                      SQL statement has duplicate sort-keys.  *
  *                      As this is tolerated by both DB2 and    *
  *                      BMC UNLOAD PLUS and since the redundant *
  *                      sort-keys has no effect on the          *
  *                      sequence of the output rows, it should  *
  *                      also be tolerated by DB2 HPU.           *
  *                      PB 11904                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Module inzpab was changed to allow and ignore when a column
  appears several times in an order by clause.
  

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

• R410 PSY UK96616

     UP13/08/15 P F308

• R420 PSY UK96617

     UP13/08/15 P F308

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.