PH25262: &UNIQ NOT IDENTICAL FOR ALL PARTITION USING SQLPART IN SQL MODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• &uniq not identical for all partition using SQLPART in SQL mode
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Db2 HPU creates output data sets for    *
  *                      the unloaded data (OUTDDN option) with  *
  *                      incorrect names if these output data    *
  *                      sets are allocated through a TEMPLATE   *
  *                      statement which name-expression         *
  *                      specified for the DSN option involves   *
  *                      both the &PART. or &PA.. and the &UNIQ. *
  *                      variable. The &UNIQ. part of the name   *
  *                      of the output dataset that should be    *
  *                      the same for all the data containing    *
  *                      data from the same table space varies   *
  *                      along with the partition number.        *
  *                                                              *
  *                      This occurs if the following conditions *
  *                      are fulfilled:                          *
  *                      - the data is unloaded from a           *
  *                      partitioned table space having more     *
  *                      than 1 partition                        *
  *                      - the unload is processed in SQL mode   *
  *                      - the unload specifies the SQLPART      *
  *                      option specifying more than one         *
  *                      partition                               *
  *                                                              *
  *                      A subsequent attempt to load the        *
  *                      unloaded data with the IBM LOAD utility *
  *                      with a LOAD statement using a TEMPLATE  *
  *                      statement specifying the same DSN       *
  *                      option as the one used for the unload   *
  *                      leads to an error reported through      *
  *                      error message as in the following       *
  *                      example:                                *
  *                      DSNU1015I 091 08:53:22.77 DSNUGDYN -    *
  *                      ERROR ALLOCATING DATA SET               *
  *                      DSN=MZLFRD.DBTL CODE=X'17080002'        *
  *                      DSNU1042I 091 08:53:22.77 DSNUGDYN -    *
  *                      START OF IDCAMS MESSAGES                *
  *                      IKJ56228I DATA SET                      *
  *                      MZLFRD.DBTLS00.FRDBAK06.P00002.VKNMB6Q3 *
  *                      NOT IN CATALOG OR CAT                   *
  *                      DSNU1043I 091 08:53:22.77 DSNUGDYN -    *
  *                      END OF IDCAMS MESSAGES                  *
  *                      DSNU012I 091 08:53:22.83 DSNUGBAC -     *
  *                      UTILITY EXECUTION TERMINATED, HIGHEST   *
  *                      RETURN CODE 8                           *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  &uniq unduly not identical for all partitions if SQLPART option
  specified
  

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:

  UI70170

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.