PI41293: ARYZ008E ARYCSI SQLCODE811

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Error messages "ARYE003E--SQLERROR Pgm: ARYLHNFK Stmt: 00229
  Type:
  SELECT INTO.' and "ARYZ008E--ARYCSI   SQL code = -811, reason
  code = 00000000." may occur when recovering objects with RI and
  a RENAME INDEX has been performed on a primary index in the RI
  set.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Recovery Expert.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Error messages "ARYE003E--SQLERROR      *
  *                      Pgm: ARYLHNFK Stmt: 00229               *
  *                      Type: SELECT INTO.' and                 *
  *                      "ARYZ008E--ARYCSI   SQL code = -811,    *
  *                      reason code = 00000000." may occur      *
  *                      when recovering objects with RI and     *
  *                      a RENAME INDEX has been performed on    *
  *                      a primary index in the RI set.          *
  ****************************************************************
  * 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:

  UI30234

Modules/Macros

•    ARY@SCPY ARYLHNFK H30R310J
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R310 PSY UI30234

     UP15/08/21 P F508

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.