Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 pageset preformat quantity adjustment
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: In general, DB2 preformat quantity of   *
  *                      the pageset is based on two space       *
  *                      allocation units.  Allocation unit is   *
  *                      either track or cylinder.  There are    *
  *                      cases where the secondary allocation    *
  *                      quantity is very large but because the  *
  *                      allocation unit is in track, DB2        *
  *                      preformat quantity remains as two       *
  *                      tracks.  This may have impact on the    *
  *                      insert or load performance.             *
  *                                                              *
  *                      DSNT408I SQLCODE = -904 00D70023        *
  *                      RC00D70023 Insufficient primary space   *
  *                      error during create tablespace or       *
  *                      index.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Instead of relying on the allocation unit, DSM will preformat
  the space up to two cylinders when pageset is initialized or
  extended.
  

Problem conclusion

• Instead of relying on the allocation unit, DSM will preformat
  the space up to two cylinders when pageset is initialized or
  extended.
  

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:

  UK08807

Modules/Macros

• DSNPIPP  DSNPXTN0
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK08807

     UP05/11/23 P F511

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.

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Product categories:

Software

Data Management

Data Servers (Database Management Systems)

DB2 for z/OS

Software version:

810

Reference #:

PK05644

IBM Group:

Software Group

Modified date:

2005-12-02