PM98251: DB2 OBJECT COMPARISON TOOL RECEIVES SQLCODEN803 ON INSERT ON ADBCID.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Received a SQLCODE=-803 from COMPARE when defining the Ignore
  specification.
  DSNT408I SQLCODE = -803, ERROR:  AN INSERTED OR UPDATED VALUE
  IS INVALID BECAUSE INDEX IN INDEX SPACE <INDEX_SPACE_NAME>
  CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN
  DUPLICATE VALUES IN THOSE COLUMNS.  RID OF EXISTING ROW IS
  <RID>.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who specify Compare ignore fields       *
  *                 containing a data set just after the insert  *
  *                 of a new ID into the Change Management       *
  *                 ID table.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Object Comparison Tool for z/OS, *
  *                      when specifying Compare ignore fields   *
  *                      that are stored in a data set just      *
  *                      after inserting a new ID into the       *
  *                      Change Management ID table on panel     *
  *                      ADB2C5 'Manage ID Table', an            *
  *                      SQLCODE=-803 / SQLCODEN803 is issued    *
  *                      when exiting from panel GOCCI 'Specify  *
  *                      Ignore Fields: Objects' to save the     *
  *                      ignore fields specification:            *
  *                                                              *
  *                      DSNT408I SQLCODE = -803,                *
  *                      ERROR:  AN INSERTED OR UPDATED          *
  *                      VALUE IS INVALID BECAUSE INDEX          *
  *                      IN INDEX SPACE >index_space<            *
  *                      CONSTRAINS COLUMNS OF THE               *
  *                      TABLE SO NO TWO ROWS CAN                *
  *                      CONTAIN DUPLICATE VALUES IN             *
  *                      THOSE COLUMNS.                          *
  *                                                              *
  *                      RID OF EXISTING ROW IS >RID<.           *
  *                      DSNT418I SQLSTATE   = 23505             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An SQLCODE=-803 / SQLCODEN803 error is issued when exiting from
  panel GOCCI to save the ignore fields specification.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK98491 UK98492

Modules/Macros

• GOCCI
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RA10 PSY UK98491

     UP13/10/22 P F310

• RA20 PSY UK98492

     UP13/10/22 P F310

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.