PK41507: FF720 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.
  f/f for r710 PK34324 forward fit ffPK34324
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 GOC Tool/V7 who reduce a number *
  *                 of  partitions for target and use WSL to run *
  *                 the applied jobs.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: The customer  is reducing the number of *
  *                      partitions from 56 down to 50. They use *
  *                      are using TEMPLATEs 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-all 56 of them - and thus the *
  *                      failure during LOAD when a reference to *
  *                      a non-existent partition is attempted.  *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  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.
  

Problem conclusion

• The problem has been fixed in Object Compare V7.2 by applying
  PTF.
  

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

•    GOCGAJOB GOCGCMP  GOC2CMF  GOC2CMP  GOC2CMR
  GOC2CMS
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK26557

     UP07/08/10 P F708

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.