PM97934: ARYX111E - A SQL ERROR OCCURRED WITH SQL CODE = -803 AND SQL STATE = 23505

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Error message
  "ARYX111E - A SQL error occurred with SQL code = -803 and SQL
  state = 23505.
  DSNT408I SQLCODE = -803, ERROR:  AN INSERTED OR UPDATED VALUE IS
  INVALID BECAUSE INDEX IN INDEX SPACE ARYR171C CONSTRAINS COLUMNS
  OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN
  THOSE COLUMNS. RID OF EXISTING ROW IS X'000004E699'."
  .
  may occur when Agent fails to parse the POR nodes (aryrpl34)
  properly when a single object reference spans multiple por nodes
  and the recovery plan generation is using on-demand strategy.
  

Local fix

• Dropping index ARYRP_PORS_IX or dropping and recreating the
  index as a non-unique index.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Recovery Expert z/OS.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: "ARYX111E - A SQL error occurred with   *
  *                       SQL code = -803 and SQL state = 23505. *
  *                       DSNT408I SQLCODE = -803, ERROR:  AN    *
  *                       INSERTED OR UPDATED VALUE IS INVALID   *
  *                       BECAUSE INDEX IN INDEX SPACE ARYR171C  *
  *                       CONSTRAINS COLUMNS OF THE TABLE SO NO  *
  *                       TWO ROWS CAN CONTAIN DUPLICATE VALUES  *
  *                       IN THOSE COLUMNS. RID OF EXISTING ROW  *
  *                       IS X'000004E699'."                     *
  *                      may occur when Agent fails to parse the *
  *                      POR nodes (aryrpl34) properly when a    *
  *                      single object reference spans multiple  *
  *                      por nodes and the recovery plan         *
  *                      generation is using on-demand strategy. *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

Modules/Macros

• ARY98604
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R310 PSY UI12315

     UP13/11/14 P F311

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.