PK62187: DSNT408I SQLCODE -109 WHEN PARTITIONED TABLE WITH DSSIZE CHANGED TO NON PARTITIONED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Analyze fails on step WSLVAL6  with RC08 and msg DSNT408I
  SQLCODE = -109  ERROR:  DSSIZE WITHOUT NUMPARTS
  OR LOB CLAUSE IS NOT PERMITTED.  This message is generated
  when a partitioned table with dssize  is changed to
  non-partitioned.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Object Compare v7.2 altering        *
  *                 tablespace from partitioned to simple.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: If tablespace is altered from           *
  *                      partitioned to simple and DSSIZE is     *
  *                      specified in ignore file, the DSSIZE    *
  *                      is included in DDL of nonpartitioned    *
  *                      tablespace.                             *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  If tablespace is altered from partitioned to simple DSSIZE
  should not be included in the DDL of nonpartitioned tablespace
  regardless if it has been specified in ignore file or not.
  

Problem conclusion

• The problem has been 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
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK36526

     UP08/05/30 P F805

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.