PK19104: SQLCODE -205 ON ALTER TABLE STATEMENT IN DB2 V8

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An SQLCODE205 is produced when Object Restore generated DDL is
  run.
  The error is produced due to trailing values on PRIMARY KEY
  column names.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Restore.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: An SQLCODE205 is produced when Object   *
  *                      Restore generated DDL is run. The error *
  *                      is produced due to trailing values on   *
  *                      PRIMARY KEY column names.               *
  ****************************************************************
  * 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:

  UK15885

Modules/Macros

•    AUO$BPRF AUO$DOPT AUO$DPBK AUO$DPBP AUO$DPDB
  AUO$DPDT AUO$DPIX AUO$DPSG AUO$DPSR AUO$DPTB AUO$DPTR AUO$DPTS
  AUO$DPTV AUO$D8BK AUO$D8BP AUO$D8DB AUO$D8DT AUO$D8IX AUO$D8SG
  AUO$D8SR AUO$D8TB AUO$D8TR AUO$D8TS AUO$D8TV AUO$IOPT AUO$MAIN
  AUO$MAN2 AUO$NFM1 AUO$NFM2 AUO$NOTC AUO$NOTI AUO$NOTP AUO$NOTS
  AUO$PRFP AUO$PRF1 AUO$PRF2 AUO$PRF3 AUO$PRF4 AUO$PROF AUO$PSET
  AUO$REST AUO$ROPT AUO$RROM AUO$WOPT AUO#BKV8 AUO#LXXX AUO#TBG7
  AUO#TBG8 AUO#TVG7 AUO#TVG8 AUO@BKRD AUO@BKR8 AUO@BPRD AUO@BPR8
  AUO@DBRD AUO@DBR8 AUO@DB2V AUO@DDL7 AUO@DDL8 AUO@DTRD AUO@DTR8
  AUO@IXRD AUO@IXR8 AUO@RBND AUO@RIG8 AUO@SGRD AUO@SGR8 AUO@SRRD
  AUO@SRR8 AUO@SSR8 AUO@TBRD AUO@TBR8 AUO@TRRD AUO@TRR8 AUO@TSRD
  AUO@TSR8 AUO@TVRD AUO@TVR8 AUO07    H23L210J
  

Fix information

• Fixed component name

  DB2 OBJECT REST

• Fixed component ID

  5655E7201

Applicable component levels

• R210 PSY UK15885

     UP06/07/17 P F607

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.