PM98014: CHANGE MANAGEMENT: SQLCODEN803 INDEX SPACE ADBCIDX1 AFTER EDIT OF 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 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:

  UK98540 UK98541

Modules/Macros

• ADB2C5
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK98540

     UP13/10/22 P F310

• RA20 PSY UK98541

     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.