PQ94204: SQLCODE181 LOADING REPOSITORY TABLE RS.SYSINDEXS IF A ROW IN SYSIBM.SYSINDEXES REFERENCES A NON-EXISTENT PARENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A -181 SQL error can occur ( resulting in a U0016 abend ) when
  running the Object Restore
  repository load job. This is caused by a situation where a row
  exists in SYSIBM.SYSINDEXES but that row erroneously references
  a non-existent parent table. The result is an erroneous
  date/time value in the load record. Later, when Object Restore
  attempts to load the row, a -181 is produced and the repository
  load job ends with RC12. Job output also shows the
  following message: AUO#IXU7 MODULE ERROR DETECTED.
  
  KEYWORDS:
  SQLCODE181 181 RC12 ABENDU0016 U0016
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Restore.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: A -181 SQL error can occur              *
  *                      (resulting in a U0016 abend ) when      *
  *                      running the Object Restore repository   *
  *                      load job. This is caused by a situation *
  *                      where a row exists in SYSIBM.SYSINDEXES *
  *                      but that row erroneously references     *
  *                      a non-existent parent table. The result *
  *                      is an erroneous date/time value in the  *
  *                      load record. Later, when Object Restore *
  *                      attempts to load the row, a -181 is     *
  *                      produced and the repository load job    *
  *                      ends with RC12. Job output also shows t *
  *                      following message:                      *
  *                      AUO#IXU7 MODULE ERROR DETECTED.         *
  *                                                              *
  *                      KEYWORDS:                               *
  *                      SQLCODE181 181 RC12 ABENDU0016 U0016    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  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:

  UQ93395

Modules/Macros

•    AUO#IXU7
  

Fix information

• Fixed component name

  DB2 OBJECT REST

• Fixed component ID

  5655E7201

Applicable component levels

• R210 PSY UQ93395

     UP04/10/05 P F410

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.