PH09482: OBJECT COMPARE TEMPORAL HISTORY TABLE UNEXPECTED SQLCODE : -803 IN INSERT DATA INTO ADBCMPREPOBJLINES SAVE COMPARE RESULTS YES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If a Compare job is run including temporal/history or
  archive/archive-enabled tables, with Save Compare Results =
  'YES' and 'Only Changed Objects = 'YES', an SQLCODE = -803 /
  sqlcoden803 error may result:
  Unexpected sqlcode : -803 in Insert data into ADBCMPREPOBJLINES
  DSNT408I SQLCODE = -803, ERROR:  AN INSERTED OR UPDATED VALUE
  IS INVALID
           BECAUSE INDEX IN INDEX SPACE indexspace-name
  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
  DSNT415I SQLERRP    = DSNXRINS SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -110  13172739  0  13817814  -490143744
  0 SQL DIAGNOST
           INFORMATION
  DSNT416I SQLERRD    = X'FFFFFF92'  X'00C90003'  X'00000000'
  X'00D2D7D6'
           X'E2C90000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

• Set Save Compare Results = 'NO' or 'Only Changed Objects = 'NO'.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Object Comparison Tool for  *
  *                 z/OS who compare temporal/history or         *
  *                 archive/archive-enabled table pairs.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Compare may result in a SQLCODE=-803 /  *
  *                      SQLNCODE803 when comparing changes      *
  *                      against history/archive tables.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A user may run into a SQLCODE=-803 when comparing
  history/archive tables:
  
  Unexpected sqlcode : -803 in Insert data into
  ADBCMPREPOBJLINES
  
  DSNT408I SQLCODE = -803, ERROR: AN INSERTED
  OR UPDATED VALUE IS INVALID
     BECAUSE INDEX IN INDEX SPACE indexspace-name
  CONSTRAINS COLUMNS OF THE TABLE
     SO NO TWO ROWS CAN CONTAIN DUPLICATE
  VALUES IN THOSE COLUMNS.
     RID OF EXISTING ROW IS >rid<.
  
  This error will occur only when the user is trying to save
  the compare results and wants Compare to report only objects
  that have changed.
  

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:

  UI63596

Modules/Macros

•    ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI63596

     UP19/06/14 P F906

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.