PI06578: 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 the   *
  *                      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:

  UI13439

Modules/Macros

• GOCCI
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RB10 PSY UI13439

     UP13/12/13 P F312

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.