PK62897: SQLCODE = -603, ERROR: A UNIQUE INDEX CANNOT BE CREATED BECAUSETHE TABLE CONTAINS ROWS WHICH ARE DUPLICATES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After applying latest maintenance and started OMEGDB2 with the
  PERFORMANCEWAREHOUSE=YES option get an SQLCODE = -603, ERROR in
  OMEGDB2.
  .
  DSNT408I SQLCODE = -603, ERROR:  A UNIQUE INDEX CANNOT BE
  CREATED BECAUSE THE TABLE CONTAINS ROWS WHICH ARE DUPLICATES
  WITH RESPECT TO THE VALUES OF THE IDENTIFIED COLUMNS
  SQLCODE603
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   PE Server                                *
  *                 -   Performance Warehouse users              *
  ****************************************************************
  * PROBLEM DESCRIPTION: If the PERFORMANCE WAREHOUSE function   *
  *                      is active, the database migration       *
  *                      during start-up may fail with           *
  *                      SQLCODE -603.                           *
  *                      The SYSPRINT output of the PE Server    *
  *                      shows an SQLCODE -603 in module         *
  *                      DSNXICX2 and the System Log shows       *
  *                      message FPEV5004S.                      *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  During the migration process some PWH tables are altered.
  In the meanwhile when the unique indexes are dropped but still
  not recreated, the DB2 Performance Expert agents, if any,
  may keep inserting rows into the tables DB2PM.DB2C_SYSTEM
  and DB2PM.DB2C_APPLICATION, thus causing the
  "duplicate rows" problem.
  
  PROBLEM CONCLUSION:
  The tables DB2PM.DB2C_SYSTEM and DB2PM.DB2C_APPLICATION are
  locked while PWH processes the migration steps and are
  released for inserts by the DB2 Performance Expert Agent
  after PWH completes migration.
  

Problem conclusion

• For V310:
  The service level of the
  OMEGAMON server subtask PESERVER
  FPEV0000I  DATA SERVER INITIALIZATION
  FPEV0114I  PTF BUILD IS 08.107
  
  For V410:
  The service level of the
  OMEGAMON server subtask PESERVER
  FPEV0000I  DATA SERVER INITIALIZATION
  FPEV0114I  PTF BUILD IS 08.107
  
  The tables DB2PM.DB2C_SYSTEM and DB2PM.DB2C_APPLICATION are
  locked while PWH processes the migration steps and are
  released for inserts by the DB2 Performance Expert Agent
  after PWH completes migration.
  
  KEYWORDS : PWH MIGRATION SQLCODE -603 UNIQUE INDEXES
  DUPLICATE ROWS
  

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:

  UK35622 UK35623

Modules/Macros

•    DGO@TBL  DGOVMSTR DGOZTBL
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK35622

     UP08/04/18 P F804

• R410 PSY UK35623

     UP08/04/18 P F804

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.