PK42146: CATALOG COPY GENERATES INCORRECT PRIQTY SECQTY VALUES,0C4 IN GEN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool the CC Catalog Copy function can
  produce incorrect PRIQTY and SECQTY values for CC objects.
  Under and over allocations are reported.
  .
  Reported objects: INDEX DSNKSX01 and CC4K tablespace but
  potential exists for other objects, especially those that
  receive a line similar to the following from the GEN step:
    --  VCAT "00000001" -- DB2 catalog index
  These objects receive a default of 100 50 for PRIQTY and
  SECQTY, respectively.
  

Local fix

• Edit job to break CC job into two parts, with break after
  ISPFBAT step. Modify SQL to provide space allocations that work
  well for your environment, before executing remainder of
  jobsteps.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of catalog copy where catalog indexes  *
  *                 can be large.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Catalog copy today produces DDL using   *
  *                      GEN for the catalog indexes using the   *
  *                      'User-Defined' storage allocation.      *
  *                      This can result in catalog indexes in   *
  *                      the  catalog copy  being defined with   *
  *                      insufficient space.                     *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The change is to  create the DDL using a DB2 defined space
  allocation with a STOGROUP and PRIQTY and SECQTY values.
  These latter are based on the space used by the objects in
  the catalog from which the copy is being made.
  

Problem conclusion

• The requested function has been provided.
  

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:

  UK27983 UK27984

Modules/Macros

•    ADB1000  ADB2CJDB ADB2GEN  ADB2RE   ADB2REE
  ADB2REG  ADB2REZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK27983

     UP07/08/09 P F708

• R720 PSY UK27984

     UP07/08/10 P F708

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.