PI07463: MIG 'SCOPE OF MIGRATE:' / 'CATALOG STATISTICS' USES LOCAL SYSTEM S INDEXSPACE NAME RATHER THAN THE TARGET SYSTEMS INDEXSPACE NAME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' MIG function's panel
  ADB28M 'Migrate Parameters', 'Scope of migrate:' option
  'Catalog statistics' Yes results in the INDEXSPACE name of the
  source system being used in the resulting SQL INSERT statement
  for SYSIBM.SYSINDEXSPACESTATS rather than the INDEXSPACE name
  for the target system.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Generate (GEN) to generate the  *
  *                 statistics for SYSIBM.SYSINDEXSPACESTATS.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      Migrate (MIG) function panel ADB28M     *
  *                      'Migrate Parameters', 'Scope of         *
  *                      migrate:' option Catalog statistics=    *
  *                      Yes results in the INDEXSPACE name of   *
  *                      the source system being used in the     *
  *                      resulting SQL INSERT statement for      *
  *                      SYSIBM.SYSINDEXSPACESTATS rather        *
  *                      than the INDEXSPACE name for the        *
  *                      target system.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Generated statistics for SYSIBM.SYSINDEXSPACESTATS uses the
  source INDEXSPACE name which is incorrect.
  

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:

  UI14217

Modules/Macros

• ADB2RES
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI14217

     UP14/01/16 P F401

• RA20 PSY UI14218

     UP14/01/16 P F401

• RB10 PSY UI14219

     UP14/01/16 P F401

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.