PI46271: MIGRATE / MIG FUNCTION UNLOAD OPTIONS FOR HIGH PERFORMANCE UNLOA D / HPU

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• The DB2 Administration Tool for z/OS' MIG function does not
  support changing the High Performance Unload options.
  

Local fix

• None, new functionality being introduced.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Migrate (MIG) function      *
  *                 and DB2 High Performance Unload (HPU).       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Admin Tool does not provide     *
  *                      a method to control the parameters      *
  *                      passed to HPU when it is selected as    *
  *                      the 'Unload method' on panel ADB28M     *
  *                      'Migrate Parameters'.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Admin Tool does not provide a method to control the
  HPU parameters.
  

Problem conclusion

Temporary fix

Comments

• A new panel ADBPUSH 'Specify Utility Options - HPU' and help
  panel ADBHUSH 'HELP for HPU Utility Parameters' has been added
  to allow customers to specify DB2 HPU parameters.  The panel
  only applies to DB2 Admin's use of DB2 HPU, not to HPU's own
  product panels.
  
  DB2 Admin users can control HPU parameters by performing the
  following:
  
  1. Display a table on panel ADB21T 'Tables, Views and Aliases'
  or display a tablespace on panel ADB21S 'Table Spaces'.
  
  2. Issue the 'MIG - Migrate this table' line command or the
  MIG primary command, and then issue the 'NEXT' command on
  panel ADB28T 'Migrate Tables', or 'MIG - Migrate this
  tablespace' on panel ADB28S 'Migrate Table Spaces'.
  
  3. On panel ADB28M 'Migrate Parameters', issue the 'UO  -
  Customize utility options' primary command.
  
  4. On panel ADB2UOPS 'Change Utilities Options', select
  HPU from the menu.
  
  5. Fill in the options on new panel ADBPUSH.
  
  6. From new panel ADBPUSH, press the F1 key to see the new
  help panel ADBHUSH.
  
  7. To use HPU during the migrate, specify 'Unload Method = H'
  on panel ADB28M.
  
  Message ADB604E is changed.  Instead of the short message
  'Unrecognized hex format', the long message 'The field must
  contain a single byte or a hex digit' is displayed when an
  invalid delimeter value is specified on panel ADBPUSH or on
  panel ADB2USU 'Specify Utility Options - UNLOAD'.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI34736 UI34737

Modules/Macros

•    ADB$$PRM ADBEDIAG ADBEDUNL ADBE8T   ADBHUSH
  ADBHUSU  ADBPUSH  ADBR     ADBRPGM  ADBU02   ADB2DSN  ADB2PA
  ADB2PTPL ADB2TBLD ADB2UCUU ADB2UOPS ADB2UTCO ADB21D   ADB21S
  ADB21T   ADB25TL1 ADB27SP  ADB27SPC ADB28HPL ADB28HPM ADB28HPU
  ADB28HPV ADB28HPW ADB28M   ADB28M2  ADB28T   ADB60
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI34736

     UP16/01/28 P F601

• RB20 PSY UI34737

     UP16/01/28 P F601

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.