PI16263: INVALID VALUE FOR RESTART WITH IN AN IDENTITY COLUMN ALTER TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An invalid ALTER TABLE may occur in the SQL output by the source
  job to change START WITH identity on the target.
  .
  An example...
  ALTER TABLE CREATOR.TABLE1
  ALTER COLUMN COLUMN1
  RESTART WITH 12884902289;
  The RESTART WITH value is invalid.
  .
  The code has been changed to ensure the correct value is placed
  in the SQL output member.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Cloning Tool.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: An invalid ALTER TABLE may occur in     *
  *                      the SQL output by the source job to     *
  *                      change START WITH identity on the       *
  *                      target.                                 *
  *                      An example...                           *
  *                      ALTER TABLE CREATOR.TABLE1              *
  *                      ALTER COLUMN COLUMN1                    *
  *                      The RESTART WITH value is invalid.      *
  *                      The code has been changed to ensure     *
  *                      the correct value is placed in the      *
  *                      SQL output member.                      *
  ****************************************************************
  * 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:

  UI17727

Modules/Macros

• CKZ00545
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R310 PSY UI17727

     UP14/05/15 P F405

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.