PI63414: SUPPORT FOR MIGRATING PDB STATISTIC TABLES FROM VERSION 520 TO 530

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Support for migrating PDB Statistic Tables from version 520 to
  530
  
  Additional Keywords
  migrate Performance database DB2PM_STAT_STORAGE
  DB2PM_STAT_GENERAL DGOSUPDB
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - PDB                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Version 520 PDB Statistic Table         *
  *                      DB2PM_STAT_GENERAL has been split into  *
  *                      two tables DB2PM_STAT_GENERAL and       *
  *                      DB2PM_STAT_STORAGE in Version 530.      *
  ****************************************************************
  * RECOMMENDATION: Install this PTF if you plan to migrate      *
  *                 the Standard PDB Statistic Tables from 520   *
  *                 to 530. Follow the migration steps provided  *
  *                 by the technical documentation.              *
  ****************************************************************
  PROBLEM SUMMARY:
  PDB Statistic Table DB2PM_STAT_GENERAL exceeded the DB2 750
  column constraint. For this reason all storage related fields
  have been released to a new table DB2PM_STAT_STORAGE in
  Version 530.
  This PTF provides support to migrate a 520 DB2PM_STAT_GENERAL
  PDB table to 530 DB2PM_STAT_GENERAL and DB2PM_STAT_STORAGE
  tables.
  
  PROBLEM CONCLUSION:
  Two new samples will be provided by this PTF (DGOSLMGE,
  DGOSLMST). By unloading a standard 520 DB2PM_STAT_GENERAL PDB
  table to a dataset, use these samples to load the 520 data
  into 530 PDB tables DB2PM_STAT_GENERAL and
  DB2PM_STAT_STORAGE.
  
  KEYWORDS:
  PDB MIGRATION
  

Problem conclusion

Temporary fix

Comments

• PROBLEM SUMMARY:
  PDB Statistic Table DB2PM_STAT_GENERAL exceeded the DB2 750
  column constraint. For this reason all storage related fields
  have been released to a new table DB2PM_STAT_STORAGE in
  Version 530.
  This PTF provides support to migrate a 520 DB2PM_STAT_GENERAL
  PDB table to 530 DB2PM_STAT_GENERAL and DB2PM_STAT_STORAGE
  tables.
  
  PROBLEM CONCLUSION:
  Two new samples will be provided by this PTF (DGOSLMGE,
  DGOSLMST). By unloading a standard 520 DB2PM_STAT_GENERAL PDB
  table to a dataset, use these samples to load the 520 data
  into 530 PDB tables DB2PM_STAT_GENERAL and
  DB2PM_STAT_STORAGE.
  
  KEYWORDS:
  PDB MIGRATION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI39934

Modules/Macros

• DGOSLMGE DGOSLMST DGOSUPDB
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R530 PSY UI39934

     UP16/08/12 P F608

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.