PK70140: OC WSL FAILS SQLCODEN661 -661 WHEN CHANGING NUMBER OF PARTITIONS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparision Tool created DDL which results in
  a SQLCODE -661 error on a CREATE TABLE statement as the number
  of partitions in the CREATE TABLESPACE does not match the table
  definitions partitioning information.
  
  Additional search args:
  SQLCODEN661 NUMPARTS table-based partitioning
  

Local fix

• Manual correct the TABLESPACE NUMPARTS value.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool Ver 7.2. *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool created  *
  *                      DDL  which results  in a  SQLCODE -661  *
  *                      error  on a CREATE  TABLE statement as  *
  *                      the number of partitions in the CREATE  *
  *                      TABLESPACE  does not  match the  table  *
  *                      definitions partitioning information.   *
  ****************************************************************
  * RECOMMENDATION: When  the comparing  tables  that  use       *
  *                 table-controlled partitioning,   it is       *
  *                 recommended to provide a definition of       *
  *                 the tablespace containing the table.         *
  ****************************************************************
  The  DB2 Object Comparison Tool  created DDL which results in a
  SQLCODE  -661 error on  a CREATE TABLE  statement as the number
  of partitions in the CREATE TABLESPACE does not match the table
  definitions partitioning information.
  
  Object Compare will change Numparts in the resulting tablespace
  definition  if all partitions  of the target tablespace are the
  same. Otherwise the following  warning message will be produced
  in the Compare report:
  
  Warning: The source tablespace definition was not found.
           The result for the recreated tablespace may be
           incorrect. Table will be recreated
  
  GOC2CMP - Error(s) found. Please review output.
  
  Additional search args:
   SQLCODEN661 NUMPARTS table-based partitioning
  

Problem conclusion

• The problem was fixed.
  

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

•    GOC2CMF  GOC2CMR
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK41565

     UP08/11/21 P F811

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.