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

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 target 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
  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:

  UK81655

Modules/Macros

•    ADB2CMF
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK81655

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