PH00545: ADMIN TOOL MIGRATE SOURCE MASK HPU UNLOAD 256 STEPS IEFC602I EXCESSIVE NUMBER EXECUTE STATEMENTS ADB28M UNLDDN TEMPLATE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses two issues:
  1.  When executing MIGRATE with a mask and Unload Method=H
  (HPU), the source job will add an extra step (XIGN1) to extract
  the mask from a table and copy it to a dataset. If the number of
  tablespaces being migrated is already 255, MIGRATE will
  generate a job of more than 255 steps, and the following error
  message may then result when the job is run:
  IEFC602I   EXCESSIVE NUMBER OF EXECUTE STATEMENTS
  2.  MIGrate of a table space using panel ADB28M, with Unload
  method HPU, Generate  template statements = YES, and with
  template UNLDDN enabled, does not generate a template statement
  for DD name DAT01.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR addresses two issues:         *
  *                                                              *
  *                      1. When the Migrate (MIG) function      *
  *                      uses the HPU unload method with         *
  *                      masking enabled to process              *
  *                      more than 255 unique objects, the       *
  *                      following error message may be issued:  *
  *                                                              *
  *                      IEFC602I EXCESSIVE NUMBER               *
  *                      OF EXECUTE STATEMENTS                   *
  *                                                              *
  *                      2. MIGrate of a table space using       *
  *                      Unload method HPU, with Generate        *
  *                      template statements = YES, and with     *
  *                      template UNLDDN enabled, does not       *
  *                      generate a template statement           *
  *                      for DD name DAT01.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Issue 1:
  When the Migrate (MIG) function uses the HPU unload
  method with Masking enabled to process more than 255
  unique objects, the following error message is issued
  after submitting the generated Source and/or Target
  jobs:
  
  IEFC602I EXCESSIVE NUMBER OF EXECUTE STATEMENTS
  
  Issue 2:
  When MIG is used on a table space object using panel
  ADB28M, with template UNLDDN enabled and the following
  'Migrate Parameters' options set:
  
  Unload method = H (HPU)
  Generate template statements = YES
  
  a template statement is not generated for DD name
  DAT01.
  

Problem conclusion

• 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:

Modules/Macros

•    ADB28HPL ADB28HPU ADB28M   ADB28MM  ADB28M2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI58928

     UP18/10/12 P F810

• RC10 PSY UI58929

     UP18/10/12 P F810

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.