PM72779: DB2 OBJECT COMPARISON TOOL FOR Z/OS GENERATES WHEN NOT EXPECTED "ALTER TABLESPACE TABLE SPACE NAME DSSIZE 4G"

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 OBJECT COMPARISON TOOL FOR Z/OS GENERATES WHEN NOT EXPECTED
  "ALTER TABLESPACE TABLE SPACE NAME DSSIZE 4G"
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who compare source PBG table space      *
  *                 with target segmented table space and are    *
  *                 converting the target segmented table space  *
  *                 to a Partitioned-by-Growth (PBG) table       *
  *                 space using the ALTER MAXPARTITIONS          *
  *                 statement on DB2 10 New Function Mode        *
  *                 (NFM).                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool for      *
  *                      z/OS generates an unnecessary ALTER     *
  *                      TABLESPACE >dbname<.>tsname< DSSIZE     *
  *                      4G statement in the APPLY job when      *
  *                      comparing source PBG table space with   *
  *                      target segmented table space which      *
  *                      converted the table segmented table     *
  *                      space to a PBG table space.             *
  *                                                              *
  *                      When converting segmented or simple     *
  *                      table space to a PBG table space        *
  *                      by altering the MAXPARTITIONS           *
  *                      value on DB2 10 NFM, DB2 will           *
  *                      automatically set the DSSIZE of the     *
  *                      table space to the default value 4G.    *
  *                      When the source PBG table space also    *
  *                      has a DSSIZE of 4G, Object Compare      *
  *                      generates the ALTER TABLESPACE          *
  *                      >dbname<.>tsname< DSSIZE 4G             *
  *                      statement in the APPLY job which        *
  *                      is unnecessary.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Object Comparison Tool for z/OS generates an
  unnecessary ALTER TABLESPACE >dbname<.>tsname< DSSIZE 4G
  statement in the APPLY job when comparing source PBG table
  space with target segmented table space which converted the
  target segmented table space to a PBG table space.
  
  When converting segmented or simple table space to PBG table
  space by altering the MAXPARTITIONS value on DB2 10 NFM, DB2
  will automatically set the DSSIZE of the table space to the
  default value 4G. When the source PBG table space also has a
  DSSIZE 4G, Object Compare generates the ALTER TABLESPACE
  >dbname<.>tsname< DSSIZE 4G statement in the APPLY job
  which is unnecessary.
  

Problem conclusion

• Problem has 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:

Modules/Macros

•    ADB2CMF
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK82101

     UP12/09/27 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.