PI75630: DB2 ADMIN TOOL COMPARE W/CM OPTION AND SAVE COMPARE RESULTS GETS SQLCODE -803 IN INSERT DATA INTO ADBCMPREPOBJLINES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Doing a Compare and using Change Management option and
  specifying Save Compare Results YES gets:
     Unexpected sqlcode : -803 in Insert data into
                          ADBCMPREPOBJLINES
  

Local fix

• Specify Save Compare Results NO
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use Change Management.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using Change Management            *
  *                      and specifying YES for the option       *
  *                      'Save Compare Results' on panel         *
  *                      GOC5 'Generate Compare Jobs'            *
  *                      if an index's OWNER field was           *
  *                      changed, error SQLCODE=-803 /           *
  *                      SQLCODEN803 is issued.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using Object Compare and Change Management option 'Save
  compare results'= YES, changing the index's OWNER causes a
  SQLCODE=-803 / SQLCODEN803 error:
  
  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< CONSTRAINS COLUMNS
  OF THE TABLE SO NO TWO ROWS CAN CONTAIN
  DUPLICATE VALUES IN THOSE COLUMNS. RID OF
  EXISTING ROW IS <column_rid>
  DSNT418I SQLSTATE = 23505
  SQLSTATE RETURN CODE
  

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:

  UI46973

Modules/Macros

•    ADB2CME  ADB2CMP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI46973

     UP17/05/09 P F705

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.