PK52292: PE AGENT FOR DB2 CONNECT SQL0803N -803 WHEN ATTEMPTING INSERT IN DB2PM.DB2C_SYSTEM TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Agent for DB2 Connect Component ID 5655OPE00 SQL0803N Error
  inserting duplicate row in DB2PM.DB2C_SYSTEM (-803). Cust e2elog
  ->SQL0803N  One or more values in the INSERT statement invalid,
  because unique contraint or unique index identified by
  ""constrains table"" prevent duplicate rows for those columns.
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Performance Expert Agent for             *
  *                     DB2 Connect Monitoring                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Performance Expert Agent for DB2        *
  *                      Connect can not insert performance data *
  *                      to the tables of performance database.  *
  *                                                              *
  *                      Error message in the agent's log:       *
  *                                                              *
  *                      SQL0803N  One or more values in the     *
  *                      INSERT statement invalid,               *
  *                      because unique contraint or unique      *
  *                      index identified by                     *
  *                      ""constrains table"" prevent duplicate  *
  *                      rows for those columns.                 *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF.                              *
  ****************************************************************
  Performance Expert Agent for DB2 Connect can not insert
  performance data to the tables of performance database.
  
  This happens when the Agent tries to insert the data at the same
  moment when the server tries to get and process (clear) the
  tables.
  

Problem conclusion

• Performance Expert Agent for DB2 Connect can not insert
  performance data to the tables of performance database.
  
  KEYWORDS : SQL0803N
  

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:

  UK30400 UK30401

Modules/Macros

•    DGOAGSOL FPEKAGSL FPEKAGUX FPEKSL32
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK30400

     UP07/10/24 P F710

• R410 PSY UK30401

     UP07/10/24 P F710

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.