PK05167: GEN FUNCTION BUILDS CREATE TABLESPACE STATEMENT WITHOUT PRIQTY CLAUSE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool GEN function may build incomplete DDL
  for the CREATE TABLESPACE statement.  The PRIQTY clause was
  omitted from the CREATE TABLESPACE DDL when GEN was issued for
  a tablespace and on Panel ADB2GEN the following option is
  specified for tablespace size:
    Alloc TS size as. . . : USED
  .
  Additional symptoms: primary quantity missing
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who run    *
  *                 GEN to produce DDL for tablespaces and       *
  *                 who specify SPCALLOC USED for the space      *
  *                 calculation, may be affected.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: In  some  cases,  namely   when  the    *
  *                      perceptive  values  in systablespace    *
  *                      was 0,  the PRIQTY value was missing    *
  *                      from the generated DDL.                 *
  *                      .*                                      *
  *                      DB2 Administration Tool GEN function    *
  *                      may  build  incomplete  DDL  for the    *
  *                      CREATE  TABLESPACE  statement.   The    *
  *                      PRIQTY  clause  was omitted from the    *
  *                      CREATE  TABLESPACE  DDL when GEN was    *
  *                      issued for a tablespace and on Panel    *
  *                      ADB2GEN  the   following  option was    *
  *                      specified for tablespace size:          *
  *                        Alloc TS size as. . . : USED          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  GEN function builds CREATE TABLESPACE statement without
  PRIQTY clause.
  

Problem conclusion

• The ADB2REG has been changed so that in the reported case, the
  PRIQTY phrase is included, with a default space value of 3
  times the number of pages.
  

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:

Modules/Macros

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK05805

     UP05/08/04 P F508

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.