PK13528: SQLCODE -199 ON ALTER TABLE STATEMENT IN DB2 V8

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In version 8 of DB2, when restoring a table that contains a
  foreign key, Object Restore rebuilds the alter statement
  incorrectly and a SQLCODE-199 is produced.
  
  OTHER KEYWORDS: SQLCODE199 199 -199
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Restore.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: In version 8 of DB2, when restoring a   *
  *                      table that contains a foreign key,      *
  *                      Object Restore rebuilds the alter       *
  *                      statement incorrectly and a             *
  *                      SQLCODE-199 is produced.                *
  ****************************************************************
  * 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

•    AUO$NOTP
  

Fix information

• Fixed component name

  DB2 OBJECT REST

• Fixed component ID

  5655E7201

Applicable component levels

• R210 PSY UK10416

     UP06/01/18 P F601

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.