PH02595: MISSING AND INCORRECT DDL IN SEVERAL V5.4.0 PDB MIGRATION JOBS (DGO*UPDB)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• OMEGAMON Performance Expert DDL supplied in the TKO2SAMP library
  DGO*UPDB members for migration of the performance database (PDB)
  from 5.3.0 to 5.4.0 is incomplete and has several column names
  truncated.
  .
  TKO2SAMP(DGOSUPDB)
  .
  Customer states that some of the column names below are wrong
  for the STAT_DDF table:
  ALTER TABLE DB2PM_STAT_DDF DROP COLUMN STMTS_BOUND_SERVE
  RESTRICT;
  ALTER TABLE DB2PM_STAT_DDF DROP COLUMN ROWS_IN_MSG_BUF RESTRICT;
  ALTER TABLE DB2PM_STAT_DDF DROP COLUMN PREPARE_SENT RESTRICT;
  ALTER TABLE DB2PM_STAT_DDF DROP COLUMN PREPARE_RCD RESTRICT;
  ALTER TABLE DB2PM_STAT_DDF DROP COLUMN LAST_AGENT_SENT RESTRICT;
  ALTER TABLE DB2PM_STAT_DDF DROP COLUMN LAST_AGENT_RCD RESTRICT;
  ALTER TABLE DB2PM_STAT_DDF DROP COLUMN TWO_PHASE_COM_SEN
  RESTRICT;
  ALTER TABLE DB2PM_STAT_DDF DROP COLUMN TWO_PHASE_COM_RCD
  ALTER TABLE DB2PM_STAT_DDF DROP COLUMN TWO_PHASE_BACK_SN
  RESTRICT;
  ALTER TABLE DB2PM_STAT_DDF DROP COLUMN TWO_PHASE_BACK_RC
  RESTRICT
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM PDB users.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: OMEGAMON XE Performance Expert DDL      *
  *                      supplied in the TKO2SAMP library        *
  *                      DGO*UPDB members for migration of the   *
  *                      performance database (PDB) from 5.3.0   *
  *                      to 5.4.0 is incomplete and has several  *
  *                      column names truncated.                 *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  Several fields have been truncated or missed in the DDL provided
  for OMPE PDB migration.
  

Problem conclusion

• The DDL in the DGO*UPDB members has been corrected.
  
  Search Keywords:
  PDB MIGRATION
  

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:

  UI59756

Modules/Macros

• DGOAUPDB DGONUPDB DGOSUPDB DGOWBSFP DGOWDSFP DGOWUPDB DGOXUPDB
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI59756

     UP18/11/17 P F811

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.