PH23909: ADMIN TOOL GEN NON-PBG TABLESPACE PART 1 MISSING; FREEPG MASK NOT HONORED; MASK EDITING SEGSIZE DSSIZE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses three issues regarding GEN of a
  non-PBG tablespace:
  
  1)  PART 1 of the CREATE TABLESPACE DDL may be omitted.
  
  
  2)  The FREEPG mask may not be honored at the tablespace level.
  
  3)  When editing a mask, SEGSIZE appears to be the parent of
  IXDSSIZE and TSDSSIZE.  With this fix applied, DSSIZE shows as
  the parent of IXDSSIZE and TSDSSIZE, and SEGSIZE is listed
  independently.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for z/OS. *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. The Reverse Engineering program      *
  *                      (GEN) does not always properly produce  *
  *                      the PART 1 clause for CREATE            *
  *                      TABLESPACE.                             *
  *                                                              *
  *                      2. Masking does not always correctly    *
  *                      handle the FREEPG mask line.            *
  *                                                              *
  *                      3. Incorrect masking hierarchy          *
  *                      displayed on ADB2EDIT.                  *
  ****************************************************************
  The following issues occur in various combinations of GEN and
  masking in Db2 12 for table spaces other than
  partition-by-growth (PBG) table spaces:
  
  1. The PART 1 clause of CREATE TABLESPACE might not be produced,
  even when its properties differ from the table space level. If
  partition 1 differs from the table-space level only by the
  FREEPAGE or PCTFREE value, PART 1 is not generated.
  
  2. FREEPG is not properly masked at the table space level and
  only masked at the partition level.
  
  3. This fix makes DSSIZE the parent of IXDSSIZE and TSDSSIZE,
  and SEGSIZE is listed independently.
  

Problem conclusion

• The problems have been resolved.
  

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:

  UI69457

Modules/Macros

• ADB2CMM  ADB2MSK  ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI69457

     UP20/06/01 P F005

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.