PI06563: CHANGE MANAGEMENT: SQLCODEN803 INDEX SPACE ADBCIDX1 AFTER EDIT O F IGNORE PANEL GOCCI 'SPECIFY IGNORE FIELDS: OBJECTS'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool issues a message SQLCODE -803 /
  SQLCODEN803 after exiting from panel GOCCI 'Specify Ignore Field
  'Specify Ignore Field: Objects':
   ADB2E2 in --------------------- DB2 Error Display 2
   Command ===>
      SQLCODE : -803                           DSNTIAR CODE :  0
  EXECUTE
  INSERT INTO >schema<.ADBCID  (SQLID,LEVEL)  VALUES
  (>sqlid<,>value<)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 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:

  UI13428

Modules/Macros

• ADB2C5
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI13428

     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.