PM72608: DB2 OBJECT COMPARISON TOOL FOR Z/OS 10.2 NEW FUNCTION.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2 OBJECT COMARISON TOOL FOR Z/OS 10.2 NEW FUNCTION.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 DB2 Object Comparison Tool for z/OS who      *
  *                 are using DB2 10 New Function Mode           *
  *                 (NFM).                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare will fail when creating  *
  *                      DB2 LOAD utilities for partitioned      *
  *                      table spaces that are compressed and    *
  *                      exceed 254 partitions due to a          *
  *                      DSNZPARM (SPRMNUPT) that is no longer   *
  *                      used in DB2 10 NFM:                     *
  *                                                              *
  *                      'Load not supported for partitions >    *
  *                      254 with compression. Run               *
  *                      terminated.'                            *
  *                                                              *
  *                      The following enhancements in support   *
  *                      of DB2 features are delivered:          *
  *                                                              *
  *                      1. Extensions to CREATE and ALTER       *
  *                      statements to define and maintain       *
  *                      multiple versions of a SQL scalar       *
  *                      function:                               *
  *                                                              *
  *                      Examples:                               *
  *                                                              *
  *                      CREATE FUNCTION                         *
  *                         >function name< >parameter list<     *
  *                         RETURNS >parameter list<             *
  *                         VERSION >routine version id<         *
  *                         SPECIFIC >specific name<             *
  *                         >other routine options<              *
  *                         >function body<                      *
  *                                                              *
  *                      ALTER  SPECIFIC  FUNCTION               *
  *                         >specific/function name<             *
  *                         >alter options<                      *
  *                                                              *
  *                      ALTER  SPECIFIC  FUNCTION               *
  *                         >specific/function name<             *
  *                         ADD VERSION                          *
  *                         >routine version id<                 *
  *                                                              *
  *                      ALTER  SPECIFIC  FUNCTION               *
  *                         >specific/function name<             *
  *                         REPLACE VERSION                      *
  *                         >routine version id<                 *
  *                                                              *
  *                      ALTER  SPECIFIC  FUNCTION               *
  *                         >specific/function name<             *
  *                         DROP VERSION                         *
  *                         >routine version id<                 *
  *                                                              *
  *                      ALTER SPECIFIC FUNCTION                 *
  *                         >specific name<                      *
  *                         ACTIVATE VERSION                     *
  *                         >routine version id<                 *
  *                                                              *
  *                      2. Support for SQL table functions:     *
  *                                                              *
  *                      Example:                                *
  *                                                              *
  *                      CREATE FUNCTION >function name<         *
  *                         >parameter list<                     *
  *                         RETURNS TABLE >column list with      *
  *                         corresponding data types<            *
  *                         >other routine options<              *
  *                                                              *
  *                                                              *
  *                      3. Support for using a distinct type    *
  *                         in a native SQL procedure (NSP):     *
  *                                                              *
  *                      CREATE PROCEDURE >procedure name<       *
  *                         (>parameter name<                    *
  *                         >distinct type name<, ...)           *
  *                         VERSION >routine version id< ....    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The 'Load not supported for partitions > 254 with compression.
  Run terminated' issue has been resolved.  Enhancements are
  delivered.
  

Problem conclusion

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

• Problem has been resolved.
  Enhancements are delivered.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK83271

Modules/Macros

•    GOC$$SEQ GOCCCM   GOCGCMP  GOC2CMP  GOC2DTC
  H25GA20J
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RA20 PSY UK83271

     UP12/11/09 P F211 Ž

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.