PH69944: COMPARE TO DO PBG TO PBR CONVERSION HAS DIFFERENT ERRORS WITH VALIDATE WSL = YES AND NO

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Compare that does PBG to PBR conversion. With VALIDATE_WSL parm
  equal YES, they get error during compare :
  
  ADB3009E An error occurred while processing the Index Index1
  object in the statement type of CREATE . The number of index
  partitions does not match the number of table space partitions
  
  When doing Compare with VALIDATE_WSL parm equal NO, an error
  occurs when running the WSL:
  
  ADB7955E DSNT408I SQLCODE = -650, ERROR: THE ALTER STATEMENT
  CANNOT BE EXECUTE CANNOT BE EXECUTED, REASON 57
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using compare to convert PBG to    *
  *                      PBR with VALIDATE_WSL=Yes, the user     *
  *                      receives error ADB3009E to report that  *
  *                      the partitions do not match.            *
  ****************************************************************
  A user is running compare to do a PBG to PBR table space
  conversion and specifies VALIDATE_WSL = Y to do the validation.
  The compare returns the following error:
  ADB3009E An error occurred while processing the Index Index1
  object in the statement type of CREATE. The number of index
  partitions does not match the number of table space partitions.
  

Problem conclusion

• The problem has been resolved.
  

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:

  UO07475

Modules/Macros

• ADB2CMT  ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO07475

     UP26/05/02 P F604

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.