PM68380: CM COMPARE FAILS RC16 WITH PARSER MESSAGE, UNEXPECTED TOKEN AFTER (PART-COL.LIST) - EXPECTED (PART CLAUSE)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Compare Tool for z/OS fails rc16 with messages:
  .
  Unexpected token after (part-col.list) - expected (PART clause)
   ADB2PA: The following statement could not be parsed :
  .. CREATE TABLE statements appear here
  Token number =   2611, Token = )
  Unsuccessful parse of DDL statement.
  ADB2CID - Now terminating
  .
  Error shows CREATE TABLE DDL contains a clause similar to:
    IN >tsname< PARTITION BY ("" ASC, "" ASC, ...
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who use the MASK field SEGSIZE.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the MASK field SEGSIZE and   *
  *                      specifying the mask as 'SEGSIZE:*,n',   *
  *                      if the table space is partitioned, the  *
  *                      table space is converted to a range-    *
  *                      partitioned universal table space       *
  *                      (UTS).  If a table in a UTS has a       *
  *                      partitioned index and the partitioned   *
  *                      index needs to be created, DB2          *
  *                      generates a SQLCODE=-662 /              *
  *                      SQLCODEN662  error:                     *
  *                                                              *
  *                      DSNT408I SQLCODE = -662,                *
  *                      ERROR: A PARTITIONED                    *
  *                      INDEX CANNOT BE CREATED                 *
  *                      ON A NON-PARTITIONED,                   *
  *                      PARTITION-BY-GROWTH OR                  *
  *                      RANGE-PARTITIONED                       *
  *                      UNIVERSAL TABLE SPACE                   *
  *                      >tspace-name<.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Using the MASK field 'SEGSIZE:*,n' to mask the SEGSIZE of a
  table space, if the table space is partitioned, it would be
  changed to a UTS table space in DB2 9 New Function Mode (NFM)
  and above.  If a table in a UTS has a partitioned index and
  the partitioned index needs to be created, DB2 generates a
  SQLCODE=-662 / SQLCODEN662.
  

Problem conclusion

• Chapter 10 'Translation masks and ignore fields - Translation
  mask names' in the DB2 Object Comparison Tool for z/OS Version
  10.1 and 10.2 is modified:
  
  Tip: Use caution when specifying MASK field SEGSIZE.  The mask
  field might cause changes to the table space type.  For
  example, specifying the SEGSIZE mask might convert a
  partitioned table space to a range-partitioned universal
  table space (UTS). If a table in a UTS has a partitioned index
  and the partitioned index needs to be created, DB2 will
  generate SQLCODE=-662 during execution.
  
  A new message ADB3320W is added in mask:
  
  ADB3320W: SEGSIZE was masked from 0 to >outmask< for table
  space >table space name<.
  
  Explanation: If the original SEGSIZE value was 0, the
  input mask value might change the table space type.
  For example, specifying the mask SEGSIZE might convert a
  partitioned table space to a range-partitioned universal
  table space (UTS). If a table in a UTS has a partitioned
  index and and the partitioned index needs to be created,
  DB2 might generate SQLCODE=-662 during execution.
  
  System action: Processing continues.
  User response: Use valid inmask and try again.
  

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:

  UK93450 UK93451

Modules/Macros

•    ADB2CID  ADB2CMM  ADB2MSK  ADB2WCL  ADB3000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK93450

     UP13/04/18 P F304

• RA20 PSY UK93451

     UP13/04/18 P F304

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.