PM90898: HPU/DB2 PARALLEL UNLOAD NOT ACTIVATED: INVALID PART SPEC IN LOAD CTRL STMT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When ALT table created in index-controlled partitioned
  tablespace, HPU Parallel UNLOAD and DB2 Parallel UNLOAD are NOT
  activated.  INVALID PARTITION SPECIFICATION is built in LOAD
  utility control statement for PBG tablespace when HPU Parallel
  UNLOAD is activated.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Object Comparison Tool      *
  *                 for z/OS who would like to activate DB2      *
  *                 Parallel UNLOAD/LOAD or High Performance     *
  *                 Unload (HPU) Parallel UNLOAD/LOAD for a      *
  *                 dropped and recreated table.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Two issues are addressed by this        *
  *                      APAR:                                   *
  *                                                              *
  *                      1- DB2 Admin and Object Compare         *
  *                      do not execute the UNLOAD/LOAD          *
  *                      in parallel for the index-based         *
  *                      partitioning table even when            *
  *                      setting 'Unload method' to 'P -         *
  *                      Parallel unload' or 'H - HPU'           *
  *                      on panels ADBPALT 'Build Analyze        *
  *                      and Apply Job' and GOC5 'Generate       *
  *                      Compare Job', and including             *
  *                      variable &PART. or &PA. in the          *
  *                      template for unloading data.            *
  *                                                              *
  *                      2- DB2 Admin and Object Compare         *
  *                      incorrectly activated HPU parallel      *
  *                      unload for the table in a Partition-    *
  *                      By-Group (PBG) table space which        *
  *                      results in a LOAD utility error         *
  *                      because an invalid partition            *
  *                      specification PART(n) is generated in   *
  *                      the LOAD control statement.             *
  *                                                              *
  *                      LOAD DATA RESUME YES                    *
  *                      SORTKEYS 10                             *
  *                      EBCDIC CCSID(37) ENFORCE NO             *
  *                      INTO TABLE                              *
  *                      <schema>.<tb-name>                      *
  *                      PART(1) INDDN U0000001                  *
  *                      DISCARDDN                               *
  *                      DISCDDNP ...                            *
  *                      Error message generated in              *
  *                      LOAD:                                   *
  *                      DSNU256I DSNURWI -                      *
  *                      INVALID PARTITION                       *
  *                      SPECIFICATION                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Two issues are addressed by this APAR:
  
  1- DB2 Admin and Object Compare do not execute the UNLOAD/LOAD
  in parallel for the index-based partitioning table even when
  setting 'Unload method' to 'P - Parallel unload' or 'H - HPU'
  on panels ADBPALT 'Build Analyze and Apply Job' and GOC5
  'Generate Compare Job', and including variable &PART. or &PA.
  in the template for unloading data.
  
  2- DB2 Admin and Object Compare incorrectly activated HPU
  parallel unload for the table in a Partition-By-Group
  (PBG) table space which results in a LOAD utility error
  because an invalid partition specification PART(n) is
  generated in the LOAD control statement.
  

Problem conclusion

• The program has been updated to enable parallel unload for the
  index-based partitioning table and disable parallel unload for
  the table in a PBG table space.
  

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

•    ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI24631

     UP15/01/27 P F501

• RB10 PSY UI24632

     UP15/01/27 P F501

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.