PM72012: HPU INCORRECT SECONDARY EXTENT ALLOCATIONS WHEN MAXPRIME SPECIFIED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Specifying MAXPRIME in the definition of a TEMPLATE should limit
  both the primary and the secondary allocation.
  Currently it only limits the primary allocation, leading to a
  secondary that may be too big to fit on the DASD.
  
  The HPU manual specifies for MAXPRIME:
  
  Specifies the maximum allowable primary space allocation. The
  value is expressed in cylinders (CYL). This value constrains the
  primary space value, the PCTPRIME calculation, and the size of
  each secondary allocation.
  
  In addition the DB2 UTilities Guide gives more detains on the
  space allocation:
  
  By default, for data sets on disk, 100 percent of the required
  space that is estimated by DB2 is allocated as a primary
  quantity. If this amount of space is typically not available on
  a single volume, specify the PCTPRIME option with a value lower
  than 100. Alternatively, if you want the upper limit of the
  primary quantity based on size instead of percentage, use the
  MAXPRIME option.
  
  After the primary space is allocated, a secondary quantity that
  is equal to the estimated required space is divided into the
  specified number of secondary extents. This number is identified
  by the NBRSECND option.
  
  Individual utilities might request larger secondary extents to
  compensate for localized uncertainty in the space estimations.
  If you specify either PCTPRIME or MAXPRIME, any secondary
  allocation requests are limited to the size of the primary
  allocation.
  
  DB2 HPU should follow these rules when calculating primary and
  secondary allocations.
  
  PB11591
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Specifying MAXPRIME in the definition   *
  *                      of a TEMPLATE should limit both the     *
  *                      primary and the secondary allocation.   *
  *                      Currently it only limits the primary    *
  *                      allocation, leading to a secondary      *
  *                      that may be too big to fit on the DASD. *
  *                      The HPU manual specify for the          *
  *                      MAXPRIME: Specifies the maximum         *
  *                      allowable primary space allocation.     *
  *                      The value is expressed in cylinders     *
  *                      (CYL). This value constrains the        *
  *                      primary space value, the PCTPRIME       *
  *                      calculation, and the size of each       *
  *                      secondary allocation. In addition the   *
  *                      DB2 UTilities Guide gives more detains  *
  *                      on the space allocation: By default,    *
  *                      for data sets on disk, 100 percent of   *
  *                      the required space that is estimated    *
  *                      by DB2 is allocated as a primary        *
  *                      quantity. If this amount of space is    *
  *                      typically not available on a single     *
  *                      volume, specify the PCTPRIME option     *
  *                      with a value lower than 100.            *
  *                      Alternatively, if you want the upper    *
  *                      limit of the primary quantity based on  *
  *                      size instead of percentage, use the     *
  *                      MAXPRIME option. After the primary      *
  *                      space is allocated, a secondary         *
  *                      quantity that is equal to the           *
  *                      estimated required space is divided     *
  *                      into the specified number of secondary  *
  *                      extents. This number is identified by   *
  *                      the NBRSECND option. Individual         *
  *                      utilities might request larger          *
  *                      secondary extents to compensate for     *
  *                      localized uncertainty in the space      *
  *                      estimations. If you specify either      *
  *                      PCTPRIME or MAXPRIME, any secondary     *
  *                      allocation requests are limited to the  *
  *                      size of the primary allocation.         *
  *                      DB2 HPU should follow these rules when  *
  *                      calculating primary and secondary       *
  *                      allocations.                            *
  *                      PB11591                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The infgucb module was fixed so that the secondary quantities
  are set to MAXPRIME is this option is specified.
  

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:

  UK81569

Modules/Macros

•    INZUTILK INZUTILX
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UK81569

     UP12/09/11 P F209

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.