PK49066: INVALID TOKEN AFTER PART INTEGER - EXPECTED ENDING CLAUSE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparision Tool batch job ends RC=16 with the
  message:
  Invalid token after PART integer - expected ENDING clause
  when processing DDL for a partitioned index.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: In R710,when user does compare Source DDL (  *
  *                 having create unique index with Partitions), *
  *                 with Catalog database,the results in return  *
  *                 code 16.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: database compare, when source DDL is    *
  *                      having create unique  index with the    *
  *                      Partitions,  results in parser error    *
  *                      'Invalid Token  after PART integer -    *
  *                      expected  ENDING clause' with return    *
  *                      code 16.                                *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The  problem is due  to parser is  expecting ENDING clause when
  PARTITION BY RANGE is specified in create unique index. Changes
  are  done so that  ENDING clause keyword is optional for CREATE
  INDEX cluster.
  

Problem conclusion

• The problem is been fixed both in V7.1 and in  V7.2.
  

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

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK33038

     UP08/01/25 P F801

• R720 PSY UK33039

     UP08/01/25 P F801

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.