PM98388: DB2 ADMINISTRATION TOOL FOR Z/OS ISSUES SQLCODEN803 (-803) WHEN ANALYZE THE CHANGE AFTER COMPARE WITH SAVE RESULTS SET TO YES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS issues SQLCODEN803 (-803) when
  ANALYZE the change after COMPARE with Save Results set to YES
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 DB2 Object Comparison Tool for z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Analyze job generated by the        *
  *                      'AN - Analyze' line command on panel    *
  *                      ADB2C11 'CM - Changes' will result      *
  *                      in a SQLCODE=-803 / SQLCODEN803         *
  *                      due to the following scenario:          *
  *                                                              *
  *                      1.  User navigates to panel GOC5        *
  *                      'Generate Compare Jobs' and sets the    *
  *                      following two options:                  *
  *                                                              *
  *                       -  'Save compare results=YES'          *
  *                       -  'Changes file data set name' has    *
  *                           a value.                           *
  *                                                              *
  *                      2.  After pressing the Enter key on     *
  *                      panel GOC5, panel ADB2C22 'Save         *
  *                      Compare Jobs' will display.  Enter a    *
  *                      unique name for the input field 'Name'  *
  *                      and press Enter.                        *
  *                                                              *
  *                      3.  Submit the DB2 Object Compare       *
  *                      job.  RC=0 is expected.                 *
  *                                                              *
  *                      4.  User then navigates to panel        *
  *                      ADB2C11, issues the 'AN' line command   *
  *                      to Analyze any registered job that is   *
  *                      listed, and submits the Analyze job.    *
  *                      The Analyze job fails with a            *
  *                      SQLCODE=-803 / SQLCODEN803:             *
  *                                                              *
  *                      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:                                              *
  ****************************************************************
  The Analyze job generated by the 'AN - Analyze' line command
  on panel ADB2C11 'CM - Changes' will result in a SQLCODE=-803 /
  SQLCODEN803 due to the following scenario:
  
  1. User navigates to panel GOC5 'Generate Compare Jobs' and sets
  the following two options:
  
   -  'Save compare results=YES'
   -  'Changes file data set name' has a value.
  
  2. After pressing the Enter key on panel GOC5, panel ADB2C22
  'Save Compare Jobs' will display.  Enter a unique name for the
  input field 'Name' and press Enter.
  
  3. Submit the DB2 Object Compare job.  RC=0 is expected.
  
  4. User then navigates to panel ADB2C11, issues the 'AN' line
  command to Analyze any registered job that is listed, and
  submits the Analyze job.  The job fails with a SQLCODE=-803 /
  SQLCODEN803.
  

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:

  UK98532

Modules/Macros

• GOC5
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RA20 PSY UK98532

     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.