PK34324: GOC WITH PARALLEL UNLOAD AND TARGET TABLESPACE HAS MORE PARTITIONS THAN THE SOURCE WSL GETS DSNU256I INVALID PARTITION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When customer changes target tablespace with 56 partitions to
  50 partitions and uses parallel unload in the GOC panel GOC5
  the Object Compare job runs and completes rc=0 but when the
  WSL runs it fails with rc=08 and
    DSNU256I  #DSN8- DSNURWI - INVALID PARTITION SPECIFICATION
  Load shows it is trying to load the higher number of partitions
  specified in the target instead of the lower number of
  partitions of the new target object.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of  DB2 Object Comparison  Tool,  who *
  *                 reduce a number of partitions for target and *
  *                 use  WSL  to  run  the  applied jobs, may be *
  *                 affected.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When target  tablespace  was reduced in *
  *                      partition  number   and   the  parallel *
  *                      unload in the GOC panel GOC5  was  used *
  *                      the Object Compare job ran and got RC=0 *
  *                      but, when the WSL ran it failed with RC *
  *                      being 08 and DSNU256I #DSN8 - DSNURWI - *
  *                      INVALID PARTITION SPECIFICATION.        *
  *                      .*                                      *
  *                      TEMPLATEs were used with &PART included *
  *                      in  the data set name, which causes DB2 *
  *                      to  unload  each partition into its own *
  *                      data set. This also means that the LOAD *
  *                      control  cards include clauses for each *
  *                      partition  and  thus the failure during *
  *                      LOAD when a reference to a non-existent *
  *                      partition is attempted.                 *
  *                      .*                                      *
  *                      The "parallel" option shouldn't be used *
  *                      for   DB2  UNLOAD   when  a  number  of *
  *                      partitions is reduced; hence DB2 unload *
  *                      all partitions to the same file.        *
  ****************************************************************
  * 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  GOC2CMR
  

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.