PK31969: OBJECT COMPARE GENERATES INVALID LOAD UTILITY FOR A PARTITIONED COMPRESSED TABLESPACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An invalid LOAD job was generated by Object Compare. The PART
  keyword must be used on compressed tablespaces with more than
  254 partitions. DSNU1146I #DSN8- DSNURWI - A MAXIMUM OF 254
  PARTS ARE ALLOWED TO BE PROCESSED WHEN THE TABLE SPACE IS
  COMPRESSED UNLESS THE PART KEYWORD IS USED
  

Local fix

• Turn compression off.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of  DB2 Object Comparison Tool,  who   *
  *                 request comparison with the  source  being   *
  *                 compressed tablespace having more than 254   *
  *                 partitions, are affected.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: An  invalid LOAD job was generated. The *
  *                      PART keyword must be used on compressed *
  *                      tablespaces greater than 254 partitions *
  *                      DSNU1146I #DSN8- DSNURWI - A MAXIMUM OF *
  *                      254  PARTS  ARE ALLOWED TO BE PROCESSED *
  *                      WHEN  THE  TABLE  SPACE  IS  COMPRESSED *
  *                      UNLESS THE PART KEYWORD IS USED.        *
  *                      .*                                      *
  *                      In a compare of two tablespaces, Source *
  *                      had  more  than  254 partitions and had *
  *                      compress  specified, the  Reload of the *
  *                      Tablespace gave the message DSNU1146I - *
  *                      A MAXIMUM OF 254 PARTS  ARE  ALLOWED TO *
  *                      BE PROCESSED.                           *
  *                      .* Note:                                *
  *                      A new message is generated  and the run *
  *                      of  Compare  is  terminated when source *
  *                      has more than  254  partitions  and has *
  *                      the  compress option.  Processing  will *
  *                      not allow the tablespace to be unloaded *
  *                      and reloaded.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

• R710 PSY UK21799

     UP07/02/06 P F702

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.