Updating Statistics tables to V5.3.0

Because in Performance Database V5.3.0, the DB2PM_STAT_GENERAL table was split into two tables DB2PM_STAT_GENERAL and DB2PM_STAT_STORAGE, you must manually update Statistics tables to V5.3.0 and again to V5.4.0 as part of your update to Performance Database V5.4.0.

About this task

The V5.3.0 T/RKO2SAMP library includes two new members DGOSLMGE and DGOSLMST added with APAR PI63414 for use in the Db2 Load Utility. These two new members enable you to load V5.2.0 Statistics table data.

Note:

After you execute ALTER TABLE statements, Db2 might place the table space containing the modified data in advisory REORG-pending (AREO*) status because existing data is not immediately converted to its new definition. You can reorganize the table space to prevent possible performance degradation. When data is in REORG-pending or AREO* status, you can automatically re-organize partitions using the REORG utility with the SCOPE PENDING option - you do not need to identify which partitions need to be reorganized or customize the REORG control statement.

Procedure

  1. Run the ALTER TABLE statements to add new columns to statistics tables as listed in V5.2.0 member T/RKO2SAMP(DGOSUPDB).
  2. Unload the V5.2.0 DB2PM_STAT_GENERAL to reload in a later step.
  3. Request the current V5.3.0 library T/RKO2SAMP library from IBM support.
  4. Migrate the DB2PM_STAT_GENERAL data from earlier version to the V5.3.0 tables:
    • Migrate the DB2PM_STAT_GENERAL data from the earlier version to the V5.3.0 tables:
    • Create the two new Statistics tables DB2PM_STAT_GENERAL and DB2PM_STAT_STORAGE.
    • Reload the unloaded data from the earlier version using the two V5.3.0 DML Load members DGOSLMGE and DGOSLMST available in V5.3.0 library T/RKO2SAMP.
  5. Run the remaining ALTER TABLE statements that apply to V5.3.0 to add columns as listed in members DGOSUPDB in the V5.3.0 library T/RKO2SAMP.
  6. Adapt the Statistics spreadsheet field selection list members T/RKANSAMF to the new split Statistics tables.