PK10379: INZI151E EXECUTING HPU

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1) INZI151E (error finding DB2 version number Reason Code: 12)
  is issued incorrectly when executing HPU.  PB 7381
  2) ORDER BY plus parallelism plus single SYSREC gets an
     ABENDU0046 when unloading with SORT.   PB 7356
  3) HPU unloads data from the tablespace although IMAGECOPY
     FULL 0 is specified.   PB 7372
  4) Duplicated output records when unloading from a partitioned
     tablespace with more than 999 partitions (DB2 V8).
     PB 7395
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- INZI151E (error finding DB2 version  *
  *                       number Reason Code: 12) is issued      *
  *                       incorrectly when executing HPU.        *
  *                       PB 7381                                *
  *                      2- ORDER BY plus parallelism plus       *
  *                       single SYSREC gets an ABENDU0046 when  *
  *                       unloading with SORT.                   *
  *                       PB 7356                                *
  *                      3- HPU unloads data from the tablespace *
  *                       although IMAGECOPY FULL 0 is specified *
  *                       PB 7372                                *
  *                      4- Duplicated output records when       *
  *                       unloading from a partitioned           *
  *                       tablespace with more than 999          *
  *                       partitions (DB2 V8).                   *
  *                       PB 7395                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1- inzmain module was changed so that msgINZI151E is not issued
   any more and a new message is issued only in some relevant
   cases (internal errors)
  2- udbsputs module was changed to provide a better estimation
   for the size of the SORT work data sets
  3- inzpyacc was modified to take the INFILE IMAGECOPY clause
   into account
  4- Virtual work data sets names now include a 4 digit number
   (instead of 3).
  

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:

  UK06880 UK06881

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK06880

     UP05/09/07 P F509

• R220 PSY UK06881

     UP05/09/07 P F509

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.